Message-ID: <1974516200.9847.1711704988177.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_9846_301662160.1711704988177" ------=_Part_9846_301662160.1711704988177 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
Sets or returns the caption displayed in place of a empty cell.
=20public System.String EmptyValueCaption{ get; s= et; }=20
Public Property EmptyValueCaption() As String=20
ExcelApplication xla =3D new ExcelApplication(); Workbook wb =3D xla.Open(@"C:\MySpreadsheet.xlsx"); Worksheet ws =3D wb.Worksheets[0]; ws.PivotTables[0].PivotTableSettings.EmptyValueCaption=3D "E= mptyCell";=20
Dim xla As New ExcelApplication() Dim wb As Workbook =3D xla.Open("C:\MySpreadsheet.xlsx"= ) Dim ws As Worksheet =3D wb.Worksheets(0) ws.PivotTables(0).PivotTableSettings.EmptyValueCaption=3D "E= mptyCell";=20
EmptyValueCaption
is only displayed when=20
ShowEmptyValueCaption is=20
true
.