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.

Fri Apr 25, 2014 4:42 am

Hi,

I want to export excel from exist excel template that having pivot table. How do i do that, please help?

Best regards,
Quy Nguyen

QuyNguyen
 
Posts: 6
Joined: Mon Apr 21, 2014 3:46 am

Fri Apr 25, 2014 8:11 am

Dear Quy Nguyen,

Thanks for your inquiry.
Would you please provide us your excel template and your expected excel output? It will help us can clearly know your requirement and then provide you a live demo. Thanks.
You could also send your files to support@e-iceblue.com.

Best wishes,
Amy
User avatar

amy.zhao
 
Posts: 2766
Joined: Wed Jun 27, 2012 8:50 am

Fri Apr 25, 2014 11:44 am

Dear,

I gave you my file via email. You will see it clearly, i hop so.

Thank for your help so much.


Best regards,
Quy Nguyen

QuyNguyen
 
Posts: 6
Joined: Mon Apr 21, 2014 3:46 am

Mon Apr 28, 2014 8:15 am

Dear Quy Nguyen,

Thanks for your file.
Do you want to merge data into your template and then export a new excel file?
If so, please refer to Marker Designer demo in our website from the below link.
http://www.e-iceblue.com/Knowledgebase/ ... igner.html
http://www.e-iceblue.com/Introduce/exce ... r_designer

Best wishes,
Amy
E-iceblue support team
User avatar

amy.zhao
 
Posts: 2766
Joined: Wed Jun 27, 2012 8:50 am

Mon Apr 28, 2014 8:43 am

Dear,

Yes, I want to export data into my template, but my template has a exist pivot table that getting data range from sheet data. Marker Designer don't do it.

Please, you can give a solution.

Thanks you

QuyNguyen
 
Posts: 6
Joined: Mon Apr 21, 2014 3:46 am

Mon Apr 28, 2014 9:28 am

Dear Quy Nguyen,

Thanks for your reply.
I used the method workbook.LoadFromFile(); to load your template, unfortunately I got an error"Requested value 'vertical' was not found", sorry that I didn't go on doing a live demo with your template now. I have posted the error to our dev team.
We will provide you a live demo at once when the error is resolved.

Best wishes,
Amy
User avatar

amy.zhao
 
Posts: 2766
Joined: Wed Jun 27, 2012 8:50 am

Mon Apr 28, 2014 3:33 pm

Dear,

Thank for your help so much.

Our projects is almost used template to export excel. I look forward this problem can be resolve to finish demos for our projects and then we can purchase "Spire.XLS".

Best regards,
Quy Nguyen

QuyNguyen
 
Posts: 6
Joined: Mon Apr 21, 2014 3:46 am

Tue Apr 29, 2014 8:55 am

Dear Quy Nguyen,

We have done an investigation. Sorry that we have no method to merge data into the PivotTable of your template at present, but you could create a pivot table in your excel file.
You could refer to the below demos in our website.
http://www.e-iceblue.com/Introduce/exce ... ivot_table
http://www.e-iceblue.com/Knowledgebase/ ... B.NET.html
And I sent a live demo to you by e-mail.

Best wishes,
Amy
User avatar

amy.zhao
 
Posts: 2766
Joined: Wed Jun 27, 2012 8:50 am

Return to Spire.XLS