addExternalSheet

Topics: Developer Forum
Apr 12, 2011 at 8:59 AM

Simple model:

Have two PHPExcel objects with 1 worksheet in each.

Want to add the sheet from second into first one.

$phpExcel1 -> addExternalSheet($phpExcel2->getSheet(0));

After that I've got a xls file with two sheets: first one (from phpExcel1) is totally Ok, but the second one is messed up.

Borders are chaotically added to cells and the most awful is that cell width is expanded. Files are generating from special templates and this is really big problem with expanded width.