Creating Excel file using open XML

I have been using the code example here for creating-excel-file-using-openxml this is simple enough code and it does work nicely i can send my data and save it as an .xlsx file. However when i open the file it is corrupted and needs to be opend as repaired. when i do open it all the data is there the formatting/styles are nissing but all the data is there.

looking at the log file i see this

error290880_01.xml

Errors were detected in file 'D:\M36_Results_22_04_2024 2_46_34 PM.xlsx'

Repaired Records: Format from /xl/styles.xml part (Styles)Repaired Records: Cell information from /xl/worksheets/sheet1.xml part

any help appreciated. i am new to openXML

I understand that you’re having trouble with an Excel file created using OpenXML. The file appears to be corrupted when opened in Excel, but the data is intact after the file is repaired. The log file indicates issues with the styles and cell information.

This issue might be due to Excel expecting a fully formatted file when using OpenXML1. That means just having a file with a workbook won’t suffice, it has to have the workbook, worksheets, and at least one sheet for it to open properly1.

Another common issue is not creating a new row for each iteration when adding data1. Essentially, you might be creating a single row with multiple rows inside of it1.

Here’s a simplified example of how to create a new row for each iteration:

foreach (var temp in tempList) 
{
    if (cellIdex == 12)     
    {
        cellIdex = 0;
        rowIdex = rowIdex + 1;
        row = new Row { RowIndex = rowIdex };
        sheetData.AppendChild(row);
    }
    cell = CreateTextCell(ColumnLetter(cellIdex), rowIdex, tempToString(), 3);
    row.AppendChild(cell);
    cellIdex = cellIdex + 1;
}

The most important part to note is the row = new Row {RowIndex = rowIdex};1.

If you’re still facing issues, you might want to try using the Open XML SDK Validator to check for any errors2.

Thanks

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Naimish Makwana2y ago
I understand that you’re having trouble with an Excel file created using OpenXML. The file appears to be corrupted when opened in Excel, but the data is intact after the file is repaired. The log file indicates issues with the styles and cell information.

This issue might be due to Excel expecting a fully formatted file when using OpenXML1. That means just having a file with a workbook won’t suffice, it has to have the workbook, worksheets, and at least one sheet for it to open properly1.

Another common issue is not creating a new row for each iteration when adding data1. Essentially, you might be creating a single row with multiple rows inside of it1.

Here’s a simplified example of how to create a new row for each iteration:
```
foreach (var temp in tempList) 
{
    if (cellIdex == 12)     
    {
        cellIdex = 0;
        rowIdex = rowIdex + 1;
        row = new Row { RowIndex = rowIdex };
        sheetData.AppendChild(row);
    }
    cell = CreateTextCell(ColumnLetter(cellIdex), rowIdex, tempToString(), 3);
    row.AppendChild(cell);
    cellIdex = cellIdex + 1;
}
```
The most important part to note is the row = new Row {RowIndex = rowIdex};1.

If you’re still facing issues, you might want to try using the Open XML SDK Validator to check for any errors2.

Thanks