We are using prof v 5.0 and the latest export code. When exporting a grid, the exported excel does not display any data(but headers are intact) and is repaired by excel on opening. There are no error logs even after turning on the debug in generate.php. I checked the debgxxx…x.xml and it contains the complete data which is around 700+ columns and 10 rows. The export does not take long but it does not export the 10 rows of data.
The data is alphanumeric and does not have special characters or anything like that. I cannot publish it here because it contains our client data. This does not happen for the same table with other sets of data. Any idea what could be wrong and any possible troubleshooting steps?
Thank you Stanislav. We are using PHP. The data is mostly numbers in 1.0 (n.n) format or NA so its unlikely there are any special characters but the limit in PHPExcel is a possible issue. If we setup a Java export server will it have the same limitation?