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.
-
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.
-
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.
- 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.
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”
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
Okey Thankyou Helpfull
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.