插入切片器

可能的使用场景

切片器用于快速筛选数据。它可以用来筛选表格或数据透视表中的数据。微软Excel允许你通过选择表或数据透视表，然后点击插入>切片器来创建切片器。Aspose.Cells for Node.js via C++还允许你使用Worksheet.getSlicers().add()方法创建切片器。

为数据透视表创建切片器

请查看以下示例代码。它加载包含数据透视表的示例Excel文件。然后根据第一个基础数据透视字段创建切片器。最后，将工作簿保存为输出XLSX和输出XLSB格式。下方截图显示了由Aspose.Cells for Node.js via C++在输出Excel文件中创建的切片器。

示例代码

const AsposeCells = require("aspose.cells.node");


// Load sample Excel file containing pivot table.
var wb = new AsposeCells.Workbook("sampleCreateSlicerToPivotTable.xlsx");

// Access first worksheet.
var ws = wb.getWorksheets().get(0);

// Access first pivot table inside the worksheet.
var pt = ws.getPivotTables().get(0);

// Add slicer relating to pivot table with first base field at cell B22.
var idx = ws.getSlicers().add(pt, "B22", pt.getBaseFields().get(0));

// Access the newly added slicer from slicer collection.
var slicer = ws.getSlicers().get(idx);

// Save the workbook in output XLSX format.
wb.save("outputCreateSlicerToPivotTable.xlsx", AsposeCells.SaveFormat.Xlsx);

// Save the workbook in output XLSB format.
wb.save("outputCreateSlicerToPivotTable.xlsb", AsposeCells.SaveFormat.Xlsb);

为Excel表创建切片器

请查看以下示例代码。它加载包含数据表的sample Excel file，然后基于第一列创建切片器。最后，将工作簿保存为output XLSX格式。

示例代码

const AsposeCells = require("aspose.cells.node");

// Load sample Excel file containing a table.
var workbook = new AsposeCells.Workbook("sampleCreateSlicerToExcelTable.xlsx");

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

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

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

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