Description
This activity allows you to insert or delete a row in an existing Excel document.
Studio Pro supports Microsoft Excel .xls and .xlsx file formats.
As of the 8.3 update, there are two ways of interacting with MS Excel - Microsoft Native and Generic. Navigate to the menu "Settings" → "Microsoft activities" to choose a method.
Microsoft Native uses standard Microsoft methods to interact with the Excel application. It requires Excel to be installed on your computer and extends the capabilities of interacting with all Excel functionalities.
Generic does not require Excel to be installed and may have some Excel functionalities limitations.
Parameters
Path
- Set a value option allows you to manually specify the path to the target excel document. Click the "PICK" button to open the file explorer and select the path.
- Calculate a value option allows you to use a special formula or a special method to determine the path.
- Save the previous step result option takes the result of the previous workflow action as the path.
- Insert - if this option is selected, an empty row will be inserted into the table.
- Delete - if this option is selected, a row will be deleted from the table.
Row
- Set a value option allows you to manually specify the number of the row to be inserted or deleted. For example, specify the number
2
to move the data from row2
to row3
, and leave row2
empty (with the "Insert" option picked). - Calculate a value option allows you to use a special formula or a special method to determine the row number.
- Save the previous step result option takes the result of the previous workflow action as the row number.
Row count
- Set a value option allows you to manually specify the number of rows to be inserted or deleted.
- Calculate a value option allows you to use a special formula or a special method to determine the number of rows.
- Save the previous step result option takes the result of the previous workflow action as the number of rows.
Excel sheet name
- Set a value option allows you to manually specify the name of the sheet in which you want to perform actions.
- Calculate a value option allows you to use a special formula or a special method to determine the name of the Excel sheet.
- Save the previous step result option takes the result of the previous workflow activity as the sheet name.
Comment
Allows you to add explanatory text to the block. The text will be displayed inside the block on top of the activity name.
Note. This activity adds information to Excel without formatting.