Broken formatting by merging files

Topics: Developer Forum, User Forum
Jun 8, 2009 at 10:01 AM
Edited Jun 8, 2009 at 10:03 AM


I implemented a new possibility to create BIG excel files (>50 Sheets in 1 Workbook).
For instance, I create some excel files with about 5 - 10 sheets. Then I merge them to one big excel file.
I use a modified version of this solution for merging:
For reading the source files, I use the Excel5-Reader because my client only wants .xls-Files :-( 

This is how the original file looks like:

This is the view of the merged file:

Both images are sheets in the same workbook. It seems that the cell values are not copied correctly.
Do you have any suggestions?

I use the current SVN Export (27838) as PHPExcel-Library.


Jun 8, 2009 at 12:46 PM

There is an error in the example you are mentioning:

addSheet() should have been addExternalSheet(). This is probably what is causing the problems.

It might be working anyway with addSheet() in PHPExcel 1.6.7, but it will not in PHPExcel 1.7.0. I will post a note about this in the thread.

Jun 8, 2009 at 1:14 PM

Great. It work's.
In the beginning, I had a lot of problems with addExternalSheet(), so I took addSheet(). But now, it seems to work :-)