Hello,
Recently we have upgraded our license from version 8.1 to 18.6. We are facing some issues with older functionality.
We have a code which takes the excel bytes and generate new workbook. But now its throwing error while creating new workbook.
Code snippet -
private byte[] ConcatenateExcel(List<byte[]> resultList)
{
Workbook wb = new Workbook(FileFormatType.Xlsx);
wb.Worksheets.Clear();
foreach (var result in resultList)
{
var processingFile = new Workbook(new MemoryStream(result));
foreach (var ws in processingFile.Worksheets.OrderByDescending(sheet=>sheet.Index))//Order by descending in order to insert data sheet first.
{
var newSheetIndex = wb.Worksheets.Add();
var newWS = wb.Worksheets[newSheetIndex];
if (newWS != null)
{
newWS.Name = ws.Name;
newWS.Copy(ws, new CopyOptions() { CopyNames = true, ColumnCharacterWidth = true, CopyInvalidFormulasAsValues = true });
wb.Worksheets[newSheetIndex].IsVisible = ws.IsVisible; // We are getting exception here. As we try to insert first worksheet which is not visible. But others sheets are visible.
}
}
}
return GetBytes(wb, "Excel");
}