Hi,
I would like to download excel worksheet and change it into PDF for printing.
I would like a code that captures everything on the worksheet into PDF
Thanks
Anil_G
(Anil Gorthi)
May 20, 2023, 4:36pm
2
@Shannon_Quek
You have an activity save excel to pdf for that please use the same
https://docs.uipath.com/activities/docs/save-as-pdf-x
Cheers
I have tried that, however, it doesnt capture my whole excel sheet.
Leaving some of the information out. Is there an alternative?
@Shannon_Quek
Drag and drop the “Excel Application Scope” activity onto the workflow.
In the properties panel of the “Excel Application Scope” activity, specify the path to the Excel file you want to convert.
Drag and drop the “Excel Read Range” activity inside the “Excel Application Scope” activity.
In the properties panel of the “Excel Read Range” activity, configure the following:
Input > WorkbookPath: Provide the path and file name of the Excel file.
Input > SheetName: Specify the name of the worksheet you want to capture.
Output > DataTable: Create a DataTable variable to store the data from the worksheet.
Drag and drop the “Excel Close Workbook” activity after the “Excel Read Range” activity.
Drag and drop the “Export to PDF” activity onto the workflow.
In the properties panel of the “Export to PDF” activity, configure the following:
Input > SourceFilePath: Specify the path and file name of the Excel file.
Input > DestinationFilePath: Provide the path and file name for the PDF file you want to create.
Input > SheetName: Specify the name of the worksheet you want to capture.
Save and run the automation.
This process will read the specified worksheet from the Excel file, close the workbook, and then export the worksheet as a PDF file.
Note: Make sure to have the UiPath.Excel.Activities and UiPath.PDF.Activities packages installed in your project to access the necessary activities.