Re: [PHP] Excel Spreadsheets and PHP
[email protected] (Nathan Rixham)
| Newsgroups | php.general |
|---|---|
| Message-ID | <[email protected]> |
Bastien Koert wrote: > You can also create an htnl table and excel will happily handle that as well. > > The real trick is to get IE to accept the stream as a file download. I > find that I need to save the file first and the push the file down. > +1 this approach; Excel is HTTP aware and you can simply plumb in the URL of an HTML table and excel will do the rest; it works v well; saves tonnes of work and means you can do nice little things like importing SPARQL over HTTP queries straight in to excel - and then make nice pivot [1] views of the data, all in a couple of minutes. [1] http://www.getpivot.com/