...
- Example Pivot Table
- Break down
1. Create Set up the PivotTable
2. Refresh on open
data source
The data source needs to be a continuous block of cells with a header row with column names. The data source can be defined as an Area
or a NamedRange
. The column names become the
Here is a snapshot of the data for this tutorial:
<IMAGE>
2.
3. After creating the PivotTable, always set RefreshOnOpen
to true
.
Code Block |
---|
pt.PivotTableSettings.RefreshOnOpen = true;
|
ExcelWriter does not have the ability to render a PivotTable, so any modifications made to a PivotTable will not take affect until the output file is opened in Excel and the PivotTable is refreshed. If RefreshOnOpen
is true
, Excel will refresh the PivotTable when the workbook opens, which will re-render the PivotTable.
4. Next, add PivotTableFields
to the PivotTable. There are four types of PivotTableField
: DataFields
, RowLabels
, ColumnLabels
, and PageFields
(or report filters).
To add
Code Block |
---|
Info |
---|
5. Adding data fields - calculated fields, naming conventions, changing the display name
3. Adding a pivot table field - row labels / column labels, source fields, naming convention, changing the display name
4. Adding a page field - behavior
5. CHECK
...