OfficeWriter Documentation
.
ExcelWriter v8 Docs
Space Shortcuts
Page tree
ConfigureSpace tools

Versions Compared

Old Version 7

changes.mady.by.user Alison Bird [softartisans]

Saved on

compared with

New Version 8

changes.mady.by.user Alison Bird [softartisans]

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Excerpt

Changes the data source of the pivot table PivotTable to a new Area.

Signature
C#
C#
public void ChangeDataSource(Area newArea)

...

Parameters
Param
newArea
newArea

An Area object representing the new data source in the same workbook.

...

Exception
ArgumentException
ArgumentException

An exception of type ArgumentException will be thrown if:

  • A null reference is passed in as a parameter instead of a valid Area object
  • The new data source is not in the same workbook
  • Not every cell in the first row of the new area contains a value for the column name
  • The area for the new data source only has one row (PivotTables require at least two)