Luke Smith Write today, wrong tomorrow

Interop with Office

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.

comments powered by Disqus