working with .xls (excel) files

[menkaur]

Hi! Does anyone know how to open excel (.xls) file (and read data from it)? I
tryed to do it using oleDb, but it falied.

[Bonj]

Set a COM reference to "Microsoft Excel #.# Object Library", and then create
and use an instance of the Excel.ApplicationClass object.
"menkaur" wrote:

Hi! Does anyone know how to open excel (.xls) file (and read data from it)? I
tryed to do it using oleDb, but it falied.

[tonymjohn]

See http://www.dotnetspider.com/technology/KBPages/361.aspx

*-----------------------*
Posted at:
www.GroupSrv.com
*-----------------------*

[menkaur]

Thenks for info.
But i still have problems with reading data: i can't convert
Worksheet.Cells[x,y] to eny known types. typeof says, the type of returned
object is System.__ComObject. This type and Variant are protected System
members. Do You know, what type shood be used here?

An other problem: how to terminate created Excel.Application after i do not
need it? - it stays in memory even after application closes.

[Bonj]

Try getting the Value property and casting it to what value you think it
should be. Leave it as object (or string) if you don't know.
e.g.
Excel.Worksheet shtData;
....
int i = (int)shtData.Cells[x,y].Value;
string s = shtData.Cells[p,q].Value.ToString();
object o = shtData.Cells[r,s].Value;

"menkaur" <me*****@discussions.microsoft.com> wrote in message
news:1C**********************************@microsof t.com...

Thenks for info.
But i still have problems with reading data: i can't convert
Worksheet.Cells[x,y] to eny known types. typeof says, the type of
returned
object is System.__ComObject. This type and Variant are protected System
members. Do You know, what type shood be used here?

An other problem: how to terminate created Excel.Application after i do
not
need it? - it stays in memory even after application closes.

[menkaur]

Thenks for help.

May be you know how can i shoot down EXEL.exe process after i've finished
working with it. In ceps beeng in memory after Excel.ApplicationClass object
is destroyed.