dongque8332 2011-09-14 08:27
浏览 58
已采纳

xls文件中的语法错误?

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">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>
  • 写回答

1条回答 默认 最新

  • douhui3760 2011-09-14 08:52
    关注

    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.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 (标签-Python|关键词-socket)
  • ¥15 keil里为什么main.c定义的函数在it.c调用不了
  • ¥50 切换TabTip键盘的输入法
  • ¥15 可否在不同线程中调用封装数据库操作的类
  • ¥15 微带串馈天线阵列每个阵元宽度计算
  • ¥15 keil的map文件中Image component sizes各项意思
  • ¥20 求个正点原子stm32f407开发版的贪吃蛇游戏
  • ¥15 划分vlan后,链路不通了?
  • ¥20 求各位懂行的人,注册表能不能看到usb使用得具体信息,干了什么,传输了什么数据
  • ¥15 Vue3 大型图片数据拖动排序