Setting Pivot Table Option - For Empty Cells Show

You can set different pivot table options using Aspose.Cells for Node.js via C++. One such option is “For empty cells show”. By setting this option, all empty cells in a pivot table are displayed as a specified string.

Setting Pivot Table Option in Microsoft Excel

To find and set this option in Microsoft Excel:

1. Select a pivot table and right-click.
2. Select PivotTable Options.
3. Select the Layout & Format tab.
4. Select the For empty cells show option and specify a string.

Setting Pivot Table Option Using Aspose.Cells for Node.js via C++

Aspose.Cells for Node.js via C++ provides the PivotTable.setDisplayNullString and PivotTable.setNullString properties for setting the “For empty cells show” pivot table option.

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

//For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET
//The path to the documents directory.
var dataDir = RunExamples.GetDataDir(".");
var wb = new AsposeCells.Workbook(dataDir + "input.xlsx");
var pt = wb.getWorksheets().get(0).getPivotTables().get(0);
//Indicating if or not display the empty cell value
pt.setDisplayNullString(true);
//Indicating the null string
pt.setNullString("null");
pt.calculateData();
pt.setRefreshDataOnOpeningFile(false);
wb.save(dataDir + "output_out.xlsx");

Related Articles

• Formatting Pivot Table