XLSX Cell Colors [Archive] - Datawatch Forums

elginreigner

October 27th, 2009, 03:54 PM

Can the v10 Monarch Pro read cell colors in Excel XSLX files?

Data Kruncher

October 27th, 2009, 04:10 PM

While you can now with v10 set any RGB value (or even HSL value) for many items within Monarch, Monarch will not currently detect the colors used in an Excel xlsx file.

OllyInMunich

October 27th, 2009, 04:54 PM

Hello elginreigner,

Assuming you want to be able to say, interpret a red cell background as a negative number, and others as positive, then I think you'd be better off scripting this in Excel before passing the data to Monarch. I don't think you can do this just using the formatting options in Excel's find & replace dialog.

Best wishes,

Olly