We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

XlsIO and DocIO to PDF conversion errors

Thread ID:

Created:

Updated:

Platform:

Replies:

53086 Dec 7,2006 05:16 PM Dec 22,2006 02:40 AM Windows Forms 10
loading
Tags: PDF
Administrator [Syncfusion]
Asked On December 7, 2006 05:16 PM

Hello,

I am finding few flaws when converting XlsIO and DocIO to PDF. Below is the code I use and attached is the orignial file and the associated pdf. If anyone can notice a flaw in the code or help it anyway it would be great.

Thanks.


Dim od As New OpenFileDialog()

If od.ShowDialog() = Windows.Forms.DialogResult.OK Then
Dim excelEngine As New ExcelEngine

' Instantiate the excel application object.

Dim application As IApplication = excelEngine.Excel

Dim myWorkbook As IWorkbook = application.Workbooks.Open(od.FileName)

Dim ms As New System.IO.MemoryStream()

myWorkbook.SaveAsXml("out.xml", ExcelXmlSaveType.DLS)
Dim pdfDocument As PDFLogicDocument = New PDFLogicDocument()
pdfDocument.OpenXml("out.xml")
'Save as PDF.
pdfDocument.Save(System.IO.Path.GetFileName(od.FileName.Remove(od.FileName.Length - 4, 4)) + ".pdf")
End If

PDF Documents.zip

Administrator [Syncfusion]
Replied On December 7, 2006 07:00 PM

Hi Nick,

I was able to reproduce the issue. I have forward this issue to the development team and will update you as soon as I hear back.

Sorry for the inconvenience caused.

Regards,
Prakash.

Administrator [Syncfusion]
Replied On December 8, 2006 11:48 AM

Hello Prakash,

Thank you for the quick reply. On another note, I am trying to find a way to avoid going though the trouble of save an out.xml file just to load back into memory a moment later. I tried using a memory stream but it returns an error Is there a way to avoid this step by using a stream?

Nick

Administrator [Syncfusion]
Replied On December 11, 2006 11:34 AM



>Hello Prakash,

Thank you for the quick reply. On another note, I am trying to find a way to avoid going though the trouble of save an out.xml file just to load back into memory a moment later. I tried using a memory stream but it returns an error Is there a way to avoid this step by using a stream?

Nick

I found my problem. I had to reset the memory stream to beginning of the stream.

ms.Seek(0, System.IO.SeekOrigin.Begin)


Administrator [Syncfusion]
Replied On December 11, 2006 05:03 PM

Hi Nick,

I am glad to know that your problem has been resolved and thanks for your update.

Regards,
Prakash.

Administrator [Syncfusion]
Replied On December 12, 2006 01:52 PM

The streaming problem has been resolved, but there is still a problem with PDF creation as mentioned in the very first post. Please let me know of your results as you find them.

Thanks,

Nick

Administrator [Syncfusion]
Replied On December 12, 2006 03:18 PM

Hi Nick,

I was able to see the problem. However could you please send me your sample C# application which would help me further investigating on this issue.

Regards,
Prakash.

Administrator [Syncfusion]
Replied On December 12, 2006 04:13 PM

Here is the sample VB .Net Application. It now uses a memory stream instead of the out.xml file.

Nick

TestSyncFusionWord2.zip

Administrator [Syncfusion]
Replied On December 13, 2006 05:31 PM

Hi Nick,

I was able to reproduce the issue. It looks that there are some bugs in XL to PDF conversion. However, I have forward this issue to the development team for getting their thoughts regarding this issue. I will update you with in a day or two.

I regret for the inconvenience caused.

Regards,
Prakash.

Administrator [Syncfusion]
Replied On December 21, 2006 05:37 PM

Hello Prakash,

I was wondering if there has been any progress on the issue?

Thanks.

Nick

Dhivya K [Syncfusion]
Replied On December 22, 2006 02:40 AM

Hi Nick,

Sorry for the confusion.

Currently we do not have full support for XlsIO and DocIO to PDF conversions.

We provide these features as utility for those who own all the three products. We can only convert simple Excel and word document into PDF. I could find that your Excel file to be very complex. This is the problem with Excel to PDF conversion.
Also, in your word document,I could find some shapes in it which are not currently supported.

We do not have any immediate plans of implementing these features in the near future.However we do have plans of improving this utility in the future.

Sorry for the inconvenience.

Regards,
Dhivya.

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;