Use cases for AccessCacheOptions

Aspose.Cells Product Family
1

Hi,

We recently found out about AccessCacheOptions and related methods.

However, there seems to be little documentation available regarding this feature.
Can you provide some example scenarios, where using this feature would increate Aspose Cells performance?

Thanks in advance,
Taras

2

@TarasTielkes

Can you please provide more details about the specific scenarios you are interested in regarding the use of AccessCacheOptions with Aspose.Cells?

3

@TarasTielkes,

Please see the API Reference page on AccessCacheOptions for your reference.

Also, see the API reference pages. e.g.,
https://reference.aspose.com/cells/java/com.aspose.cells/workbook/#startAccessCache-int-
https://reference.aspose.com/cells/java/com.aspose.cells/workbook/#closeAccessCache-int-
etc.

Sample use-case:

Some users find the process gets slower when adding large number of comments to the worksheet. To improve the performance of adding comments, the user may use the cache mechanism( Workbook.StartAccessCache) before adding comments(because there is no other operations that may change the row height and column width). See the sample code snippet for reference.

.......
workbook.StartAccessCache(AccessCacheOptions.PositionAndSize);
var commentsTimer = Stopwatch.StartNew();
for (int i = 0; i < 50_000; i++)
{
     _ = sheet.Comments.Add(i, 0);
}
commentsTimer.Stop();
workbook.CloseAccessCache(AccessCacheOptions.PositionAndSize);
........

The above example code is provided in .NET but you may change to Java accordingly.