@JvdL said:
@asuffield said:
Yes, which is no excuse or even a remotely good reason for doing it. It's broken.Which has been precisely my point. CSV is broken. Don't use it.
Use XML
<?xml version="1.0" encoding="utf-8"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:html="http://www.w3.org/TR/REC-html40">
<Styles><Style ss:ID="Header"><Font ss:Bold="1" /></Style></Styles>
<Worksheet ss:Name="Worksheetname">
<Table>
<Row>
<Cell ss:StyleID="Header"><Data ss:Type="String">Headercell 1</Data></Cell>
<Cell ss:StyleID="Header"><Data ss:Type="String">Headercell 2</Data></Cell>
<Cell ss:StyleID="Header"><Data ss:Type="String">Headercell 3</Data></Cell>
<Cell ss:StyleID="Header"><Data ss:Type="String">Headercell 4</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="String">Text in cell 1</Data></Cell>
<Cell><Data ss:Type="String">Text in cell 2</Data></Cell>
<Cell><Data ss:Type="String">Text in cell 3</Data></Cell>
<Cell><Data ss:Type="String">Text in cell 4</Data></Cell>
</Row>
</Table>
</Worksheet>
</Workbook>