Copy link to clipboard
Copied
I'd like to be able to use a hex value for color like: <cfset SpreadsheetFormatCell(xl,{color="#FE0000",fgcolor="#Clr#"},#xl.rowcount#,1)> or <cfset SpreadsheetFormatCell(xl,{color="#355f91",fgcolor="#Clr#"},#xl.rowcount#,1)>
Currently you can only use this list of predefined colors:
Colors="black,brown,olive_green,dark_green,dark_teal,dark_blue,indigo,grey_80_percent,orange,
dark_yellow,green,teal,blue,blue_grey,grey_50_percent,red,light_orange,lime,sea_green,aqua,light_blue,
violet,grey_40_percent,pink,gold,yellow,bright_green,turquoise,dark_red,sky_blue,plum,grey_25_percent,
rose,light_yellow,light_green,light_turquoise,light_turquoise,pale_blue,lavender,white,cornflower_blue,
lemon_chiffon,maroon,orchid,coral,royal_blue,light_cornflower_blue"
Have something to add?