开发者

syntax error in xls file?

开发者 https://www.devze.com 2023-04-04 22:54 出处:网络
dont know where the error is in the sourcecode, excel print all the content into 1 line? <?xml version=\"1.0\" encoding=\"utf-8\"?\\>

dont know where the error is in the sourcecode, excel print all the content into 1 line?

<?xml version="1.0" encoding="utf-8"?\>
<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>
</Styles>
<Worksheet ss:Name="Export">
<Table>
<ROW>
<CELL><Data ss:Type="String">id</Data></CELL><CELL><Data ss:Type="String">barcode</Data></CELL><CELL><Data ss:Type="String">name</Data></CELL><CELL><Data ss:Type="String">price</Data></CELL><CELL><Data ss:Type="String">currency</Data></CELL><CELL><Data ss:Type="String">store</Data></CELL><CELL><Data ss:Type="String">timestamp</Data></CELL><CELL><Data ss:Type="String">longitude</Data></CELL><CELL><Data ss:Type="String">latitude</Data></CELL><CELL><Data ss:Type="String">deal</Data></CELL><CELL><Data ss:Type="String">type</Data></CELL><CELL><Data ss:Type="String">devicename</Data></CELL>
</ROW>
<ROW>
<CELL><Data ss:Type="String">1</Data></CELL>

<CELL><Data ss:Type="String">9783827328168</Data></CELL>

<CELL><Data ss:Type="String">123</Data></CELL>

<CELL><Data ss:Type="String">345</Data></CELL>

<CELL><Data ss:Type="String">EUR</Data></CELL>

<CELL><Data ss:Type="String">Lidl</Data></CELL>

<CELL><Data ss:Type="String"开发者_如何学C>1315573726</Data></CELL>

<CELL><Data ss:Type="String">8.666193</Data></CELL>

<CELL><Data ss:Type="String">49.552096</Data></CELL>

<CELL><Data ss:Type="String">dealyes</Data></CELL>

<CELL><Data ss:Type="String">typebrutto</Data></CELL>

<CELL><Data ss:Type="String">m.münzner</Data></CELL>
</ROW>

</Table></Worksheet></Workbook>


XML is case-sensitive. Replace "CELL" and "ROW" with "Cell" and "Row". With that and the fix suggested by Pekka, your file loads into Excel fine for me.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号