Aspose.Cells.Examples.CSharp.Articles.PivotTablesAndPivotCharts.SettingPivotTableOption.Run C# (CSharp) Method

        public static void Run()
        {
            // ExStart:SettingPivotTableOption
            // The path to the documents directory.
            string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);

            Workbook wb = new Workbook(dataDir + "input.xlsx");

            PivotTable pt = wb.Worksheets[0].PivotTables[0];

            // Indicating if or not display the empty cell value
            pt.DisplayNullString = true;

            // Indicating the null string
            pt.NullString = "null";
            pt.CalculateData();

            pt.RefreshDataOnOpeningFile = false;

            wb.Save(dataDir+ "output_out.xlsx");
            // ExEnd:SettingPivotTableOption
        }
    }