PHP_XLSXWriter_plus Missing Data For Large Mysql Data Sets
<p>I am trying out this library, because PHPExcel is in capable of not using up 3GBs of ram (probably more) when trying to download 143,000+ mysql records. So far this library has been an improvement as I can generate an .xlsx file without exhausting the php memory limit.</p>

<p>However, I am running into a problem where it fills in most of the data, but a couple of columns have only 3\4 of the expected values and other columns is a hit or miss if it fills in the value for a particular cell.</p>

<p>For example, one column is called Submit Date and its format is datetime in the database, but a string from the php query. Out of 143,828 rows of data only the first 19,483 rows have the date values filled in.</p>

<p>I can confirm that the missing values in the submit date column and the other missing cells do have a value\data within the mysql database. Also, the submit date column is used in a ORDER BY clause in the mysql query in case that has anything to do with this problem.</p>

<p>So I am trying to figure out if this is a (common?) problem with this library when downloading a large data set? Or the problem more lies more on my code up until calling on this library to generate the .xslx file.</p>

<p>Thanks.</p>