static void ChangeBehaviorOptions(IWorkbook workbook)
{
#region #Change Behavior Options
Worksheet worksheet = workbook.Worksheets["Report1"];
workbook.Worksheets.ActiveWorksheet = worksheet;
worksheet.Columns["B"].WidthInCharacters = 40;
PivotTable pivotTable = worksheet.PivotTables["PivotTable1"];
PivotBehaviorOptions behaviorOptions = pivotTable.Behavior;
behaviorOptions.AutoFitColumns = false;
behaviorOptions.EnableFieldList = false;
pivotTable.Cache.Refresh();
#endregion #Change Behavior Options
}
static void ChangeBehaviorOptions(IWorkbook workbook)
{
#region #ChangeBehaviorOptions
Worksheet worksheet = workbook.Worksheets["Report1"];
workbook.Worksheets.ActiveWorksheet = worksheet;
worksheet.Columns["B"].WidthInCharacters = 40;
// Access the pivot table by its name in the collection.
PivotTable pivotTable = worksheet.PivotTables["PivotTable1"];
// Restrict specific operations for the pivot table.
PivotBehaviorOptions behaviorOptions = pivotTable.Behavior;
behaviorOptions.AutoFitColumns = false;
behaviorOptions.EnableFieldList = false;
// Refresh the pivot table.
pivotTable.Cache.Refresh();
#endregion #ChangeBehaviorOptions
}
