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.

 

[Nicholas Paldino [.NET/C# MVP]]

Falcon,

Because Excel can have separate styles for each cell, you will have to
get the Range for each cell and then check the appropriate style/formatting
properties on that.

Hope this helps.

 

[Falcon]

Thanks for replying:
No,
it dosn't,
How do I get the range for each cell?

 

[backwardshoop]

I'm displaying an Excelspreadsheetusing 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 (Excelspreadsheet) .

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

Thanks.

Falcon,

I would like to also suggest using a 3rd party grid/spreadsheet
control, like the FarPoint Spread for Windows or FarPoint Spread for
Web Forms product. With this Spread control, all you have to do is to
call one line of code (OperExcel) and pass in the filename and the
control will load all the data, formulas, and styles for one sheet or
all the sheets of the Excel workbook.

Scott Shorter