Skip to main content

Asynchronous support for thread locking GBS operations - Community / GemBox.Spreadsheet Feature Request - GemBox Support Center

With large files (> 30 MB) many very useful operations in GBS cause processor utilisation to go to 100% and lock the thread in which the operation is running because the operations are synchronous. Please could GBS implement asynchronous / threaded / spawned subprocess versions of the following operations? There would need also to be a callback mechanism when the async task completes, plus a mechanism for reporting progress percentage.

 

ExcelFile.Load

ExcelFile.Save

ExportToDataGridView

ImportFromDataGridView

ExtractToDataTable

InsertDataTable

CreateDataTable

 

Thanks,

Rob

Comments (2)

Lajos Szoke
For very large Excel files (close to the Excel limit of 1 million rows) the Save operation will take a while and the Progression Callback would be a very useful feature. I hope it makes it to the development stage. In absence of that I suppose I could run some benchmarks and approximate the save times based on how many rows were passed to GBS and suggest the customer how long the Save activity might take.

Thanks,
Lali Szoke
Mario - GemBox
Hi,

This feature request has been implemented and is available in latest versions of GemBox.Spreadsheet.

Regards,

Mario
GemBox d.o.o.