I am trying to export the data retrieved from the database, through PHPExcel to Excel. All the examples on PHPExcel website refers to examples where the mysql result set is being looped through. Excel is opened but there is no data populated so I guess that I am somehow looping through the resultset in the wrong way?
My query is executed like this:
I am then calling the method below.
The below code is the function I want to use for export by passing the returned resultset array.