Export to CSV

[947740]

I am having some trouble exporting a file as a csv.  I have this code:

<?php
header("Content-type: application/x-msdownload");
header("Content-Disposition: attachment; filename=file.csv");
header("Pragma: no-cache");
header("Expires: 0");
?>

 

And, in that file, there is this data:

1163 6/13/2009 162 10.36

944 6/13/2009 162 10.31

929 6/13/2009 162 10.33

1034 6/13/2009 162 7.44

 

But it is not working.  Excel says it is not a valid .csv file.  I have a feeling that the header content I am sending is not correct.  What am I missing?

[MadTechie]

for a CSV your data should look like this

"data1","data2"
"12","34"
"56","78"

 

can you post some data in code tags, (or attach a file) as you maybe using a tab file

[947740]

I had copied that data from excel...the csv file has commas.  I am going to try it with the quotes and see what happens.

[947740]

It worked.  Thanks for the help.

[Mark Baker]

try

header("Content-type: text/plain");

or

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

 

 

I had copied that data from excel...the csv file has commas.

That's what the C in CSV stands for