RE: [PHP] Re: Exporting HTML to Excel
| From: | Gryffyn, Trevor | Date: | Wed, 13 Oct 2004 14:45:44 +0000 |
| Subject: | RE: [PHP] Re: Exporting HTML to Excel | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-199379@lists.php.net to get a copy of this message | ||
One recommendation might be to make something in Excel, do a Save As..
To HTML and see what kind of tags it puts in the HTML. There are some
in there specifically for storing formulas and such. You can probably
embed that in the HTML you output via this method and do some fancy
stuff with Excel.
-TG
> -----Original Message-----
> From: Gryffyn, Trevor
> Sent: Wednesday, October 13, 2004 10:41 AM
> To: php-general@lists.php.net
> Subject: RE: [PHP] Re: Exporting HTML to Excel
>
>
> > Philip Thompson wrote:
> >
> > > -------------
> > > <?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.
> >
> > Works for me... (Excel 2000)
> > "Something" appears in A1
> > "Something Else" appears in B1.
>
> Worked for me too.. Even though I didn't think it would :)
> Seemed too simple.
>
> I'm running Excel 2002.
>
> -TG
>