ASPOSE Total - Excel report generation for large data set

Aspose.Cells Product Family
1

We are using ASPOSE.total license to generate Excel report for large dataset ( greater than 10million records). We want to add totals(sub totals) in each sheet - please let us know how this can be achieved, since manually also its not possible because while generation all rows of sheets are utilised for dataset

2

@amdhawan,

Please note, in MS Excel files, the total number of rows and columns on a worksheet can be up to 1,048,576 rows by 16,384 columns and you cannot exceed than this. You may adopt some features/approaches provided by Aspose.Cells to generate such kind of large dataset report.

  1. Use Smart Markers. If you are not already using Smart Markers, they can help in generating subtotals and totals dynamically. This approach allows you to bind data from multiple data tables or other data source efficiently.

  2. Split data across multiple sheets. Given the large volume of data, it may be beneficial to split the dataset across multiple sheets. This can help manage performance and ensure that Excel can handle the calculations more effectively.

If you continue to experience issues, please provide more details about your implementation, and sample files and code snippets, so we could assist you better.