Errors were detected in file- withan Excel file after creating it 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>

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!
I have attached the portion of code that run the loop that creates the file.  


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


 

arep