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.


--
Regards,
Tom Ogilvy


"San" wrote:

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.