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.

Mon May 11, 2015 4:37 pm

hi, You can move the value as shown in the attached example (pivot) ??
Attachments
e-iceblue.zip
file one
(26.71 KiB) Downloaded 232 times

ict@sogedin.it
 
Posts: 63
Joined: Mon Jul 15, 2013 2:06 pm

Tue May 12, 2015 9:14 am

Hello,

Thanks for your inquiry.
So sorry that our product doesn't support this feature at this stage.

Best Regards,
Sweety

E-iceblue support team
User avatar

sweety1
 
Posts: 539
Joined: Wed Mar 11, 2015 1:14 am

Wed Jul 22, 2015 2:13 am

Hello,

Sorry to keep you waiting.
The new version of Spire.Office ( Spire.Office Platinum Version:2.12 ) added new feature to set dataField position in pivotTable.
Code: Select all
pt.Options.DataPosition =0//default is -1, which is in the last.

Please download it via link below and have a try:
http://www.e-iceblue.com/Download/download-office-for-net-now.html

Best Regards,
Sweety

E-iceblue support team
User avatar

sweety1
 
Posts: 539
Joined: Wed Mar 11, 2015 1:14 am

Fri Jul 24, 2015 6:16 am

Hello,

Have you tried the Spire.Office Platinum Version:2.12 and the code?
Has your issue been resolved?
Thanks for your feedback.

Best Regards,
Sweety

E-iceblue support team
User avatar

sweety1
 
Posts: 539
Joined: Wed Mar 11, 2015 1:14 am

Return to Spire.XLS