Save Sheet as PDF Activity
The Save Sheet as PDF activity enables users to convert specified sheets within an Excel file into a PDF document. This activity provides options to save a single sheet, a sheet by index, or all sheets from an open Excel workbook.
| Field | Description | Requirement |
|---|---|---|
| Excel Name | The reference name of the Excel file which has already been opened or created is chosen in the dropdown. | Required |
| PDF Name | The PDF file name is written, including the full path. | Required |
| Sheet Name | The name of the sheet to work in Excel can be added. If not added, the first sheet is used by default. | Optional |
| Sheet Index | The index of the sheet to work in Excel. If not added, the first sheet is used by default. | Optional |
| All Sheets | If all worksheets in Excel will be saved as PDF, this field is selected. | Optional |
Implementation Examples
Field Setup - Excel Name: ${newExcel} - PDF Name: C:RobustanewExcel_to_PDF.pdf - Sheet Name: Sheet1 - Sheet Index: 5
Technical Notes
Ensure the specified Excel file is accessible and properly opened before executing this activity. File paths for PDF output must be valid and have appropriate write permissions on the target directory. When both 'Sheet Name' and 'Sheet Index' are provided, 'Sheet Name' takes precedence.