I have just encountered the following problem:
To load a large XML file and save it as an XLSX (Excel2007) file using test example "XMLReader.php" which is include in the latest PHPExcel package.
The size of the xml file is 1.57MB.
The message I got is:
04:19:25 Load from XML file
Fatal error: Maximum execution time of 30 seconds exceeded in
C:\WAMP20\www\Test\PHPExcel\Classes\PHPExcel\Style.php on line 502
I have try to increase the timeouts setting in php.ini from 60sec to 300sec. The same message appeared.
The program works properly if I cut the size of the xml file to around 338K. So I think it is properly due to the size of file!!
I wonder if anybody can help me on this? Is this the limitation of PHPExcel ?