News for hackers. Stuff that matters.
Re:Please Offer an Excel Export Option by justincormack on Sunday December 07, 2014 @06:53PM (#8714162)
Ok,so is there a simple implementation guide/library?
Re:Please Offer an Excel Export Option by Mikhail_Edoshin on Monday December 08, 2014 @03:16AM (#8715474)
Yes, here it is:

http://msdn.microsoft.com/en-us/library/aa140066%28office.10...

It only describes the data part and doesn't document Excel options such as print settings and filters; if you need them, create a sample in Excel, save it as XML Spreadsheet 2003 and examine the result.

(The 'big' Excel format that is a part of Office Open XML format is also called Spreadsheet ML, but they're different; from what I understand this one is a subset.)

Re:Please Offer an Excel Export Option by the_why_of_y on Monday December 08, 2014 @01:54PM (#8718263)
It's a deprecated format that was essentially Microsoft's first experiment at an XML based format in the Office XP/Office 2003 days... whether it will continue to be supported in future versions is anybody's guess, given that the successor format OOXML is much more widely adopted.
Re:Please Offer an Excel Export Option by Mikhail_Edoshin on Tuesday December 09, 2014 @04:21AM (#8721836)
My impression is that Microsoft is fairly reliable when it comes to supporting old formats and standards. E.g. I can still send Word and Excel DDE commands and this is a tech from 90s, Windows 3.1 and stuff. OOXML is certainly more powerful, but it's also more complex.
Re:Please Offer an Excel Export Option by troels on Monday December 08, 2014 @05:07AM (#8715740)
Here's a really basic implementation that I used in some code as a drop-in replacement for csv:

https://gist.github.com/troelskn/cf9df474662c88ba7951