为 Excel 表创建切片器

可能的使用场景

切片器用于快速过滤数据。它可用于过滤表格或数据透视表中的数据。 Microsoft Excel 允许您通过选择表格或数据透视表然后单击插入 > 切片器Aspose.Cells 还允许您使用[工作表.Slicers.Add()](https://reference.aspose.com/cells/java/com.aspose.cells/slicercollection#add(com.aspose.cells.ListObject,%20com.aspose.cells.ListColumn,%20int,%20int)）方法。

请参阅以下示例代码。它加载了示例 Excel 文件包含一个表。然后它根据第一列创建切片器。最后，它将工作簿保存在输出 XLSX格式。

	// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java
	// Load sample Excel file containing a table.
	Workbook workbook = new Workbook(sourceDir + "sampleCreateSlicerToExcelTable.xlsx");

	// Access first worksheet.
	Worksheet worksheet = workbook.getWorksheets().get(0);

	// Access first table inside the worksheet.
	ListObject table = worksheet.getListObjects().get(0);

	// Add slicer
	int idx = worksheet.getSlicers().add(table, 0, "H5");

	// Save the workbook in output XLSX format.
	workbook.save(outputDir + "outputCreateSlicerToExcelTable.xlsx", SaveFormat.XLSX);