Sub Activity – Excel
Excel includes activities for interacting with Excel files, allowing automation to read, write, and manipulate data within spreadsheets.
The Excel category has the following sub activities:
Close Workbook: This activity can be used to close an open Excel workbook.
Input Properties:
- Workbook: Specify the Workbook to close. Only ExcelWorkbook variables are supported.
Delete Range: This activity allows the users to delete a specified range of cells in an Excel workbook
Input Properties:
- Workbook: Provide the Workbook from which the range should be deleted.
- Range: Specify the range to delete. Only string values are supported.
- ShiftOption: Specify the direction to shift the cells in the deleted range.
Open Excel Application: This activity allows the user to open an Excel file of a specified path.
Input Properties:
- WorkbookPath: Enter the path of the Excel workbook you want to open.
- CreateNewFile: Select the checkbox to create a new Excel file in the specified location.
- Visible: Select the checkbox to open the specified Excel file in the foreground. If not selected, all actions will be performed in the background.
- AutoSave: If selected, the Excel file will be saved automatically.
- Workbook Framework: Click the drop-down menu to choose the workbook type to create, based on the selected category.
Output Properties:
- WorkbookWindow: Stores the entire information from the specified Excel file in an ExcelWorkbook variable.
Read Cell: This activity allows the user to read cell from Excel Workbook.
Input Properties:
- Workbook: The ExcelWorkbook variable can be obtained from the Open Excel Application activity.
- Cell: Specify the cell to read from the Excel file.
Output Properties:
- Result: Stores the value retrieved from the specified Excel cell.
Read Range: This activity reads the value of a specified range of cells from an Excel file.
Input Properties:
- Workbook: The ExcelWorkbook variable can be obtained from the Open Excel Application activity.
- Range: Enter the range you want to read from the Excel file.
- Include Header: Select this checkbox to include the column headers with the specified range.
Output Properties:
- Result: Stores the extracted data from the specified Excel range in a DataTable variable.
Set Active Sheet: This activity can be used to create a new sheet or set an Excel spreadsheet as active to perform some operations.
Input Properties:
- Workbook: The ExcelWorkbook variable can be obtained from the Open Excel Application activity.
- SheetName: Specify the sheet name that should be set as the active sheet.
- CreateNew: Select this checkbox to create a new sheet in the specified Excel file.
Write Cell: This activity is used to write a value into a specified cell in the Excel Workbook.
Input Properties:
- Workbook: The ExcelWorkbook variable can be obtained from the Open Excel Application activity.
- Cell: Specify the cell to write to. If the cell already contains data, it will be overwritten.
- Value: Enter the value to be written in the specified cell.
Write Range: This activity writes the data from a datatable variable into a specific range of cells in an Excel workbook.
Input Properties:
- Workbook: The ExcelWorkbook variable can be obtained from the Open Excel Application activity.
- Range: Enter the range you want to read from the Excel file.
- Data: Enter the starting cell of the range where the data should be written.
- Include Header: Select this checkbox to include the column headers with the specified range.