Hacker News Reader

Comment by justincormack | Hacker News Reader

xlslib, at a brief glance, looks like it is based on the .xsl format, not .xlsx. Wondering if it is easier to generate .xlsx XML files for export, or not.

View on HN

Nearly 4 years ago I wrote a library in Go to read XLSX - that was trivial. It's grown over time, and this year it started growing feature that allow it to write XLSX format. This is a whole different ball game - Microsoft Excel is really picky about what it will and won't accept. In most cases Excel will simply moan and do an automated repair on files that don't match exactly it's expectation. LibreOffice is less annoying in its XLSX handling.

They're totally different formats. It'd have to be a separate implementation. xls is binary, xlsx is XML based.

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.

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.

Ok,so is there a simple implementation guide/library?

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.)

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.

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:

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

I know that they are totally different, wondering if xlsx is simpler so that it would be easier code, or whether it is just as complex really, and not suer what real world compatibility is.

Reply on news.ycombinator.com