Loading GridWeb Data in Async Mode

When creating a Workbook with large data sets, or reading a big Microsoft Excel file, it will surely take more time and resources to do that. The total memory the process will consume is always a concern. There are measures which can be adopted to cope with the challenge. Aspose.Cells.GridWeb provides relevant options and APIs to reduce and optimize memory usage. It can also help the process work more efficiently and run faster. For a worksheet that contains large cell data, you may load the dataset asynchronously, which can improve the overall performance of the user’s experience.

Use the GridWeb.EnableAsync option to optimize memory and performance for cell data when building a large data set. When you set the option to true, the data loading will be based only on the currently visible window area. In short, when you scroll the worksheet’s cell data in GridWeb, it will load new data based on the current scroll position only.

The following example shows how to enable GridWeb’s async mode.