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.