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.

Tue Aug 07, 2018 3:46 am

I am trying to create a pivot table in a different excel file . I don't want the source data to be present in this excel file. Could someone share the code or snippet for the following . Thank you for the help .

akhil007
 
Posts: 2
Joined: Mon Aug 06, 2018 9:40 am

Tue Aug 07, 2018 8:26 am

Hello,

Thanks for your inquiry.
I'm regret to tell you that our Spire.Xls doesn’t support using an external data source (like the data in another Excel file) when creating Pivot Table. If you have other questions, please feel free to write back.

Sincerely,
Nina
E-iceblue support team
User avatar

Nina.Tang
 
Posts: 1182
Joined: Tue Sep 27, 2016 1:06 am

Return to Spire.XLS