Convert excel to pdf without third party package, with no excel installed on machine

Help Studio
, ,
1

hi, any way we can convert excel file to pdf?
tried invoking powershell but its not working due to excel is not available in machine.

thanks

2

Yes, you can convert an Excel file to PDF in UiPath even if Excel is not installed on the machine. Here are a few ways to do this:

  1. Use a third-party library or tool to convert Excel to PDF: There are several third-party libraries or tools available that can be used to convert Excel files to PDF, such as Aspose.Cells, Syncfusion, or OpenOffice. You can use UiPath’s Invoke Code activity to call the library’s methods or functions to perform the conversion.
  2. Use a virtual environment or remote desktop: If Excel is not installed on the machine where UiPath is running, you can use a virtual environment or remote desktop to run the automation on a machine that has Excel installed. UiPath provides support for virtual environments like Citrix or Remote Desktop Protocol (RDP), which allows you to automate processes on a remote machine.
3

Hi @syezids

Install the UiPath.Excel.Activities package & use the Excel to PDF activity. In the properties panel, specify the path of the Excel file you want to convert to PDF. Then, specify the output path and name for the PDF file.

Note that the Excel application does not need to be installed on the machine for this activity to work. The activity uses the Microsoft Office Interop library, which is included with UiPath.

Hope this helps,
Best Regards.

4

i have UiPath.excel.activities 2.16.2 ibstalled but Excel to PDF activity is not there. is this being depreciated?

5

@syezids

I believe it’s not deprecated. Please try finding this activity availability:

https://docs.uipath.com/activities/other/latest/user-guide/save-as-pdf-x

Best Regards.

6

yep that’s the thing, ive read around forum seeing this activity is available to others, but when i check on mine its not there

image
image816×255 6.55 KB

i only have the normal UiPath.excel.activities

7

Hi, I checked with mine is UiPath.excel.activities v2.17.0-preview and it’s there. I think perhaps you are still in Classic Design Experience. You could Show the Modern Activities first, since the activities is only in Modern Design Experience.

Before ‘show modern’:
image

After ‘show modern’:
image

Regards,

8

yes you are correct, once filtered to show modern its there.
however, i still got this errror

image
image1231×42 3.82 KB

i thought we can use this activity without having excel installed? @arjunshenoy kindly advice

9

Hey @syezids ,

To use the Save Excel As PDF activity, excel must be installed in your machine.

Incase if excel is not installed in your machine and you can’t use any third party package, you have to write your own custom activity which will accept the HTML, Output PDF file path as a input and the output will be the PDF file in will the excel table will be saved.

Thanks,
Sanjit

10

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.