Get Excel Sheets
Description
The Get Excel Sheets step retrieves all the sheet names present in the Excel file.
Configurations
| No. | Field Name | Description |
|---|---|---|
| 1 | Step Name | Specify the name of the step. This name has to be unique in a single workflow. |
| 2 | Start Node | Select the checkbox if you want to use the step as an input step. Note:: If the step is used as an input step, then you cannot pass previous step values. And, if the checkbox is clear then the step will work as an intermediate step and previous step fields can be passed to step. |
| Input Tab | ||
| 1 | Excel File Type | Select the format of the Excel file to be processed. Allowed formats are: Excel 2007 (Apache POI), Excel 97-2003 XLS (JXL), Excel Binary XLSB |
| 2 | Excel File Path | Select the file path of the Excel file from which you want to retrieve the sheet names. Or, Click Browse to select a file. After selection the file path appears in the field.The data type is String and the field is mandatory. Note: If the Start Node checkbox is selected, then you must specify the file path as an environment variable or a static value.And, if the Start Node checkbox is clear then you can pass the value from the previous step. |
| Output Tab: | ||
| 1 | Output Format | Select the format in which you want the sheet names to appear in the output. Allowed formats are:Separate Row: Each sheet name will be provided as a separate row. JSON Array: All sheet names will be combined into a JSON array and output as a single row. Comma Separated: All sheet names are concatenated into a comma-separated string and output as a single row. |
| 2 | Output Field | Specify the name of the output field to hold the result of the successful plugin execution. Default field name: sheetName. |