- Spread Windows Forms API Overview
- FarPoint.CalcEngine Assembly
- FarPoint.Excel Assembly
- FarPoint.PDF Assembly
- FarPoint.Win Assembly
- FarPoint.Win.Chart Assembly
- FarPoint.Win.Spread Assembly
- GrapeCity.CalcEngine Assembly
-
GrapeCity.Spreadsheet Assembly
- GrapeCity.CalcEngine
- GrapeCity.Core
- GrapeCity.Spreadsheet
- GrapeCity.Spreadsheet.Charts
- GrapeCity.Spreadsheet.Commands
-
GrapeCity.Spreadsheet.Commands.PivotTables
-
Classes
-
PivotTableCommand
-
Methods
- AddField
- AddPivotStyle
- ApplyPivotStyle
- AutoGroup
- ChangeField
- ClearFilters
- CreateFieldSettings
- CreatePivotTable
- DeleteField
- DeletePivotTable
- DrillToPivotField
- ExpandCollapsePivotField
- Filter
- Group
- ModifyPivotStyle
- MoveField
- MovePivotField
- Options
- PageFilter
- RefreshCaches
- RefreshPivotTable
- ReplacePivotStyle
- SortField
- ToggleDetailFieldItem
- Ungroup
- UpdateDataFieldSettings
- UpdateFields
- UpdatePivotField
- UpdateShowValuesAsSettings
- Properties
-
Methods
- PivotTableOptionsCommand
-
PivotTableCommand
-
Classes
- GrapeCity.Spreadsheet.Drawing
- GrapeCity.Spreadsheet.IO
- GrapeCity.Spreadsheet.IO.OpenXml
- GrapeCity.Spreadsheet.IO.Pdf
- GrapeCity.Spreadsheet.Localization
- GrapeCity.Spreadsheet.PivotTables
- GrapeCity.Spreadsheet.Printing
- GrapeCity.Spreadsheet.Slicers
- GrapeCity.Spreadsheet.UI
- GrapeCity.Spreadsheet.WinForms.Ribbon Assembly
- GrapeCity.Win.PluginInputMan Assembly
GrapeCity.Spreadsheet.Commands.PivotTables.PivotTableCommand.UpdateFields
UpdateFields Method
UpdateFields(IPivotTable, Tuple<int, PivotFieldOrientation>[], Tuple<PivotDataField, string>[])
Update row, column, page fields, and data fields of a PivotTable report or PivotChart report.
Declaration
public static Command UpdateFields(IPivotTable pivotTable, Tuple<int, PivotFieldOrientation>[] pivotFields, Tuple<PivotDataField, string>[] dataFields)Public Shared Function UpdateFields(pivotTable As IPivotTable, pivotFields As Tuple(Of Integer, PivotFieldOrientation)(), dataFields As Tuple(Of PivotDataField, String)()) As CommandParameters
| Type | Name | Description |
|---|---|---|
| IPivotTable | pivotTable | The IPivotTable object. |
| Tuple<int, PivotFieldOrientation>[] | pivotFields | The pivot fields of pivot table |
| Tuple<PivotDataField, string>[] | dataFields | The data fields of pivot table |
Returns
| Type | Description |
|---|---|
| Command | A update command. |