Re: Exporting HTML to Excel

From: 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.

« previous php.general (#199304) next »