Re: Exporting HTML to Excel

[Chris Dowell <php@xxxxxxxxxxxxxx>]

In an attempt to make amends, have you tried PEAR's 
Spreadsheet_Excel_Writer?

http://pear.php.net/package/Spreadsheet_Excel_Writer

It certainly works, we used it last week (although I have no *personal* 
experience of it)

Cheers

Chris

Chris Dowell wrote:

> <meek />
>
> sorry
>
> [skulks off into dark corner to cry]
>
> Philip Thompson wrote:
>
> > Chris, as you may have (or may have not) noticed, I did that. Look at 
> > my original email. I wasn't sure if there was more to it than that.
> >
> > ~Philip
> >
> > On Oct 13, 2004, at 8:34 AM, Chris Dowell wrote:
> >
> > > Header("Content-type: application/ms-excel");
> > >
> > > or whatever the content type should be (on IE you can probably get 
> > > away with application/octet-stream as it bases its decisions of file 
> > > extensions for a lot of things).
> > >
> > > HTH
> > >
> > > Chris
> > >
> > > Philip Thompson wrote:
> > >
> > > > 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