Broken formatting by merging files

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

Hello,

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: http://phpexcel.codeplex.com/Thread/View.aspx?ThreadId=36984
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:
http://www.fire-fall.de/phpexcel/file-original.jpg

This is the view of the merged file:
http://www.fire-fall.de/phpexcel/file-broken.jpg

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.

Regards

Developer
Jun 8, 2009 at 1:46 PM

There is an error in the example you are mentioning:
http://phpexcel.codeplex.com/Thread/View.aspx?ThreadId=36984

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 2: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 :-)