News for hackers. Stuff that matters.
Re:How to share your data effectively by eli on Monday April 08, 2013 @05:32PM (#5514776)
Sure, it's a nice trick, but now it's not really a CSV file any more. If I have to create a file that can only be read by Excel it might as well be XLSX.
Re:How to share your data effectively by vidarh on Monday April 08, 2013 @08:21PM (#5515656)
There's a slight difference between having to strip "=" from the column values for other applications to handle it, and require those other applications to be able to handle XLSX..
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.