Export data with progressbar

Aspose.Cells Product Family
1

Hello


I want to export a large number of records to a worksheet. But, I want to show a progress bar to end-user that indicates how many records have been exported.

I know the Aspose does not have any user interface. Is there any way to find out how many records exported during exporting ?

Thanks.
2

Hi,


Thanks for your query.

I think you may try to use LightCells API if it works for your needs. The LightCells API is useful for creating huge Excel spreadsheets: with it, you need less memory and get better performance and efficiency. It is mainly designed to add/manipulate cell data one by one without building a complete data model block (using the Cell collection etc.) into memory. It works in an event-driven mode. See the document for your reference:

Thank you.