Spire.PDF is a professional PDF library applied to creating, writing, editing, handling and reading PDF files without any external dependencies. Get free and professional technical support for Spire.PDF for .NET, Java, Android, C++, Python.

Mon Apr 19, 2021 5:13 pm

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

sarveshprabhu@gmail.com
 
Posts: 35
Joined: Sat Mar 03, 2018 4:08 am

Tue Apr 20, 2021 2:49 am

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
User avatar

Marcia.Zhou
 
Posts: 858
Joined: Wed Nov 04, 2020 2:29 am

Tue Apr 20, 2021 4:58 pm

Hello Marcia,

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

Thanks,
Sarvesh

sarveshprabhu@gmail.com
 
Posts: 35
Joined: Sat Mar 03, 2018 4:08 am

Wed Apr 21, 2021 1:29 am

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
User avatar

Marcia.Zhou
 
Posts: 858
Joined: Wed Nov 04, 2020 2:29 am

Mon Jun 28, 2021 3:40 pm

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

sarveshprabhu@gmail.com
 
Posts: 35
Joined: Sat Mar 03, 2018 4:08 am

Tue Jun 29, 2021 7:47 am

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
User avatar

Annika.Zhou
 
Posts: 1643
Joined: Wed Apr 07, 2021 2:50 am

Mon Jul 05, 2021 6:03 pm

Hello,

Any update on solution for the PDF merge issue?

Thanks,
Sarvesh

sarveshprabhu@gmail.com
 
Posts: 35
Joined: Sat Mar 03, 2018 4:08 am

Tue Jul 06, 2021 2:15 am

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
User avatar

Annika.Zhou
 
Posts: 1643
Joined: Wed Apr 07, 2021 2:50 am

Mon Jul 12, 2021 6:02 pm

Hello,

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

Thanks,
Sarvesh

sarveshprabhu@gmail.com
 
Posts: 35
Joined: Sat Mar 03, 2018 4:08 am

Tue Jul 13, 2021 10:49 am

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
User avatar

Nina.Tang
 
Posts: 1182
Joined: Tue Sep 27, 2016 1:06 am

Fri Jul 16, 2021 5:57 pm

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

sarveshprabhu@gmail.com
 
Posts: 35
Joined: Sat Mar 03, 2018 4:08 am

Mon Jul 19, 2021 3:26 am

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
User avatar

Annika.Zhou
 
Posts: 1643
Joined: Wed Apr 07, 2021 2:50 am

Tue Jul 20, 2021 3:33 am

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

sarveshprabhu@gmail.com
 
Posts: 35
Joined: Sat Mar 03, 2018 4:08 am

Tue Jul 20, 2021 6:45 am

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
User avatar

Annika.Zhou
 
Posts: 1643
Joined: Wed Apr 07, 2021 2:50 am

Tue Jul 20, 2021 11:55 am

Hello,

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

Thanks,
Sarvesh

sarveshprabhu@gmail.com
 
Posts: 35
Joined: Sat Mar 03, 2018 4:08 am

Return to Spire.PDF