IWorkbook excel close taking long time to close excel file

[Nilesh Mohite]

I am using below version of syncfusion

IWorkbook excel object takes 50 mins to 1 hour to close the file any suggestion why its taking long time?

i.e. workbook.Close();

below is the code snippet

public void Export(Stream outputStream)
{

//some calculation and analysis of code

//Writing data to excel file

if (workbook != null)
{
lock (typeof(ExcelExporter))
{
workbook.SaveAs(outputStream, ExcelSaveType.SaveAsXLS);
}

workbook.Close();

if (workbook is WorkbookImpl)
{
(workbook as WorkbookImpl).Dispose();
}

}

}

[Anbazhagan Raja]

Hi Nilesh,

We request you share the input Excel documents to reproduce the issue. It will help us to proceed further and provide you a solution earlier.
 

Regards,

Anbazhagan R.