Export PHP Results to excel/word

garvey2003

Hi all,

I have a php script that works a treat. I select the start and end dates to bring back data from 2 tables for the dates selected.
Its just how I want it apart from one thing. I need to be able to do the following:

Email Generated results
Print Results
Export to Excel
Export to word

Either generate the results to any of the above would be great.
Any help would be spot on

thanks Garvey 😕

AstroTeg

Exporting to Excel isn't too bad. You could generate a CSV file which Excel can directly import (or import into other programs). Although Excel is a bit flakey with CSV files and you have to do some tricks to make it work. What also works is generating a very plain HTML table which contains all your data. Toss an "xls" extention on it and set the mime type for Excel and Excel will bring it right it (although if you wish to perform some calculations on this data, I recommend saving the imported file as Excel before doing anything).

For Word, I've generated RTF files and that isn't too painful. Another option might be to see if Word will import an HTML file and what is all involved with that. I haven't tried the HTML route with Word so I don't know how well that would work. RTF has been working well for me though.

Eduardo_Ramos

You may try a solution like PHPDocX. It will allow to do what you are asking for and many other things, like, for example, template manipulation.

vivek151189

You can generate the table in html and the export it in the excel document it i seasy

Eduardo_Ramos

But PHPDocX allows that you include the table in a much more complex document where you can incorporate headers, footers, charts, ... see for example the available demo.

I understand that your solution is the best if you just want to export some data but not good enough to generate a full report 🙂

vivek151189

I understand that your solution is the best if you just want to export some data but not good enough to generate a full report

However you can generated table with multiple rows an column in html its totally upto you how much data you want it table it just export the content of html table

you can see the below code

header("Pragma: public");
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Content-Type: application/force-download");
header("Content-Disposition: attachment; filename=predefined_wip_report.xls");

header("Content-Type: application/vnd.ms-excel");
echo '<table>';
echo $text = $_REQUEST['tbodyContent'];
echo "</table>";

where $_REQUEST['tbodyContent'] brings the content of the table