CUstom color is not showing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hai all,

$excel_app = new COM("Excel.Application");
$excel_app->SheetsInNewWorkbook=2;
$workbook = $excel_app->Workbooks->add();
$workbook->Colors[15]=hexdec("ABCDEF");

Im trying to assing color like the above code.But the custom colors are not
appearing for the cells. Its automatically converted to the 1-56 color
indexed and no error is showing.
Thanks in advance
San.
 
Your code appears to be changing the definition of the 15th color in the
color pallet of 56 colors. If you have any cells that have their
interior.colorindex property set to 15, then they should take on the
appearance of your new color.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel is not closing 5
ColorIndex vs Color? 8
Working with colors (default and custom) 4
custom cell color 9
ColorIndex returns incorrect color 1
Automatically control the font of a cell when a function is used 2
Cell Formatting Conditional On Other Cells Fill Color? 2
custom color palette does not get transferred with the workbook. Excel 2003 3

Back
Top