working with .xls (excel) files

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Set a COM reference to "Microsoft Excel #.# Object Library", and then create
and use an instance of the Excel.ApplicationClass object.
 
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.
 
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;
 
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.
 
Back
Top