Error with OpenXML

Question

I am getting the following error after opening an Excel file that I just created with a C# program.

  <?xml version="1.0" encoding="UTF-8" standalone="yes" ?>

- <recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">

  <logFileName>error035480_01.xml</logFileName>

  <summary>Errors were detected in file 'X:\BatchOther\NYClaims\NYClaims_20110630.xlsx'</summary>

- <removedRecords summary="Following is a list of removed records:">

  <removedRecord>Removed Records: Cell information from /xl/worksheets/sheet.xml part</removedRecord>

  </removedRecords>

  </recoveryLog>

Sorry, when I paste it, the lines come with it.  Here is the snippet of code.  I only write out 1 header row and 10 data rows to test this.  I seems to all work and I get a successful execution, but when I open the Excel file it says that there were errors and removed the bad records.  I copied most of the code from and existing program, but wrote the following method to cut down on coding each cell.  Plus I have I am going to use this with other program and I had to make a method that would handle fields coming in from different SQL scripts.

      //-----------------------------------------------------------------------------------
      //Create Cell in spreadsheet
      public static void WriteCell(string sb, Row r, Cell c, int col, int row, int sv)
      {         PrintLog("sb=" + sb + "  r=" + r.ToString() + "  c=" + c.ToString() + "  col=" + col.ToString()
            + "  row=" + row.ToString() + "  sv=" + sv.ToString());

 
         if (sv == 1)
            c.DataType = CellValues.String;
         else
            c.DataType = CellValues.Number; 

 




         c.CellReference = cols[col] + row.ToString();
         c.CellValue = new CellValue(sb);
         r.Append(c);

      }


 
I have searched online, but I am not finding a solution.  I think it has to do with the message:


 
       Cell information from /xl/worksheets/sheet.xml part





 


But I do not know how to fix it.  I do not know if I put this in the correct forum!


 

Any help would be greatly appreciated.  If anyone needs something else let me know. 


 

arep