Page tree

Versions Compared

Key

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

...

Excerpt

Changes the data source of the pivot table.

Signature
C#
C#

 public void ChangeDataSource(Area newArea)

Signature
vb.net
vb.net

 Public Sub ChangeDataSource(ByVal newArea As Area)

...

Param
newArea
newArea

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

Remarks

Exceptions
Exception
ArgumentException
ArgumentException

If a null reference is passed in as parameter instead of a valid Area object, or if the new data source is not in the same workbook, or
if not all the cells in the first row of the new area contain a value for the column name, then an exception of type ArgumentException will be thrown.