What are the acceptable values for NumberFormat Color

Questions and answers on how to use XLSReadWriteII 3/4/5.
Post Reply
Mojoala
Posts: 19
Joined: Wed Feb 29, 2012 5:54 pm

What are the acceptable values for NumberFormat Color

Post 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
larsa
Site Admin
Posts: 926
Joined: Mon Jun 27, 2005 9:30 pm

Re: What are the acceptable values for NumberFormat Color

Post 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.
Lars Arvidsson, Axolot Data
Post Reply