import excel spreadsheets ?

11 Mar 2006 12:44 PM

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

11 Mar 2006 1:50 PM

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

--
Happy coding!
Morten Wennevik [C# MVP]

11 Mar 2006 2:44 PM

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

11 Mar 2006 2:52 PM

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

On Sat, 11 Mar 2006 13:44:30 +0100, Jarod <blueice@NOSPAM.gazeta.pl> wrote:

> 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
>
>

--
Happy coding!
Morten Wennevik [C# MVP]

11 Mar 2006 3:03 PM

Morten Wennevik

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

On Sat, 11 Mar 2006 15:52:38 +0100, Morten Wennevik <MortenWenne***@hotmail.com> wrote:

Show quoteHide quote

> 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
>
>
> On Sat, 11 Mar 2006 13:44:30 +0100, Jarod <blueice@NOSPAM.gazeta.pl> wrote:
>
>> 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
>>
>>
>
>
>

--
Happy coding!
Morten Wennevik [C# MVP]