Excel Spreadsheets and PHP
in [General]
|
From: Ian Robertson on 19 Feb 2010 15:28 Hello, everyone. Just a quick question. What are you using, if anything, to create Excel spreadsheets with PHP? Thank you in advance.
From: "Bob McConnell" on 19 Feb 2010 15:36 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 to use that. Bob McConnell
From: Ashley Sheridan on 19 Feb 2010 15:48 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. > > Unfortunately, this happens even if you have Open Office installed and > would prefer to use that. > > Bob McConnell > I believe there are pear classes to output these files, and the new xlsx format is XML-based so shouldnt be too difficult to output something simple. Also, the ods format is well documented, and again should be very easy to output to. Thanks, Ash http://www.ashleysheridan.co.uk
From: Andrew Ballard on 19 Feb 2010 15:53 On Fri, Feb 19, 2010 at 3:36 PM, Bob McConnell <rvm(a)cbord.com> 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, this happens even if you have Open Office installed and > would prefer to use that. > > Bob McConnell > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > If you need more control over formatting, formulas, etc., there is an XML format that Microsoft supports. http://msdn.microsoft.com/en-us/library/aa140066%28office.10%29.aspx Then you can use DOM in PHP to build what you need. Andrew
From: "Hansen, Mike" on 19 Feb 2010 16:44
> -----Original Message----- > From: Ian Robertson [mailto:irobertson(a)americantextile.com] > Sent: Friday, February 19, 2010 1:28 PM > To: php-general(a)lists.php.net > Subject: [PHP] Excel Spreadsheets and PHP > > Hello, everyone. > > Just a quick question. > > What are you using, if anything, to create Excel spreadsheets > with PHP? > > Thank you in advance. > Pear Spreadsheet Excel Writer. http://pear.php.net/package/Spreadsheet_Excel_Writer Mike |