Exporting CSV: Firefox vs. IE

registered · Site Admin Joined: Jun 04, 2004 Posts: 6437

Testing an application that creates a CSV using

Code:

    header("Content-Type: text/x-csv");


    header('Content-Disposition: attachment; filename="s'.$SyncID.'.csv"');


    echo $csv;

where $SyncID is an integer, and $csv is a string that contains 2 or more lines (terminated with \r\n) of comma separated text.

Using IE, everything works great. But using Firefox, the lines in the .csv file are wrapped at 990 characters. This doesn't bother Excel, but drives the other application I'm trying to import into NUTS.

If I open the CSV file in Excel, and save it as CSV, the double quotes around the fields are removed, but the line still wraps at 990 characters.

Could this be caused by a PHP.ini setting, a FireFox setting, or the header type I'm using, or is it just a quirk of FireFox?

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

Try this, although I don't think it will help, but just for grins and giggles

Code:

header("Content-type: application/csv");