Pivot table using marker design

[QuyNguyen]

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

[amy.zhao]

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

[QuyNguyen]

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

[amy.zhao]

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

[QuyNguyen]

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

[amy.zhao]

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

[QuyNguyen]

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

[amy.zhao]

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