Chart line style is lost upon writing (loaded from xlsx file)

Topics: Developer Forum, Project Management Forum, User Forum
Oct 23, 2013 at 10:33 AM

I am loading an xlsx file with 3 charts inside. 2 line charts and 1 bar chart. Here is how I read the file:

$objReader = PHPExcel_IOFactory::createReader('Excel2007');
$objPHPExcel = $objReader->load($templateFileFullPath);

.... update some cells ....

write to the output file:
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');

All are working fine, except the colors of the lines and the thickness of the lines.

The lines are very thin.
The colors are different from the original file.

Is there a way to keep the style of the lines and bars from the original file?

In the original file, the style is specified from Excel using 'Format Data Series'.

Any workaround will be great.

Thank you.