4 ms·
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.
by eli 14y ago
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.
- vidarh 14y agoThere'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..
- eli 14y agoAt least XLSX is an open and documented format. Are the rules for Excel CSV parsing written down anywhere?
- niggler 14y ago"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).aspx 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.