import excel spreadsheets ?

[Jarod]

Hey
How to import excel to my application ? I need access to all fileds in
spreadsheets just to take data. Excel file works as a "dictionary" in my
case. Can you tell me how to use it in application ? I never imported any
excel data to my apps so my knowledge is pretty low. I saw some examples of
using Jet Engine. Can I use jet engine on .xls files or I need csv ? Share
some articles or experience please
Jarod

 

[Morten Wennevik]

Hi Jarod

There are several articles on how to read and write excel files using oledb. Just search for "reading excel files using oledb". For instance

"Reading and Writing Excel using OLEDB"
http://www.codeproject.com/csharp/Excel_using_OLEDB.asp

Reading Excel (.xls) Files with ADO.NET
http://www.dotnetjohn.com/articles.aspx?articleid=54

 

[Jarod]

There are several articles on how to read and write excel files using

oledb. Just search for "reading excel files using oledb".

So is it possible to create Typed Dataset from some template Excel
spreadsheet ?
Jarod

 

[Morten Wennevik]

Yes, oledb jet engine is what you would use. You typically use it to query excel sheets (.xls) without having office installed. If you are unfamiliar with the OleDb class and/or ado.net you might want to check the news group microsoft.public.dotnet.framework.adonet

Another article for you
http://www.dotnetspider.com/qa/Question28885.aspx

 

[Morten Wennevik]

Ah, sorry, news reader tricked me into thinking this was a reply to my previous message :/