Export pages to csv

[szabesz]

On 1/18/2022 at 8:09 PM, fuzenco said:

I want to initiate a download and not save it to the server.

Old question but I have just had to do the same so for those looking for this answer in the future, you might want to do something like this:

https://stackoverflow.com/questions/16251625/how-to-create-and-download-a-csv-file-from-php-script#answer-54433375

The key parts to implement are: the headers, handling the output buffer, fopen( 'php://output', 'w' ),  and exiting at the end. The rest must be implemented as you see fit.

EDIT: it might be better to export data into an excel file, for example when non-ASCII characters are in the text data. I found this package to export to excel with only two lines of code: https://github.com/shuchkin/simplexlsxgen (for CSV see its sister project https://github.com/shuchkin/simplecsv) 

$xlsx = SimpleXLSXGen::fromArray($array2D); //the array to be expored is prepared in advance
$xlsx->downloadAs($filename); //initiates the download