Re: Exporting HTML to Excel
| From: | M. Sokolewicz | Date: | Tue, 12 Oct 2004 21:32:42 +0000 |
| Subject: | Re: Exporting HTML to Excel | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-199304@lists.php.net to get a copy of this message | ||
Philip Thompson wrote:
Hi all.
This may not be completely a PHP question, but hopefully you will be able to provide some insight. I have a table in HTML that I want to export to an excel spreadsheet. Using PHP, I can create an excel document - however, it's empty/blank. I think I am just doing it incorrectly. Anybody done this before and/or have any ideas? I would prefer to NOT use a third-party program.
I've searched the web and php.net, but have been somewhat unsuccessful in finding anything. Here's what I have so far:
-------------
<?php
header('Content-Type: application/ms-excel');
header('Content-Disposition: attachment; filename="project.xls"');
?>
<table>
<tr>
<td>Something</td>
</td>Something else</td>
</tr>
</table>
-------------
I just want it to have that content in the spreadsheet. It's actually more involved than that, but that's the gist of it.
Thanks in advance.
~Philip
and that doesn't work???
Works for me... (Excel 2000)
"Something" appears in A1
"Something Else" appears in B1.