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

Versions Compared

Old Version 13

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

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 PivotTable to a new Area.

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

{signature}

{signature:
}
Signature
vb.net
vb.net
Public Sub ChangeDataSource(ByVal newArea As Area)

{signature}

{parameters}

{param:newArea}
An {{[Area]}} object representing the new data source in the same workbook.

{param}



{example}
{code:csharp|title=C#}
Parameters
Param
newArea
newArea

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

Example
Code Block
csharp
csharp
titleC#

Area newArea = worksheet.CreateArea("A1:C7");
pivotTable.ChangeDataSource(newArea);
{code} {code:vbnet|title=
 Code Block
vbnet
vbnet
titlevb.net
}

Dim newArea As Area = worksheet.CreateArea("A1:C7")
pivotTable.ChangeDataSource(newArea)

{code}
{example}


{exceptions}

{exception: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)

{exception}
 Exceptions
 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)