Excel data

[Mucello]

I'm trying to output some data in comma delimited format. My PHP script does a large query and sends it to the screen. No problem. What I'd really like to do though is somehow have Excel automagically open with the data. How can I do this? Is it even possible?

[maxpup979]

you bet its possible--there are lots and lots of ways to do this, but it all starts with the header.

header ("content-type: application/x-msexcel");
header("Content-Disposition: filename=results.xls");

There are other ways to do it, but that is the simplest one I am familiar with:

[Mucello]

Very awesome!! Thanks🙂 That opens Excel right up. But now all my data appears in the first cell of each row rather than individual cells. I'm echoing the data as comma delimited data. Is there a special trick to get Excel to put the data into each cell rather than all in one?

[maxpup979]

change the commas to tabs (\t), and don't forget to newline (\n) when you need it

[Mucello]

Very excellent🙂 Thanks!!