Get row as json
Get row as json activity allows to create a variable in JSON format of a row in the excel.
| *Excel name | The reference name of the excel file which has already been opened or created is chosen in the dropdown. |
| Sheet name | The name of the sheet to work in Excel can be added. If not added, it is accepted as the first sheet by default. |
| Sheet index | Index of the sheet to work in Excel. If not added, it takes the first sheet by default. |
| Row | Row index. |
| * Result variable name | Variable name of the return value. |
* Note: * Fields selected with are required, others are optional.
Excel name example
You can use the Excel name as shown in the example.
${newExcel}
Sheet name example
You can use the Sheet name as shown in the example.
Sheet1
Sheet index example
You can use the Sheet index as shown in the example.
5
Row example
You can use the Row as shown in the example.
0
Result variable name example
You can use the Result variable name as shown in the example.
getJSON