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 Feb 09, 2011 8:17 am

Hallo,

how can i refresh a pivot table on the first sheet?

also, it would be nice to find a sample code how to create a pivot table and chart.

Many thx for your reply.

Greets

Reinhold

reinhold
 
Posts: 10
Joined: Wed Feb 09, 2011 8:13 am

Thu Feb 10, 2011 9:06 am

Hi Reinhold,
Thanks for your inquiry.
A simple pivot table demo was attached.
Refreshing data source of pivot table is not supported at present.
Attachments
SimplePivotTable.zip
(13.88 KiB) Downloaded 494 times
Harry
Technical Support / Developer,
e-iceblue Support Team
User avatar

harry.support
 
Posts: 180
Joined: Mon Nov 08, 2010 3:11 pm

Thu Feb 17, 2011 12:03 pm

Hi Harry Hu,

thx for your reply, i use the example from you with vs 2010 and it doen't work.

The method or operation is not implemented. on the line: workbook.SaveToFile(name, ExcelVersion.Version2007);

maybe you could check these once again.

thx in advance.

Reinhold

reinhold
 
Posts: 10
Joined: Wed Feb 09, 2011 8:13 am

Wed Feb 23, 2011 1:54 am

Dear Reinhold,

There is a simple demo about pivot table, please check out the attachment.
Attachments
SimplePivotTable.zip
(43.67 KiB) Downloaded 501 times
Harry
Technical Support / Developer,
e-iceblue Support Team
User avatar

harry.support
 
Posts: 180
Joined: Mon Nov 08, 2010 3:11 pm

Return to Spire.XLS