Message-ID: <2052305764.7667.1711617543492.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_7666_1222144696.1711617543492" ------=_Part_7666_1222144696.1711617543492 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
Sets or returns whether Microsoft Excel will automatically show a captio= n in place of an error.
=20public boolean ShowFriendlyErrorCaption{ get; = set; }=20
Public Property ShowFriendlyErrorCaption() As Bo= olean=20
ExcelApplication xla =3D new ExcelApplication(); Workbook wb =3D xla.Open(@"C:\MySpreadsheet.xlsx"); Worksheet ws =3D wb.Worksheets[0]; ws.PivotTables[0].PivotTableSettings.ShowFriendlyErrorCaption=3D = true;=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.ShowFriendlyErrorCaption=3D = true;=20
ShowFriendlyErrorCaption
is=20
false
by default. If it is set to true,=20
FriendlyErrorCaption
also needs to be set.