How retrieve the color of the cells

Questions and answers on how to use XLSSpreadSheet.
Post Reply
mclot
Posts: 15
Joined: Wed Oct 10, 2007 7:20 am

How retrieve the color of the cells

Post by mclot »

Hi,
I'm trying to retrieve the color of the cells of an Excel file through the following properties "cell [Col, Row]. CellColorRGB" or "cell [Col, Row] .FillPatternForeColorRGB but the value I get is not the same as the cell color questioned.
Can you help me?

Thank you very much!
Luigi
larsa
Site Admin
Posts: 926
Joined: Mon Jun 27, 2005 9:30 pm

Re: How retrieve the color of the cells

Post by larsa »

Hello

It's possible the colors are reverse. Please try: Color := RevRGB(Color);
Lars Arvidsson, Axolot Data
Post Reply