Sets or returns the caption displayed in place of an error.
public System.String FriendlyErrorCaption{ get; set; }
Public Property FriendlyErrorCaption() As String
ExcelApplication xla = new ExcelApplication(); Workbook wb = xla.Open(@"C:\MySpreadsheet.xlsx"); Worksheet ws = wb.Worksheets[0]; ws.PivotTables[0].PivotTableSettings.FriendlyErrorCaption= "ErrorCell";
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.FriendlyErrorCaption= "ErrorCell";
FriendlyErrorCaption is only displayed when ShowFriendlyErrorCaption is true.
FriendlyErrorCaption
true