Filtering the kind of data while loading the workbook from template file
Contents
[
Hide
]
Sometimes, you want to specify which kind of data should be loaded when building the workbook from a template file. Filtering loaded data can improve the performance for your special purpose, especially when using LightCells APIs. Please use the LoadOptions.getLoadFilter().setLoadDataFilterOptions property for this purpose.
Filtering the kind of data while loading the workbook from a template file
The following sample code loads only shape objects while loading the workbook from the template file which you can download from the given link.
The following screenshot shows the template file contents and also explains that the data in Red color and Yellow background will not be loaded because the LoadOptions.getLoadFilter().setLoadDataFilterOptions property has been set to LoadDataFilterOptions.SHAPE.
The following screenshot shows the output PDF which you can download from the given link. Here you can see, the data in Red color and Yellow background is not present but all shapes are there.