static void AutoOutline(Workbook workbook)
{
#region #AutoOutline
Worksheet worksheet = workbook.Worksheets["Grouping"];
workbook.Worksheets.ActiveWorksheet = worksheet;
// Outline data automatically based on the summary formulas.
worksheet.AutoOutline();
#endregion #AutoOutline
}
static void AutoOutlineValue(IWorkbook workbook)
{
workbook.LoadDocument("Documents\\SalesReport.xlsx");
workbook.BeginUpdate();
try
{
Worksheet worksheet = workbook.Worksheets["Sales Analysis"];
workbook.Worksheets.ActiveWorksheet = worksheet;
#region #AutoOutline
// Outline the data automatically based on the summary formulas.
worksheet.AutoOutline();
#endregion #AutoOutline
}
finally { workbook.EndUpdate(); }
}
