Pull from DB w/ PHP and Create XLS or RTF file?

[austingecko]

I am using PHP on win2k with mysql (doesn't really matter because I'm using ADOD😎 and need to pull info from the database with PHP and then create an XLS and/or RTF file.

I know creating a PDF is pretty straightforward. But I don't have experience creating XLS and/or RTF.

Any suggestions? Articles or open source apps to do this? I've searching sourceforge, freshmeat, and hotscripts and have not been successful.

I did read I may be able to use COM to do this --- but I don't have experience with COM and couldn't find any examples.

Thanks.

[PHPdev]

I am not sure what your end goals are, nor am I sure of all your sircumstances, but you may be able to get PHP to run an Excel file with an VBA Macro...

If I knew more than just you wanted to get an XLS file, I may be albe to provide a better answer...

PHPdev

[Spudgun]

I had trouble with this for a while but eventually got my head round it. If you pass the parameters you need from your query into a page with the following header tags, the browser believes the page to be an excel attachment and you can open it or save it to excel.
<?php
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Content-Disposition: attachment; filename=radardownload.xls");

//then you can output whatever data you need in your excel...

print("<TABLE BORDER=2 CELLSPACING=2 CELLPADDING=2 WIDTH=100%>");
print("<TR><TD>Test</TD></TR>");
print("<TR><TD>Data</TD></TR>");
print("</TABLE>");
?>

If this page was called Excel.php, then merely create a hyperlink to point to it.

A good tutorial is here

Hope this helps!