Dear,
I want to convert from xls to pdf. This is my code:
Dim excelEngine As New ExcelEngine()
Dim application As IApplication = excelEngine.Excel
Dim workbook As IWorkbook = excelEngine.Excel.Workbooks.Open("Sample.xls")
Dim st As New System.IO.FileStream("Samples.xml",System.IO.FileMode.Create)
workbook.SaveAsXml(st, ExcelXmlSaveType.DLS)
st.Seek(0, System.IO.SeekOrigin.Begin)
Dim pdf As New Syncfusion.Pdf.DLS.PDFLogicDocument
pdf.OpenXml(st)
pdf.Save("samples.pdf")
st.Close()
excelEngine.ThrowNotSavedOnDestroy = False
excelEngine.Dispose()
The output pdf file has problems:
- Header & footer not correct
- Chart does not display
- Merge does not work
- Maybe it alway wraptext.
Anybody can help me?
Please see my attachment file (xls file & pdf output file) and please help me to check it.
Thanks,
KhaiTD.
sample148.zip