Thread: [Solved] Extracting Cell color
View Single Post
Old 06-17-2009, 07:03 AM
bsaucer bsaucer is offline Windows XP Office 2007
Join Date: Jun 2009
Posts: 1
bsaucer is on a distinguished road
Default Extracting Cell color

I have been given an Excel spreadsheet (.xls format), and I need to import the table into a SQL (2000) database, which I've done with other spreadsheets in the past. The only problem with this spreadsheet is that one column is color coded with information that I need to extract. Obviously the spreadsheet was made for human eyes.

Each cell may have any one of four background colors which I need to electronically distinguish. I don't even know the "name" or value of each of the colors. They just "appear" red, dark blue, dark green, or light gray. I need to interpret the color into two bits of information (which I could call "C", "S", "both", or "neither").

This table has well over 2000 rows.
Reply With Quote