GrapeCity.Documents.Excel.IPivotTable.NullString

NullString Property

NullString

Gets or sets the string displayed in PivotTable cells that contain null values when DisplayNullString is true.

The default value is an empty string ("").

Declaration

string NullString { get; set; }

Property NullString As String

Examples

worksheet.Range["A1:B4"].Value = new object[,] {
    {"Name", "Value"},
    {"A", 100},
    {"B", null},
    {"A", 200}
};
IPivotCache pivotCache = workbook.PivotCaches.Create(worksheet.Range["A1:B4"]);
IPivotTable pivotTable = worksheet.PivotTables.Add(pivotCache, worksheet.Range["D1"], "SalesPivot");
pivotTable.DisplayNullString = true;
pivotTable.NullString = "(blank)";
string nullString = pivotTable.NullString;