TextGetColor - Microsoft Excel?

[pillbug]

Hi,

I'm working with an Excel spreadsheet. The spreadsheet I'm working with has data grouped by color, instead of a column stating the group. I'd like to read the color of the excel cell, because I am copying this data to a database and grouped by category, and I do not want to read everything manually. I'm hoping there is something similar to pixelgetcolor, but instead there was a textgetcolor($string). However, if there is a library that can solve this by using the inter-workings of Microsoft, I am willing to use that.

[PsaltyDS]

Search the Example Scripts forum for the original _ExcelCOM_UDF that the current Excel.au3 was derived from. There were a host of functions like _ExcelFontGetColor() that you might pull out and tweak for use with the new UDF. I don't recommend trying to replace Excel.au3 with the old UDF, just dig out what parts you need.

[pillbug]

Search the Example Scripts forum for the original _ExcelCOM_UDF that the current Excel.au3 was derived from. There were a host of functions like _ExcelFontGetColor() that you might pull out and tweak for use with the new UDF. I don't recommend trying to replace Excel.au3 with the old UDF, just dig out what parts you need.

I'll try this out. Thanks so much.