I have an excel in which I can see 1 column of legends - (ref. to Image-1).
But when I try to convert to PDF(ref. to Image-2) and PPT(ref. to Image-3) I can see 2 columns of legends.
When I check (File --> Print ) print preview there also I can see 2 columns of legends but in the actual excel we can see only 1 column of legends. If you expand the legend then you will be able to see 2 columns of legends.
Could you please look into this and let us know the difference in the legend display from excel to pdf/pptx conversion.
Please find the attached excel sample report, pdf & ppt generated from the excel, code for excel to pdf and excel to pptx conversion.
Kindly let me know if any further info. if required.
Worksheet worksheet = workbook.getWorksheets().get(0);
Chart chart = worksheet.getCharts().get(“Chart 2”);
chart.toImage(dir + “output.png”);
Dear Babar Raza / Amzad Sahi,
Since we are converting the entire excel print area into a .png / .emf
image we cannot convert individual components of our report.
Could you please suggest us whether there is any workaround for this issue.