Hi,
I am using aspose PDF V 4.1.0.0.
I am having trouble converting this xlsx document to PDF.
Herewith i have attached sample xlsx.
Code snippet:
Dim xmlFile As String = inpath & ".xml"
Dim wb As Aspose.Cells.Workbook = New Aspose.Cells.Workbook
wb.Open(inpath, FileFormatType.Excel2007Xlsx, “”)
wb.Save(xmlFile, FileFormatType.AsposePdf)
Dim pdf As Aspose.Pdf.Pdf = New Aspose.Pdf.Pdf
pdf.BindXML(xmlFile, Nothing)
pdf.Save(outpath)
Regards,
Karthik
Hello Karthik,
Sorry for replying you late.
I've tested the scenario using Aspose.Pdf for .NET 4.1.1 and Aspose.Cells 4.8.2 and I'm able to notice the issue "Error in Cell: T4-Invalid formula:"=ROUNDUP(Table154[[#This Row],[Ex-Hub
to V]]*1.06,0)"." when I've tried converting the document. In fact the issue is occurring over the line when Workbook object is trying to open the worksheet. So I think there is some problem with the source worksheet.
Besides this, I opened the document and saved it into Excel 2003 format and have tried the conversion process. The PDF document is being generated correctly without any issue. I've also tried the Direct-to-PDF conversion method of Aspose.Cells and the resultant PDF is being generated. I've attached the updated excel worksheet and resultant PDF's that I've generated. Please take a look.