Wiki Markup |
---|
{introducedin: 8.4} {description} {excerpt}Sets or returns the caption displayed in place of a empty cell.{excerpt} {signature:C#} public System.String EmptyValueCaption{ get; set; } {signature} {signature:vb.net}Public Property EmptyValueCaption() As String {signature} {example}{code:csharp|title=C#} ExcelApplication xla = new ExcelApplication(); Workbook wb = xla.Open(@"C:\MySpreadsheet.xlsx"); Worksheet ws = wb.Worksheets[0]; ws.PivotTables[0].PivotTableSettings.EmptyValueCaption= "EmptyCell"; {code} {code:vbnet|title=vb.net} Dim xla As New ExcelApplication() Dim wb As Workbook = xla.Open("C:\MySpreadsheet.xlsx") Dim ws As Worksheet = wb.Worksheets(0) ws.PivotTables(0).PivotTableSettings.EmptyValueCaption= "EmptyCell"; {code} {example} {remarks}{{EmptyValueCaption}} is only displayed when [ShowEmptyValueCaption|PivotTableSettings.ShowEmptyValueCaption] is {{true}}. {remarks} |
Page History
Overview
Content Tools