Can data from excel sheet be called in a c# program?

Question

1.00/5 (1 vote)

See more:

I have the data from the user on an excel sheet. I need to use that data in the logic. So is it possible to call an excel data in while running the code ?

Posted 11-Jan-16 17:50pm

Member 12247039

Add a Solution

Comments

Sergey Alexandrovich Kryukov 12-Jan-16 0:00am

There is no such concept, "call data". What exactly do you want to achieve? What's the problem?
Of course you can read data from an Excel file, if this is what you mean.
—SA

Member 12247039 12-Jan-16 0:08am

@Sergey...There is a cost matrix (2D array) in excel sheet. That is the input from the user. I want to use that matrix and start my logic. After the first iteration, I want to modify the excel sheet data and store it in a different excel sheet. For further iterations, I want to use the modified excel sheet and keep modifying the same till my problem ends.

Sergey Alexandrovich Kryukov 12-Jan-16 0:25am

One way is ADO.NET with ACE (see the comment below), another one would be Microsoft Open XML Format SDK. And so on...
—SA

PIEBALDconsult 12-Jan-16 0:03am

Yes, there are many ways to access data in an Excel file from C# and most other languages.
I prefer to use the ADO.net classes and the ACE engine.

deepankarbhatnagar 12-Jan-16 0:11am

Data can export from excel to any databound control in asp.net

BulletVictim 12-Jan-16 0:37am

Go and take a look at http://www.syncfusion.com/ fairly easy importing 3rd Party DLL for excel. If not that any way you want to then.
In Regards to using the excel sheet at runtime. Sure you can use the information on the sheet. Easiest way I have found to work with excel sheets at runtime is to use DataTables. Then working from the DataTable you can pretty much do anything with the information from the sheet.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Garth J Lancaster · Answer 1 · 2016-01-11T18:11:00

If you are just talking about 'using Excel data' from c#, you have a number of options

1) export the data from excel as csv/tsv to a file and read that file in c# : easy

2) use Excel Interop from C# : Way more complex - see this for a start (but you'll need to do a lot more research' likely) http://www.dotnetperls.com/excel[^]

3) I believe you can use ADO.NET to read data from an Excel spreadsheet - you'll need to Google for 'how to set it up'

4) There may be 3rd party solutions free or not that can read Excel Spreadsheets

obviously the choice on 1,2,3,4 depends on many things, none of which we can ascertain on the information you've provided

Richard MacCutchan · Answer 2 · 2016-01-11T21:51:00

Solution 2

See Working with MS Excel(xls / xlsx) Using MDAC and Oledb[^].

Posted 11-Jan-16 21:51pm

Richard MacCutchan