使用Node.js通过C++格式化切片器

可能的使用场景

您可以通过设置列数或样式等方式在Microsoft Excel中格式化切片器。Aspose.Cells for Node.js via C++还允许您使用Slicer.getNumberOfColumns()和Slicer.getStyleType()属性进行此操作。

格式化切片器

请参阅以下代码，它加载了包含切片器的sample Excel file。它访问该切片器并设置其列数和样式类型，然后将其保存为output Excel file。截图展示了在执行示例代码后切片器的外观。

示例代码

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

// The path to the documents directory.
const dataDir = path.join(__dirname, "data");
const filePath = path.join(dataDir, "sampleFormattingSlicer.xlsx");
// Load sample Excel file containing slicer.
const wb = new AsposeCells.Workbook(filePath);

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

// Access the first slicer inside the slicer collection.
const slicer = ws.getSlicers().get(0);

// Set the number of columns of the slicer.
slicer.setNumberOfColumns(2);

// Set the type of slicer style.
slicer.setStyleType(AsposeCells.SlicerStyleType.SlicerStyleLight6);

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