3 ms·

xls is not just one format. There are several formats which Excel will understand, that uses that extension. One of them is a real simple xml-based format (Spre

by troels 12y ago

xls is not just one format. There are several formats which Excel will understand, that uses that extension. One of them is a real simple xml-based format (SpreadsheetML), that is way easier to generate than proper excel files and has most of the features you need (At least for data transport purpose). Highly recommend using it.

Mikhail_Edoshin 12y ago
I second SpreadsheetML; it's plain XML (not multi-part compressed .xslx) and it supports multiple sheets, formulas, formatting, and some other bits like named ranges, print settings, and such.
- justincormack 12y ago
  Ok,so is there a simple implementation guide/library?
  - Mikhail_Edoshin 12y ago
    Yes, here it is: http://msdn.microsoft.com/en-us/library/aa140066%28office.10%29.aspx 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.)
    - the_why_of_y 12y ago
      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.
      - Mikhail_Edoshin 12y ago
        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.
  - troels 12y ago
    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 https://gist.github.com/troelskn/cf9df474662c88ba7951

by troels 12y ago

Mikhail_Edoshin 12y ago

I second SpreadsheetML; it's plain XML (not multi-part compressed .xslx) and it supports multiple sheets, formulas, formatting, and some other bits like named ranges, print settings, and such.

justincormack 12y ago
Ok,so is there a simple implementation guide/library?
- Mikhail_Edoshin 12y ago
  Yes, here it is: http://msdn.microsoft.com/en-us/library/aa140066%28office.10%29.aspx 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.)
  - the_why_of_y 12y ago
    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.
    - Mikhail_Edoshin 12y ago
      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.
- troels 12y ago
  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 https://gist.github.com/troelskn/cf9df474662c88ba7951