Sub Activity – Excel
The Excel activity has the following sub activities:
- Close Workbook: This activity can be used to close an opened excel workbook.
- Delete Range: This activity allows the users to delete a specified range of cells in an excel workbook.
- Open Excel Application: This activity allows the user to open excel file of a specified path
- Read Cell: This activity allows the user to read cell from Excel Workbook.
- Read Range: This activity reads the value of a given range/scope of cells from an excel file.
- Set Active Sheet : This activity can be used to create a new sheet or set an excel spreadsheet as active to perform some operations.
- Write Cell: Writes a value into a predefined cell or range in the Excel Workbook.
- Write Range: Writes the data from a datatable variable in to a specific range of cells in an excel workbook.
| Activity Name | Common | Input | Output |
|---|---|---|---|
| Close Workbook | Label – A classifying string applied to an activity which can be renamed by the user. It is the display name. Disable – The user can enable or disable the activity. ContinueOnError – It specifies the remaining activities to be executed even when one fails. This field supports only Boolean values (True or False). By default, the value is false so execution terminates when an error occurs. Private – If selected, the log will not be shown in BOT Manager. | Workbook – The Workbook that you want to close. Only ExcelWorkbook variables are supported. | |
| Delete Range | Label – A classifying string applied to an activity which can be renamed by the user. It is the display name. Disable – The user can enable or disable the activity. ContinueOnError – It specifies the remaining activities to be executed even when one fails. This field supports only Boolean values (True or False). By default, the value is false so execution terminates when an error occurs. Private – If selected, the log will not be shown in BOT Manager. | Workbook – The Workbook that you want to delete from. Range – The range you want to delete. Supports Only strings. ShiftOption – Specifies where to shift the cells in the deleted range. | |
| Open Excel Application | Label – A classifying string applied to an activity which can be renamed by the user. It is the display name. Disable – The user can enable or disable the activity. ContinueOnError – It specifies the remaining activities to be executed even when one fails. This field supports only Boolean values (True or False). By default, the value is false so execution terminates when an error occurs. Private – If selected, the log will not be shown in BOT Manager. | WorkbookPath – Path of the Excel file you want to use. Path should be with the quotation mark. CreateNewFile – To create the excel file in the specified location, select the check box. Visible – In order to open the specified excel file in the foreground, select the checkbox. Or else, in the background all the actions will be performed. AutoSave – If selected, it saves the excel file automatically. Workbook Framework – Click the drop-down menu to select the workbook type to be created based on the category that was selected. | WorkbookWindow – The entire information from the specified Excel file will be stored in an ExcelWorkbook variable. |
| Read Cell | Label – A classifying string applied to an activity which can be renamed by the user. It is the display name. Disable – The user can enable or disable the activity. ContinueOnError – It specifies the remaining activities to be executed even when one fails. This field supports only Boolean values (True or False). By default, the value is false so execution terminates when an error occurs. Private – If selected, the log will not be shown in BOT Manager. | Workbook – ExcelWorkbook variable can be obtained from an Open Excel Application. Cell – To read the specified cell in the excel. | Result – Variable that stores the information from the specified Excel cell. |
| Read Range | Label – A classifying string applied to an activity which can be renamed by the user. It is the display name. Disable – The user can enable or disable the activity. ContinueOnError – It specifies the remaining activities to be executed even when one fails. This field supports only Boolean values (True or False). By default, the value is false so execution terminates when an error occurs. Private – If selected, the log will not be shown in BOT Manager. | Workbook – Workbook field will be auto-populated from previous activity. It supports only ExcelWorkbook variable. Range – Reads the range. If the mentioned range is as a cell, then the whole spreadsheet will be read starting from that cell. Include Header – Select if you want to extract the column headers along with the specified range. | Result – A DataTable variable that stores the extracted data from the specified Excel range. |
| Set Active Sheet | Label – A classifying string applied to an activity which can be renamed by the user. It is the display name. Disable – The user can enable or disable the activity. ContinueOnError – It specifies the remaining activities to be executed even when one fails. This field supports only Boolean values (True or False). By default, the value is false so execution terminates when an error occurs. Private – If selected, the log will not be shown in BOT Manager. | Workbook – Workbook field will be auto populated from previous activity. It supports only ExcelWorkbook variable. SheetName – Specify the sheet name on which you want to work. Accepts only string. CreateNew – To create a new sheet in the specified excel, select the check box. | |
| Write Cell | Label – A classifying string applied to an activity which can be renamed by the user. It is the display name. Disable – The user can enable or disable the activity. ContinueOnError – It specifies the remaining activities to be executed even when one fails. This field supports only Boolean values (True or False). By default, the value is false so execution terminates when an error occurs. Private – If selected, the log will not be shown in BOT Manager. | Workbook – Workbook field will be auto-populated from previous activity. It supports only ExcelWorkbook variable. Cell – The cell that you want to write to. For already existing cell, it overrides. Value – Enter the value you want to write in the specified cell. | |
| Write Range | Label – A classifying string applied to an activity which can be renamed by the user. It is the display name. Disable – The user can enable or disable the activity. ContinueOnError – It specifies the remaining activities to be executed even when one fails. This field supports only Boolean values (True or False). By default, the value is false so execution terminates when an error occurs. Private – If selected, the log will not be shown in BOT Manager. | Workbook – Workbook field will be auto-populated from previous activity. It supports only ExcelWorkbook variable. Range – The range of cells to which you want to write to. Data – Enter the data in order to write to the specified range. Include Header – Select in order to include the column header in the specified range. |