XML in Excel and the Spreadsheet Component RRS feed

  • Question

  • Hi Trying to use Excel XML schema to export the data.

    Giving below the section of my generated code...........

    <HTML xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet">
    <META HTTP-EQUIV="CONTENT-TYPE" CONTENT="application/vnd.ms-excel; charset=ISO-2022-JP">
      <ss:Column c:Caption>
            <ss:Data ss:Type="String">D22</ss:Data>
            <ss:Data ss:Type="String">NAME</ss:Data>

    but even though I have two cell elements in the Xml, the generated Excel shows all the data in single cell of Excel.

    Can any one tell me what I am missing in the xml.......due to which all the data is coming in single cell.

    Thanks a lot



    Monday, September 4, 2006 9:51 AM


  • Your file in not an XML (not well formed XML).

    Wednesday, September 6, 2006 12:40 AM