Wiki Markup |
---|
{introducedin: 8.4} {description} {excerpt}Sets or returns whether Microsoft Excel will automatically show a caption in place of a empty cell.{excerpt} {signature:C#} public boolean ShowEmptyValueCaption{ get; set; } {signature} {signature:vb.net}Public Property ShowEmptyValueCaption() As Boolean {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.ShowEmptyValueCaption= true; {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.ShowEmptyValueCaption= true; {code} {example} {remarks}While {{ShowEmptyValueCaption}} is {{true}} by default, {{[EmptyValueCaption|PivotTableSettings.EmptyValueCaption]}} also needs to be set. {remarks} |
Page History
Overview
Content Tools