RE: Exporting HTML to Excel

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> header('Content-Type: application/ms-excel');
> header('Content-Disposition: attachment; filename="project.htm"'); ?>
>                                                            AAA used by
excel to determine translation, I believe

I believe the Content-Type is referred to as a mime header (8-}), I often
see something similar in email.

HTH,

Warren Vail
(415) 667-0240
SF211-07-434
 


-----Original Message-----
From: Philip Thompson [mailto:prthomp@xxxxxxxx] 
Sent: Wednesday, October 13, 2004 6:18 AM
To: Vail, Warren
Cc: php-general@xxxxxxxxxxxxx
Subject: Re:  Exporting HTML to Excel


How exactly would I change the mime headers?

~Philip

On Oct 12, 2004, at 5:07 PM, Vail, Warren wrote:

> Have you tried changing your file name to project.htm but continue
> issuing
> the mime headers for excel?
>
> Warren Vail
>
> -----Original Message-----
> From: Philip Thompson [mailto:prthomp@xxxxxxxx]
> Sent: Tuesday, October 12, 2004 2:21 PM
> To: php-general@xxxxxxxxxxxxx
> Subject:  Exporting HTML to Excel
>
>
> 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
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux