Missing Data In Some Columns

[jikininki111]

HI,

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.

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.

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.

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.

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.

Thanks.