ExportTemplate1.zip (15.4 KB)
Issue Description :
I am trying to bind data on an excel template that has 350+ columns and has over 1 lakh records. When the code reaches the Process() method call, it runs an times out. There is no error or exception being thrown.
WorkbookDesigner wd = new WorkbookDesigner();
wd.Workbook = new Workbook(templatePath);
//Times out after a while
We have also tried to provide options to the Workbook but that does not seem to work as well.
LoadOptions opt = new LoadOptions();
opt.MemorySetting = MemorySetting.MemoryPreference;
wd.Workbook = new Workbook(templatePath, opt);
Attached the templates for your reference
Could you please advise what we can do in this case?