Page tree
Skip to end of metadata
Go to start of metadata

Intro

Add Excel's grouping and outlining functionality to a workbook with ExcelWriter to display nested data.

The sales data is based on the 2008 sales data from the sample AdventureWorks data base. The sales data is written into the worksheet and grouped by major product category.  Subtotal lines are written after each major product category.  Each group of product sales line items is also grouped into a collapsible outline.

If you need to display nested, subtotaled data in your Excel report, this demo will be particularly useful to you.

Icon

This sample stores some of the data in a CSV file, which is available for download under Downloads. The CSV parser used in the example code was developed by Andrew Rissing and can be downloaded from Code Project.

Code

Downloads

  • No labels