Error in converting Excel with image to PDF

[sarveshprabhu@gmail.com]

Hello
We are using Spire Office .net PDF convertor ( integrated with our application ) to convert pdf, excel, word, png, jpg files to convert and merge into one pdf.
Most of time program seems to work but it is giving issue on excel files which has images inserted.

I have attached excel file and the code.

Any help would be greatly appreciated.

Thanks,
Sarvesh Prabhu

[Marcia.Zhou]

Hello,

Thanks for your inquiry!

I tested your code with the latest Spire.Office V6.4.0, and found that the Spire.Xls.Converter class has been removed in the latest version. Since we will not maintain and update the old version, please refer to the following code to convert Excel to PDF with the new method and the new version.

Code: Select all

            MemoryStream ms1 = new MemoryStream();

            string docItem = @"E:\testdoc\Excel file and code\AttachMaps_ODOT PERMIT PRINT_02-04-2021 104502.xlsx";
            var workBook = new Workbook();
            workBook.LoadFromFile(docItem);

            foreach(Worksheet worksheet in workBook.Worksheets)
            {
                //set page size
                worksheet.PageSetup.PaperSize = PaperSizeType.PaperB4;
            }

            workBook.ConverterSetting.SheetFitToPage = true;
            workBook.SaveToStream(ms1, Spire.Xls.FileFormat.PDF);
            File.WriteAllBytes("saveExcel.pdf", ms1.ToArray());


Thanks for your understanding, if you have any other questions, just feel free to contact us.

Sincerely,
Marcia
E-iceblue support team

[sarveshprabhu@gmail.com]

Hello Marcia,

Thank you for a quick response. The solution you provided seem to resolve the issue.

Thanks,
Sarvesh

[Marcia.Zhou]

Hello Sarvesh,

Thanks for your feedback, and glad to hear that your issue has been solved.

If you encounter any issues related to our product in the future, just feel free to contact us.

Have a nice day!

Sincerely,
Marcia
E-iceblue support team

[sarveshprabhu@gmail.com]

Hello similar to above excel issue, I have problem sometime with adding a pdf documents and merging it.
Our program basically merges various documents ( excel, word, image, pdf ) and create one document.
Code for the program is in 1st post. but basically for pdf this is how we add it ( works for 90% of time but fails for specific pdf documents - see attached)

else if (docItem.ToLower().Contains(".pdf"))
{
PdfDocument doc = new PdfDocument(docItem);
doc.SaveToStream(ms1, Spire.Pdf.FileFormat.PDF);
}



Thanks,
Sarvesh Prabhu
BEM Systems

[Annika.Zhou]

Hello,

Thanks for your inquiry.
I tested your PDF file and did reproduce your problem when merging the saved PDF stream. I have logged the issue into our Bug tracking system with the ticket number SPIREPDF-4421. Our development team will investigate and fix it. Once it is resolved, I will inform you. Sorry for the inconvenience caused.

Sincerely,
Annika
E-iceblue support team

[sarveshprabhu@gmail.com]

Hello,

Any update on solution for the PDF merge issue?

Thanks,
Sarvesh

[Annika.Zhou]

Hello,

Thanks for your follow-up.
This issue has been resolved and it is going to test phase now. If the test goes well, we will provide a hotfix for you as soon as possible. Please give us more time, thanks for your understanding.

Sincerely,
Annika
E-iceblue support team

[sarveshprabhu@gmail.com]

Hello,

Let us know if there is further update on this thread.

Thanks,
Sarvesh

[Nina.Tang]

Hi,

Thanks for your follow-up.
The issue is in testing phase now and I have asked the testing team to speed up the testing. If the test goes well, we will provide the hotifx for you ASAP. Please spare us a little more time, thanks for your understanding.

Sincerely,
Nina
E-iceblue support team

[sarveshprabhu@gmail.com]

Hello,

DO you have some estimate on when I can expect a fix? I have a client who is waiting for this fix.

Thanks,
Sarvesh

[Annika.Zhou]

Hello,

Thank you for your follow-up.
Considering your situation, we compiled a temporary version for you. I have confirmed your issue has been resolved in this version. Welcome to download it. If there is still any question, please feel free to write back.

Sincerely,
Annika
E-iceblue support team

[sarveshprabhu@gmail.com]

Thank you for the fix. Fix resolved the issue with pdf but now I am getting "Evaluation Warning" added to document.

We did purchase this software and have license file in the folder. We are using .NET4.6 version.

Do I need to update anything on license.elic.xml file?


Thanks,
Sarvesh

[Annika.Zhou]

Hello,

Thank you for your feedback.
Sorry that I searched our purchase record but didn't find your purchase information according to your email. Can you please tell us your purchase email or order number? You could attach it here or send to us via email (support@e-iceblue.com). Thanks in advance.

Sincerely,
Annika
E-iceblue support team

[sarveshprabhu@gmail.com]

Hello,

The order # is Order No.4637
And the email is bemsystems@bemsys.com>

Thanks,
Sarvesh