Combining xls to xlsx - embedded images not copying into final xlsx

Topics: Developer Forum, User Forum
Feb 14, 2013 at 8:59 PM
Edited Feb 14, 2013 at 8:59 PM
PHP 5.4.6 on Apache 2.4
PHPExcel 1.7.8

I'm combining multiple xls(97-2003) sheets into an xlsx workbook.
Everything combines fine - but no images are being copied.

The base xls files are being generated by Crystal Reports. The images are charts that Crystal exports inside the excel file as an image. It's not different than if I had inserted an image into an excel file by hand.

I'm reading via:
$reader=new PHPExcel_Reader_Excel5();
foreach($input_excel->getAllSheets() as $sheet){
$writer=new PHPExcel_Writer_Excel2007($combined_sheet);

Do I need to do special handling of images? If so, how does one read the position of an image from an existing sheet? I've seen examples of how to extract the image and save it to a file - I should be able to use those examples to get the image data itself, but how does one get the positional data? I would hope that the load and getAllSheets methods would read images without special handling.