News for hackers. Stuff that matters.
Re:How to share your data effectively by eli on Monday April 08, 2013 @10:27PM (#5516105)
At least XLSX is an open and documented format. Are the rules for Excel CSV parsing written down anywhere?
Re:How to share your data effectively by niggler on Monday April 08, 2013 @10:43PM (#5516144)
"At least XLSX is an open and documented format."

The documentation diverges from the excel implementation in so many places that there's a special document (which itself is incomplete): http://msdn.microsoft.com/en-us/library/dd922181(v=office.12...

"Are the rules for Excel CSV parsing written down anywhere?"

They are loosely described in ECMA-376 section 18.8.30 under the "General" format code. But like with most details surrounding XLS and XLSX, the documentation is barely coherent and incorrect in some places.