Asynchronous support for thread locking GBS operations Completed

Rob Sherratt

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

Official response

Mario at GemBox

Hi,

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

Regards,
Mario

Comment (1)

Lajos Szoke

9 years ago

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

New GemBox.Spreadsheet Feature Request

Author: Rob Sherratt
Creation date: Jul 3, 2015
Last update: Jan 8, 2020
Publish date: Jul 3, 2015