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(); } }