EXCEL TO PDF conversion

[Sajin_91 (Sajin Bhaskaran)]

Hi,

Iam trying to convert an Excel file to PDF using “Excel to PDF Activity”,I had alredy specified the source and the destination path, but still an error is show saying "System cannot fine the file specified?

pls help me to resolve it

Iam attaching the screen shot of the error for your reference

[arivu96 (Arivazhagan A)]

Did u installed excel in your machine?

You can’t use Microsoft . Office . Interop . Excel without having ms office installed.

Regards,
Arivu

[Palaniyappan (Palaniyappan P)]

Hi
Kindly check once whether we are able to open those excel files manually
Check with the file type and whether the application is installed or not
These are the reasons that lead to this error
Cheers @Sajin_91

[Sajin_91 (Sajin Bhaskaran)]

In some cases its getting converted , but in saome cases its showing this error…y that so?

[Palaniyappan (Palaniyappan P)]

Fine so you didn’t issue now with excel conversion
Then kindly try to open those files which failed, manually once in excel application
— and if that opens without error then Before using this conversion activity or as a previous activity to the one where we are trying to open excel, use a Kill process activity with process name as “EXCEL”

Hope that would work
Cheers @Sajin_91

[AshwinS2 (Ashwin S)]

hi @Sajin_91

Have U tried using this activity package

New Excel & PDF Activities Available

Hello All, I have build lots of Excel & PDF Activities which we use on a daily routine. Activities are as follows : - Pivot Table - Works with or without Excel Application Scope. Filter Range / Data - Works with or without Excel Application Scope. Find & Replace - Advanced Technology. (See the video) Text to Columns - Fixed width & Delimiter. Copy paste data - To same workbook or to other workbook without any format loss. Remove Duplicates - Single / multiple columns. Update Status in an Exc…

Thanks
Ashwin S

[Palaniyappan (Palaniyappan P)]

Fine

–this can be handled in many ways, hope this could help you resolve this

1. Kindly check you have the below assembly in your xaml, if not add it manually and restart your project and try again.

–For that open the xaml with notepad and we can check whether we have this assembly or not. If not mention the assembly reference, save it and run the process once again

2. if that doesnt work like you have the reference already available, then in the studio
   check whether you have this namespace in the import option. If not import and restart the studio once and try to run the process
   
   

3.Finally this could give you more insights on using Microsoft.Office.Interops

HOWTO: Use MS Office COM interop with UiPath

HOWTO: Use MS Office COM interop with UiPath This tutorial is a step-by-step guide on how to use MS Office COM interop with UiPath. There are many questions on the forums on how to use the Microsoft Office COM interop with UiPath. People were looking for ways to use the Invoke Code activity along with the Microsoft.Office.Interop.Excel or Microsoft.Office.Interop.Outlook assemblies. Some people have been able to get it to work, but others have not been able to get it to work even when followin…

Kindly try this and let know for any queries or clarification
Cheers @Sajin_91

[Sajin_91 (Sajin Bhaskaran)]

one more doubt,while executing the excel to pdf and publishing , i need to send that to an email as attachment.

But the debugg screen is not moving after publishing the pdf, its standing still for long time…y so?

[Palaniyappan (Palaniyappan P)]

@Sajin_91

But the debugg screen is not moving after publishing the pdf, its standing still for long time…y so?

May i know where this comes after
a screenshot if possible
well we can keep the whole stuff inside the try block of try catch activity
–where keep a send outlook mail activity in try block next to all the file conversion and in the attach file property of send outlook mail activity we can mention the path of the pdf file converted…
–and if any debug screen comes out (like an exception) it will go to catch block where we can first include a Element exists activity
–with that element exists activity we can select that debug window and if that occurs we will be getting a boolean output from the element exists activity whether its true or false
and lets name that variable out_boolean
–now use a if condition and mention like out_boolean = True
if true it will go to THEN part where can use a CLICK activity and click ok or any button on that popup that closes that window
–next to this if condition same again use a send outlook mail activity and in the attach file property mention the file path of the file

hope this would help you
but make sure that we validate that debug screen
Cheers @Sajin_91

[balupad14 (Balamurugan)]

Hi ,
Here is an activity to export the excel to pdf file.

UiPathGo - BalaReva Excel Activities

Hi, I have included a new activity called “Export WorkBook”. Using this activity that can able to export the workbook as PDF and XPS. Name Space : [image] Activity and Properties : [image] Note : Let me if you have any errors. I would be happy to get more suggestions and feedback (Possibly likes). Here is the video demonstration also. https://forum.uipath.com/t/excel-how-to-export-the-excel-to-pdf-xps/318056?u=balupad14 Regards Balamurugan.S

Regards
Balamurugan.S

[Maya_Bharani]

can u help me on excel to pdf payslip project

[balupad14 (Balamurugan)]

Hi @Maya_Bharani,

Take a look , it may help you.

UiPathGo - BalaReva Excel Activities

Hi, In the version 2019.9.3, I have included a new property that to extract the selected range cells as pdf file. [image] Note : If the cell range is blank, It will export the worksheet as pdf. The package has been attached in the beginning of the thread. Regards Balamurugan.S

Regards
Balamurugan.S

[Maya_Bharani]

sure thank you ,let me check

[Maya_Bharani]

It Has Some issue ,not working

[balupad14 (Balamurugan)]

What is the issue that you have ? Explain it with example …

Thank you
Balamurugan.S