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/
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.