Page 1 of 1

What are the acceptable values for NumberFormat Color

Posted: Mon May 27, 2013 5:06 pm
by Mojoala
[Red] is one and [Green] is the other except [Green] is more akin to Lime once it gets to the Excel Sheet.

So what are my options?

TIA

Re: What are the acceptable values for NumberFormat Color

Posted: Tue May 28, 2013 2:02 pm
by larsa
Hello

You can use the following color names: BLACK,CYAN,MAGENTA,WHITE,BLUE,GREEN,RED,YELLOW
It's Excel that decides the color shown on the worksheet. XLSReadWriteII just sends the name of the color.