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?
[ Parent
| on HN ]
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.
Here's a really basic implementation that I used in some code as a drop-in replacement for csv: