locked
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">
    <HEAD>
    <META HTTP-EQUIV="CONTENT-TYPE" CONTENT="application/vnd.ms-excel; charset=ISO-2022-JP">
    </HEAD>
    <BODY>
    <ss:Workbook>
        <ss:Worksheet>
          <ss:Table>
      <ss:Column c:Caption>
           <ss:Row>
            <ss:Cell>
            <ss:Data ss:Type="String">D22</ss:Data>
            </ss:Cell>
            <ss:Cell>
            <ss:Data ss:Type="String">NAME</ss:Data>
            </ss:Cell>
           </ss:Row>
          </ss:Table>
         </ss:Worksheet>
    </ss:Workbook>
    </BODY>
    </HTML>

    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

Answers

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

    Wednesday, September 6, 2006 12:40 AM