Cells 4.7.0 saving to PDF does not save charts correctly

Aspose.Cells Product Family
1

In my application I save the workbook as an Excel 2003 or 2007 and then save the workbook to PDF. The PDF version has everything except for th bar chart.

Let me know if you need anything from me.

Thanks,

Duel

2

Hi Duel,

Thank you for considering Aspose.

Well, I have tested your scenario and created two different files (XLS and XLSX with bar charts) and then converted them to PDF with direct XLS2PDF conversion and it works fine. Please try the direct XLS2PDF conversion for converting Excel files to PDF. Please see the following sample code for direct conversion,

Sample Code:


//Instantiating an Workbook object

Workbook workbook = new Workbook();

//Open Workbook

workbook.Open("c:\\ClusteredBar.xls");

//Saving direct to PDF

workbook.Save(@"C:\book1.pdf",FileFormatType.Pdf);

If you still face any problem, please share your template files and we will check them soon.

Thank You & Best Regards,

3

Here are the snippets of code used to save the Excel and PDF files:

wkbk.Save(ConfigurationManager.AppSettings["ScoreCardDirectory"] + excelfilename, FileFormatType.Excel2007Xlsx);

wkbk.Save(ConfigurationManager.AppSettings["ScoreCardDirectory"] + pdffilename, FileFormatType.Pdf);

Attached are the files generated from the lines above.

I am unable to send my PDF file since it is 51MB. Why is the file so large?

4

Do I need to save the workbook in Excel format and close it then create a new workbook object load the saved Excel document and then save to PDF?

5

Hi,

Thanks for providing us the template xlsx file.

No, you don't need to do that as in the new version (4.7.0), we do not clear data after saving the workbook.

Well, after an initial test, we found the issue, we will figure it out. For your info, currently, we are on the process to enhance the Excel2Pdf conversion for xlsx charts.

Thank you.

6

Hi,

Thank you for considering Aspose.

Please try the attached latest fix. We have reduced the size of the generated PDF file. But we still do not support to convert the following 3D charts to image.

ChartType.Area3D

ChartType.Area3D100PercentStacked

ChartType.Area3DStacked

ChartType.Surface3D

ChartType.SurfaceContour

ChartType.SurfaceContourWireframe

ChartType.SurfaceWireframe3D

ChartType.Cylinder

ChartType.Cylinder100PercentStacked

ChartType.CylinderStacked

ChartType.CylindricalBar

ChartType.CylindricalBar100PercentStacked

ChartType.CylindricalBarStacked

ChartType.CylindricalColumn3D

ChartType.Pyramid

ChartType.Pyramid100PercentStacked

ChartType.PyramidBar

ChartType.PyramidBar100PercentStacked

ChartType.PyramidBarStacked

ChartType.PyramidColumn3D

ChartType.PyramidStacked

ChartType.Cone

ChartType.Cone100PercentStacked

ChartType.ConeStacked

ChartType.ConicalBar

ChartType.ConicalBar100PercentStacked

ChartType.ConicalBarStacked

ChartType.ConicalColumn3D

Thank You & Best Regards,

7

The issues you have found earlier (filed as 7727) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Amjad Sahi.
8

Hello,


Do you have plan to support the Area3D chart ?
9

Hi,

Thanks for your inquiry.

We will update you soon regarding support for Area3D chart in excel-to-pdf conversion feature.

Thank you.

10

Hi,

Thank you for considering Aspose.

Please try the attached latest version of Aspose.Cells. We have supported Area 3D Charts.

Thank You & Best Regards,

11

Aspose.Cells improved Excel to PDF and other rendering features. We have made the rendering features more robust and efficient with lots of enhancements, so you may directly save an Excel file to PDF file format. The charts, pivot tables, other drawing objects and formattings, etc. would be retained as they are in the Excel file when rendering the Excel workbook to PDF file format. Similarly Aspose.Cells supported Chart to image and Chart to PDF features with high fidelity and accuracy.

For more information on converting Excel files to PDF, Sheet to image, rendering chart to image and chart to PDF features, please follow the document links below:
Convert Excel Workbook to PDF
Chart Rendering
Converting Worksheet to Image using ImageOrPrint Options

Please download the latest version of Aspose.Cells for .NET from the following link:
Aspose.Cells for .NET (Latest Version)

You can also download the latest demos here for your complete reference.