Outlines in Excel are a useful way to organize and present lots of data in workbooks.  ExcelWriter offers several different ways to integrate outlines into Excel reports:

ExcelWriter’s Application object (available in Enterprise Edition), provides full control to modify Excel files programmatically. This includes adding or removing Excel outlines and more:

1. Group an area of rows or columns
   • Area.GroupRows()
   • Area.GroupColumns()
2. Read or set the level of outlining for any given row or column in a worksheet
   • RowProperties.OutlineLevel
   • ColumnProperties.OutlineLevel
3. Read or set whether the group that a given row or column belongs to is expanded or collapsed
   • RowProperties.OutlineCollapsed
   • ColumnProperties.OutlineCollapsed
4. Ungroup all the rows or columns in an area of a worksheet
   • Worksheet.UngroupRows()
   • Worksheet.UngroupColumns()
5. Detect where the summary rows or columns are located for all the groups in a worksheet
   • Worksheet.SummaryRows, Worksheet.SummaryRowsLocation
   • Worksheet.SummaryColumns, Worksheet.SummarycolumnsLocation

Continue reading Outlining Excel Reports with ExcelWriter →