Export Excel File
Activity converts Excel file into .pdf or .xps document.
In Exported File Path textbox you should type full path to the file (ending with the name of the destination file). If you do not fill in this textbox - the target file will be placed in the same place as the output .xlsx file with the same name as the output .xlsx file (with extension .pdf or .xps). If you don't specify a sheet name (in Worksheet Name textbox) - all sheet tabs that are in output .xlsx file will be converted. Page range (First Page, Last Page) of the converted file are optional parameters - without this informations all document will be converted. When specifying a page range, make sure you also specify the Worksheet Name.
There is a checkbox Ignore Print Area (default is on). If you want to convert only the previously created Print Area - remove the tick from the checkbox and make sure you also specify the Worksheet Name. In the case of an Excel file with many sheets, when you do not enter the name of a specific sheet, you will receive a sequence of converted pages consisting of entire output sheets (those in which the print area was not selected) interspersed with only print areas from sheets in which this setting was active.
NOTE: character limit in Exported File Path is 218.
| Parameter Name | Parameter Type | In/Out | Description |
|---|---|---|---|
| Alternative Scenario If Failed | Boolean | Input | checkbox; default is "on" |
| Display Name | Literal | Input | you can change the name of activity for greater clarity of the scenario |
| Exclude from Transaction Check | Boolean | Input | checkbox; default is "off" |
| Exported File Path | String | Input | full path to an exported file ([disc]:\[directory_tree]\[filename]) |
| First Page | Int32 | Input | Excel page range to be exported: number of page "from" |
| Format | Dropdown | Input | choose the target file format (.pdf or .xps) |
| Ignore Print Area | Boolean | Input | checkbox; default is "on" |
| Last Page | Int32 | Input | Excel page range to be exported: number of page "to" |
| Retry timeout [s] | Double | Input | waiting time until the activity will execute: 1. any negative value means try once, if you fail – set Result to False and finish activity; 2. “0” means try until you get the effect; 3. any positive value is time in seconds in which the activity will persist trying until successful or the time elapses, if failed – set Result to False and finish activity |
| Workbook Name | String | Input | custom internal name for Excel file, in order to identify Excel workbook in Wizlink |
| Worksheet Name | String | Input | name of the Excel sheet |
| Result | Boolean | Output | returns the Boolean value: it will return True if no error is in activity, otherwise it will return False |
| Result Code | Int32 | Output | Result Code will return 0 if there is no error in activity, otherwise in most cases it will return 1, the extended result code will show only in several chosen activities |
Last edited: 2023, 03 July.