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);
wd.SetDataSource(“ExportModel”, data);
//Times out after a while
wd.Process();
We have also tried to provide options to the Workbook but that does not seem to work as well.
If you are filling 350+ columns and 1 lakh rows in a single sheet, surely it will take some time to perform the task. More CPU and memory would be consumed too. Also, I guess if you are successful in generating the final file with such huge list of columns and records, MS Excel even will take time to open into it. Anyways, we need a simple console application (runnable) where you will use dynamic dataset/datatable(s) in code for your devised markers in the template file (please remove any inter dependencies for external database/data source), so we could execute your code seamlessly to find the performance issue. Also, could you tell when (after how much time in seconds/minutes) you got “Times out…” issue? After getting the solution, we will test your scenario on our end first and help you accordingly.