NPOI Excel Merging Causing “Repaired Records”

[DjMilenkovic]

When I merge cells while creating EXCEL I always get error when I try to open file I get error from the picture.

When I click on Yes button, a file can be opened. Only last sheet remains without cells merging.

But when I create a file without cells merging, I don't get any error when I open it.

Here is my code for cells merging:

for (int s = 0; s < 40; s++)
{
    excelSheets[i].AutoSizeColumn(s);
    if (i >= 4 && i <= 8) 
    continue;
    var merge = new CellRangeAddress(0, 1, s, s);
    excelSheets[i].AddMergedRegion(merge);
}

[tonyqus]

which version of NPOI are you using? Btw, I don't suggest put AutoSizeColumn inside a loop. It will be potentially very slow.

[DjMilenkovic]

I'm using 2.4.0 version inside ASP.NET Core. Thank you for advice