> -----Original Message----- > From: Yeti [mailto:yeti@xxxxxxxxxx] > Sent: Thursday, October 23, 2008 9:36 AM > To: gopi krishnan; PHP - General > Subject: Re: export data to a ms excel file using php > > I'm not into MS Office, but isn't there some weird Office XML format > since Office 2007? > At MSDN I could find a nice description of the wannabe standard [1]. > So if the new Excel can take XML it wouldn't be too difficult to > export the data I guess. > > [1] http://msdn.microsoft.com/en-us/library/aa338205.aspx Yes, the new extension for these files is *.xlsx . Also with Office 2007 are *.docx, *.pptx, etc. (See a pattern here?) When trying to load generated *.xls files in Office 2007, I'm greeted with a warning about Excel not being able to determine the type of the file. It still loads fine, and all the data and formatting are there... just barks at you every time you open it (or at least initially). I believe this is a known bug, but I don't have the time/patience to track it down in MSDN to link here. :) But to comment on your second point--yep, Excel 2007 will load XML (and even an associated XSD for determining formatting, validation, etc.). I haven't played with it too much, but I have successfully imported XML documents and used its "best guess" algorithm to build them into *.xls workbooks. No major hang-ups. (BTW, OpenOffice.org v3 has been released. http://www.openoffice.org - it supports the new Office 2007 formats, and could maybe be leveraged for conversion, etc.) HTH, Todd Boyd Web Programmer -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
