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

Versions Compared

Old Version 4

changes.mady.by.user Unknown User (ozgurt)

Saved on

compared with

New Version Current

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

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin
Introducedin
8.4
8.4
Description

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

If a An exception of type ArgumentException will be thrown if:

  • A null reference is passed in as a parameter instead of a valid Area object
, or if the
  • The new data source is not in the same workbook
, or
if not all the cells
  • Not every cell in the first row of the new area
contain
  • contains a value for the column name
, then an exception of type ArgumentException will be thrown.
  • The area for the new data source only has one row (PivotTables require at least two)