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.
|