Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Wed Aug 09, 2017 4:38 am

Old data source of pivot table is: Sheet1!$A$1:$D$5
I want change to Sheet1!$A$1:$D$6

How can edit datasource of PivotTable?
Thanks.

daitranthanhhoa
 
Posts: 51
Joined: Mon Sep 19, 2016 3:04 am

Wed Aug 09, 2017 8:01 am

Hello,

Thanks for your inquiry.
Sorry it is not available at present.

Sincerely,
Jane
E-iceblue support team
User avatar

Jane.Bai
 
Posts: 1156
Joined: Tue Nov 29, 2016 1:47 am

Tue Feb 23, 2021 9:28 am

Hello,

Hope you are doing well.
Glad to inform you that we just released Spire.XLS Pack(Hotfix) Version:11.2.6 which implements this feature. Welcome to download it from the following links.
Our website: https://www.e-iceblue.com/Download/down ... t-now.html
Nuget: https://www.nuget.org/packages/Spire.Xls/11.2.6

Sincerely,
Elena
E-iceblue support team
User avatar

Elena.Zhang
 
Posts: 279
Joined: Thu Jul 23, 2020 1:18 am

Return to Spire.XLS