Free Support Forum - aspose.com

Not able to view charts in generated pdf from excel

hi

i am not able to view the chart in the generated pdf from excel

can any one provide me the quick solution for this issue.


thanks

Hi,


Please download and use the latest fix/version: Aspose.Cells for Java v7.4.3.1 it works fine. We have tested your case with it using your template file, it works fine.

For your information, Aspose.Cells renders the PDF file based on the print preview of the sheet(s) that is shown as per MS Excel, you may compare the print preview with the output PDF pages.

Sample code:

String _filePath = “_Current_Plan_Report.xlsx”;
Workbook book = new Workbook(_filePath);
book.save(“output_currplan.pdf”);

I have attached the output file here for your reference.

Thank you.

Thanks for quick reply

but what about the look and feel of the pdf generated.

if you observe the attached pdf i am not able to see the borders of the drop down and table border for data.


thanks

Hi,


Well, you need to refresh pivot table and its data to render PivotTable correctly, see the sample code below for your reference:

Sample code:


String _filePath = “_Current_Plan_Report.xlsx”;
Workbook book = new Workbook(_filePath);
book.getWorksheets().get(“Current Plan Report”).getPivotTables().get(0).refreshData();
book.getWorksheets().get(“Current Plan Report”).getPivotTables().get(0).calculateData();


book.save(“output_currplan3.pdf”);


Thank you.

Thanks for the reply.

i am able to solve the issue.




Hi,

Thanks for your posting and using Aspose.Cells.

It is good to know that you were able to resolve this issue. If you encounter any other issue, please feel free to post, we will be glad to help you further.