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.

Tue Mar 11, 2014 10:41 pm

I cannot convert pivot table with pivotTable style to html or image.
how do I convert it?

this is sample code.
workbook.LoadFromFile("C:\Inetpub\wwwroot\test\Data\pivot_excel.xlsx")
Dim sheet As Worksheet = workbook.Worksheets("Pivot Table")
sheet.SaveToHtml("C:\Inetpub\wwwroot\test\Data\sample.html")

I can convert pivot table without pivotTable style.

thanks

jouji_s
 
Posts: 6
Joined: Fri Mar 07, 2014 6:22 pm

Wed Mar 12, 2014 3:07 am

Hello,
Thanks for your inquiry.
I'm afraid that it's impossible to preserve the style after pivot table to html conversion at present.
But I have added it as a new feature to the schedule of our dev team. If we have any progress, we will tell you.

If there are any questions, welcome to get it back to us.
Sincerely,
Gary
E-iceblue support team
User avatar

Gary.zhang
 
Posts: 1380
Joined: Thu Apr 04, 2013 1:30 am

Return to Spire.XLS