PLEASE HELP! HOW EXCEL FILE AS PDF FILE

I have a folder containing an Excel file, then I want to convert it to a PDF file without changing the file name and save it to a new folder

Hi @Kia1

Please check this

Hi , You can search for packages “ExcelToPDF” or use C # code to implement this capability.

@Kia1

  1. Drag and drop an “Excel Application Scope” activity onto your workflow and configure it to open the Excel file. Set the WorkbookPath property to the current item from the “For Each” loop.

  2. Within the “Excel Application Scope”, use the “Send Hotkey” activity to send the keystrokes needed to save the Excel file as a PDF. You’ll need to send the hotkeys for the following actions:

  • Press Ctrl + P to open the print dialog.
  • Press Enter to print as pdf.
  • Provide the same file name and click on save button.
  1. Drag and drop a “Move File” activity outside of the “Excel Application Scope” activity but still inside the “For Each” loop. Configure it to move the PDF file to the output folder. Set the Source property to the file path of the PDF file, and set the Destination property to the path of your output folder.

there is no exceltopdf package in UiPath

May I see an example?

i have done “excel application scope” and “for each”

but I’m confused about your flow, don’t you need “For each in File Folder”

Hi @Kia1

Try this way:

Hope it helps!!

don’t you use the “For each file in folder” activity?

because I have a lot of excel files in a folder, then I want it to be a PDF file and saved to a new folder

Hi @Kia1

Try this:

Check this thread

Hope it helps!!

Okey Thankyou Helpfull

1 Like

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