Interop with Office
24 Feb 2006
I'm currently playing around with the Office PIA
COM components to do some spreadsheet work. Trying to dynamically generate Excel Workbooks
isn't easy, so I created my own xml structure for describing the layout of a worksheet.
My libarary includes a very handy ExcelTable object which allows you to bind a datasource
to be generated.
One of the many annoying this about the Excel COM component is the ColorIndex property.
Finally I've found a website which
documents the ColorIndex numbers with their associated color.