exporting data in excel to C# dataset

[Mike P]

How do you go about exporting data in excel to a C# dataset?

Any help would be really appreciated.


Cheers,

Mike

 

[Nicholas Paldino [.NET/C# MVP]]

Mike,

The easiest way would be to use an OleDbDataAdapter and use the Jet
provider for OLEDB, as it can read Excel workbooks.

Hope this helps.

 

[Jan]

Hi Mike,
You have few options:
a) Use excel automation (excel object) to read data from XLS file and
fill the dataset.
b) Use some third-party component, like ExcelLite (free if you need
less than 150 rows).
For comparison, see:
http://www.gemboxsoftware.com/ExcelLite.htm#Automation
Regards,
Jan