We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Unable to download data where Template has 350+ Columns

Hi,
Issue Header:

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);

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.

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?

1 Like

@shkh,

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.