Use Do Filter Operation

DsExcel Java enables users to apply filters to slicers, thus enabling users to analyse bulk information in a spreadsheet quickly and effectively.

Use slicer do-filter operation

In order to use slicer to perform do-filter operation, refer to the following example code.

// Adding data to the table
worksheet.getRange("A:F").setColumnWidth(15);
worksheet.getRange("A1:F16").setValue(sourceData);
ITable table = worksheet.getTables().add(worksheet.getRange("A1:F16"), true);
table.getColumns().get(3).getDataBodyRange().setNumberFormat("$#,##0.00");

// Create slicer cache for the table.
ISlicerCache cache = workbook.getSlicerCaches().add(table, "Category", "categoryCache");

// Add slicer for table
ISlicer slicer1 = cache.getSlicers().add(workbook.getWorksheets().get("Sheet1"), "cate1", 
"Category", 30, 550, 100, 200);

// Execute the do filter operation. Here we are filtering vegetables.
slicer1.getSlicerCache().getSlicerItems().get("Vegetables").setSelected(false);

Clear slicer filter

In order to clear slicer filter, refer to the following example code.

// Adding data to the table
worksheet.getRange("A:F").setColumnWidth(15);
worksheet.getRange("A1:F16").setValue(sourceData);
ITable table = worksheet.getTables().add(worksheet.getRange("A1:F16"), true);
table.getColumns().get(3).getDataBodyRange().setNumberFormat("$#,##0.00");

// Create slicer cache for table.
ISlicerCache cache = workbook.getSlicerCaches().add(table, "Category", "categoryCache");

// Add slicer for table
ISlicer slicer1 = cache.getSlicers().add(workbook.getWorksheets().get("Sheet1"), "cate1", 
"Category", 30, 550, 100, 200);

// Execute the do filter operation. Here we are filtering vegetables.
slicer1.getSlicerCache().getSlicerItems().get("Vegetables").setSelected(false);

// Clear the slicer filter.
slicer1.getSlicerCache().clearAllFilters();