Re: [PHP] Excel Spreadsheets and PHP

2010-03-01 Thread Andrew Ballard
On Fri, Feb 26, 2010 at 3:47 PM, Ian Robertson wrote: > Thank you all very much for your replies. > > I learned about a few new approaches. > > I didn't see it come up yet, so I'll post the URL of what I have been using. > > php_writeexcel - > http://www.bettina-attack.de/jonny/view.php/projects/

RE: [PHP] Excel Spreadsheets and PHP

2010-02-26 Thread Ian Robertson
his 3 Bettinas, wherever you are, haha. -Original Message- From: Jay Blanchard [mailto:jblanch...@pocket.com] Sent: Sunday, February 21, 2010 9:44 PM To: Ian Robertson; php-general@lists.php.net Subject: RE: [PHP] Excel Spreadsheets and PHP [snip] What are you using, if anything,

RE: [PHP] Excel Spreadsheets and PHP

2010-02-21 Thread Jay Blanchard
[snip] What are you using, if anything, to create Excel spreadsheets with PHP? [/snip] PHP http://www.evolt.org/node/26896 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Excel Spreadsheets and PHP

2010-02-20 Thread Nathan Rixham
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 ca

Re: [PHP] Excel Spreadsheets and PHP

2010-02-20 Thread asch...@wesseli.us
On 19-2-2010 21:28, Ian Robertson wrote: Hello, everyone. Just a quick question. What are you using, if anything, to create Excel spreadsheets with PHP? Thank you in advance. Hello Ian, You can use the PHPExcel class. It can read, write and convert between Excel versions without the ne

RE: [PHP] Excel Spreadsheets and PHP

2010-02-19 Thread Daevid Vincent
> >> -Original Message- > >> From: Ian Robertson [mailto:irobert...@americantextile.com] > >> Sent: Friday, February 19, 2010 1:28 PM > >> To: php-general@lists.php.net > >> Subject: [PHP] Excel Spreadsheets and PHP > >> > >> Hello, everyone. > >> > >> Just a quick question. > >> > >> What

Re: [PHP] Excel Spreadsheets and PHP

2010-02-19 Thread Bastien Koert
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. On 2/19/10, Hansen, Mike wrote: >> -Original Message- >> From: Ian Ro

RE: [PHP] Excel Spreadsheets and PHP

2010-02-19 Thread Hansen, Mike
> -Original Message- > From: Ian Robertson [mailto:irobert...@americantextile.com] > Sent: Friday, February 19, 2010 1:28 PM > To: php-general@lists.php.net > Subject: [PHP] Excel Spreadsheets and PHP > > Hello, everyone. > > Just a quick question. > > What are you using, if anything, t

Re: [PHP] Excel Spreadsheets and PHP

2010-02-19 Thread Andrew Ballard
On Fri, Feb 19, 2010 at 3:36 PM, Bob McConnell wrote: > From: Ian Robertson > >> What are you using, if anything, to create Excel spreadsheets with > PHP? >> > > Output CSV files with the correct MIME type. MS-Windows will open them > in Excel by default in both IE and Firefox. > > Unfortunately,

RE: [PHP] Excel Spreadsheets and PHP

2010-02-19 Thread Ashley Sheridan
On Fri, 2010-02-19 at 15:36 -0500, Bob McConnell wrote: > From: Ian Robertson > > > What are you using, if anything, to create Excel spreadsheets with > PHP? > > > > Output CSV files with the correct MIME type. MS-Windows will open them > in Excel by default in both IE and Firefox. > > Unfortu

RE: [PHP] Excel Spreadsheets and PHP

2010-02-19 Thread Bob McConnell
From: Ian Robertson > What are you using, if anything, to create Excel spreadsheets with PHP? > Output CSV files with the correct MIME type. MS-Windows will open them in Excel by default in both IE and Firefox. Unfortunately, this happens even if you have Open Office installed and would prefer