Getting info from excel.

[Falcon]

I'm displaying an Excel spreadsheet using a data gird control in a
winform using oleDB objects and so far Data is displaying correctly.

I'm having difficulties getting cell style information for each
cell in the xls file (Excel spreadsheet) .


Does anyone have an idea how to pull that information out from an xls
file?


Thanks.

 

[Bryan Phillips]

You can't get cell style information using OleDB.

So you will need to either:

- Instantiate Excel to get the information.
- Programmatically get the xls file's BIFF structures out of the xls
file's OLE container and decode them. (This is really hard to get
right due to the lack of documentation.)
- Buy a third-party library to read the file (free or commercial)
- Use Excel or another program to save the file to HTML or xlsx (Office
XML format).

 

[Falcon]

complicated but challenging.
Anyway, I think I'll leave it the native way. Thanks anyway.