Unacceptable results from EXCEL2PDF

Aspose.Cells Product Family
1

I am trying convert Excel file (attached) to pdf. Here is the code I use:

Protected Sub Button3_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button3.Click

Dim DataPath As String = MapPath(".") & "\Data\"

'Get the template excel file path.

Dim designerFile As String = DataPath + "InvestmentReview.xls"

'Specify the xml file path.

Dim xmlFile As String = DataPath + "InvestmentReview2.xml"

'Specify the pdf file path.

Dim pdfFile As String = DataPath + "InvestmentReview2.pdf"

Dim wb As Aspose.Cells.Workbook = New Aspose.Cells.Workbook()

wb.Open(designerFile)

wb.Save(xmlFile, FileFormatType.AsposePdf)

'Create a new Pdf object.

Dim pdf As Aspose.Pdf.Pdf = New Aspose.Pdf.Pdf()

'Now, Bind the xml file (Aspose.Pdf integrated), which is used as a medium file for conversion.

pdf.BindXML(xmlFile, Nothing)

'Save the pdf file.

pdf.Save(pdfFile)

End Sub

The new created pdf (attached) is does not reflect the original xls file. What am I doing wrong?

Thanks

Vlado

2

Hi,

When you convert xls file to pdf some drawaing objects, shapes etc. might not be properly rendered. You excel file contains formatted text boxes which are not supported yet, we will support it in our future versions. For chart not properly rendered (second sheet) as some formatting lost, we will look into it. For the third sheet, your print area is : A1:X13, so you should extend your print area if you want to render all the worksheet, you may try Aspose.Cells's PageSetup apis or manually set the print area in ms excel e.g.., Click menu option File|Page Setup and in the dialog set the print area in the Sheet tab.

Thank you.

3

Thanks

Vlado

4

Hi,

Please try this fix.

We have fixed the bug of wrong position of text box, chart series color.

We still could not support the autoshape in Cell A17,because the shape.MsoDrawingType is not MsoDrawingType.CellsDrawing.