Hi Aspose team,
I have workbook which contains 3 spread sheets, first sheet has a general summary, second sheet has a pivot table, and third sheet has the pivot table data source which is generated dynamically. The problem is that when the workbook is exported to Pdf the pivot table has no data. This is the code I’m using to export, is there anything I’m missing? Thanks in advance!.
<span style=“font-size: 10pt; font-family: “Courier New”; color: blue;”>public<span style=“font-size: 10pt; font-family: “Courier New”;”> static void Export(HttpResponse httpResponse, string file)<o:p></o:p>
foreach (Worksheet worksheet in Workbook.Worksheets)
worksheet.PageSetup.CenterHorizontally = true;
Workbook.Save(file, SaveType.OpenInBrowser, FileFormatType.Pdf, httpResponse);