On Fri, Feb 19, 2010 at 3:36 PM, Bob McConnell <r...@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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
