Message-ID: <1650797354.10355.1711722457532.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_10354_185752635.1711722457532" ------=_Part_10354_185752635.1711722457532 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
Changes the data source of the PivotTable
to a new Area
.
public void ChangeDataSource(Area newArea)=20
Public Sub ChangeDataSource(ByVal newArea As Area)=20
Area
object=
representing the new data source in the same workbook.=20
Area newArea =3D worksheet.CreateArea("A1:C7"); pivotTable.ChangeDataSource(newArea);=20
Dim newArea As Area =3D worksheet.CreateArea("A1:C7") pivotTable.ChangeDataSource(newArea)=20
An exception of type ArgumentException
will be thrown if:=
p>=20
null
reference is passed in as a parameter instead of a =
valid Area
=
object