Excel into PDF

Help Studio
, ,
1

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

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

3

I have tried that, however, it doesnt capture my whole excel sheet.
Leaving some of the information out. Is there an alternative?

4

@Shannon_Quek

  1. Drag and drop the “Excel Application Scope” activity onto the workflow.
  2. In the properties panel of the “Excel Application Scope” activity, specify the path to the Excel file you want to convert.
  3. Drag and drop the “Excel Read Range” activity inside the “Excel Application Scope” activity.
  4. 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.
  1. Drag and drop the “Excel Close Workbook” activity after the “Excel Read Range” activity.
  2. Drag and drop the “Export to PDF” activity onto the workflow.
  3. 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.
  1. 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.

5

Hi @Shannon_Quek

  1. In UiPath Studio, go to Manage Packages and install the following packages if you haven’t already:
    • UiPath.Excel.Activities
    • UiPath.PDF Activities
  2. Use the Read range activity to read the excel and store it into DataTable.
  3. Use Export DataTable to PDF activity to convert the DataTable to a PDF file.
    - Input:
    - DataTable: Specify the DataTable variable from the previous activity.
    - OutputFile: Specify the path and name for the output PDF file.
  4. Save and run the workflow.