On May 3, 2:44 am, Falcon <talera...@gmail.comwrote:
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