Tag Archives: group

Outlining Excel Reports with ExcelWriter

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
  2. Read or set the level of outlining for any given row or column in a worksheet
  3. Read or set whether the group that a given row or column belongs to is expanded or collapsed
  4. Ungroup all the rows or columns in an area of a worksheet
  5. Detect where the summary rows or columns are located for all the groups in a worksheet
Sample output from ExcelApplication

Continue reading Outlining Excel Reports with ExcelWriter