Refresh/Create Pivot Tables

Technical support for Spire.XLS

Moderators: iceblue support, Flash, Manager

Refresh/Create Pivot Tables

Postby reinhold » 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

Re: Refresh/Create Pivot Tables

Postby harry.support » 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 278 times
Harry
Technical Support / Developer,
e-iceblue Support Team
User avatar
harry.support
 
Posts: 180
Joined: Mon Nov 08, 2010 3:11 pm

Re: Refresh/Create Pivot Tables

Postby reinhold » 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

Re: Refresh/Create Pivot Tables

Postby harry.support » 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 284 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

Who is online

Users browsing this forum: No registered users and 0 guests

cron