PHP to download into Excel

@Jarrod1937Jan 27.2011 — #After you send those headers you need to echo out the data for it to send, obviously the data has to be in the correct format. You may have better luck with exporting out a .csv rather than an excel file.

@TeaserauthorJan 28.2011 — #Hi Jarrod,

Would you be able to give me the code to echo out the data.. if possible for the csv as well?

@Jarrod1937Jan 28.2011 — #I believe the .xls is a binary file format, so its not just something you can just print out (though there are libraries for this i believe). However, a .csv is relatively easy:

[code=php]
 // Newline character to use
 $newline="rn";
 
 // array of items to filter, will interfere with the format
 $filterarray=array("rn", "n", "r");
 $maincsvstring='';
 
 // Have a while statement to loop through your data
 while(){
 
 /* Append to string. The str_replace is fed the filterarray from above.
 The method below allows you to filter the entire line of the string at once,
 a bit more effective than filtering each string output individually.
 Notice the $newline appended to the string, important to delimit a new record
 */
 $maincsvstring.=str_replace($filterarray,'',$output1.','.$output2.','.$output3).$newline;
 }
 
 // Stripped to the minimum amount of headers needed for brevity
 header("Content-type: application/ text");
 header("Content-disposition: attachment; filename=your_csv_file.csv");
 
 // Echo string out. With the above headers this will force a download
 // dialog and will stream the output to the file.
 echo $maincsvstring;
 [/code]

Although i didn't do it above, you may want to consider removing ,'s if your data contains them in a non-encapsulated way (not within quotes " ").

@TeaserauthorJan 28.2011 — #cheers mate.. i'll give this a go and see what happens ? will let you know monday/tuesday.

PHP to download into Excel

4 Comments(s) _↴

Also in #PHP _↴

Success!

Social

Version

PHP to download into Excel

4 Comments(s) ↴

Also in #PHP ↴

Success!

The web is an endless sea of information. Don't miss the boat... Subscribe!

Social

Version

4 Comments(s) _↴

Also in #PHP _↴