Can someone please tell me what is wrong with this simple worksheet. Excel is opening the workbook alright but is complaining that it repaired some cell information. Any help is greatly appreciated.

<?xml version="1.0" encoding="utf-8"?>
<worksheet xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships" xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/5/main">
  <sheetViews>
    <sheetView workbookViewId="0" />
  </sheetViews>
  <sheetData>
    <row r="1">
      <c r="A1">
        <v>Id</v>
      </c>
      <c r="B1">
        <v>Number</v>
      </c>
      <c r="C1">
        <v>ShipTo</v>
      </c>
      <c r="D1">
        <v>ShipFrom</v>
      </c>
      <c r="E1">
        <v>LineNbr</v>
      </c>
      <c r="F1">
        <v>AltDtlKey</v>
      </c>
      <c r="G1">
        <v>Size</v>
      </c>
      <c r="H1">
        <v>Color</v>
      </c>
      <c r="I1">
        <v>Instructions</v>
      </c>
    </row>
  </sheetData>
</worksheet>

This is my workbook.xml

<?xml version="1.0" encoding="utf-8"?>
<workbook xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships" xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/5/main">
  <sheets>
    <sheet name="Sheet1" sheetId="1" r:id="rId1" />
  </sheets>
</workbook>

Hi Shiv,

If you are entering strings directly into the "v" node ofa cell, use inline string element. Else, make a SharedString.xml file which will store all the unique strings, and enter the indexes of those stringsin the "v" nodes of a cell, an dalso set the type t="s" for the cell..

Btw.. you need not write so much XML with the help of the new SDK. Use the classes of the new SDK to generate the logical representations of workbook, worksheet, and write the data into the objects programatically.

-Regards,
nkchennai