Sign in to follow this  
Followers 0
pillbug

TextGetColor - Microsoft Excel?

3 posts in this topic

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.

Share this post


Link to post
Share on other sites

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.

:mellow:


Valuater's AutoIt 1-2-3, Class... Is now in Session!For those who want somebody to write the script for them: RentACoder"Any technology distinguishable from magic is insufficiently advanced." -- Geek's corollary to Clarke's law

Share this post


Link to post
Share on other sites

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.

:mellow:

I'll try this out. Thanks so much.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0