Workbook activities allow you to perform actions on Excel workbooks, such as creating, opening, closing, saving, and modifying files. They automate tasks like data extraction, data entry, and formatting.
Data table activities are used to work with Excel data tables, organizing and analyzing data in rows and columns. They enable operations such as reading data, writing data, filtering, sorting, and data manipulation within tables.
Workbook activities include:
Append Range Workbook: appends data to a specified range in an Excel workbook.
Get table Range Workbook: retrieves the range of a table in an Excel workbook.
Read Cell Workbook: reads the value of a specific cell in an Excel workbook.
Read Cell Formula Workbook: reads the formula of a specific cell in an Excel workbook.
Read Column Workbook: reads the values of an entire column in an Excel workbook.
Read Range Workbook: reads the values of a specified range of cells in an Excel workbook.
Read Row Workbook: reads the values of an entire row in an Excel workbook.
Write Cell Workbook: writes a value to a specific cell in an Excel workbook.
Write Range Workbook: writes data to a specified range of cells in an Excel workbook.
Source:
UiPath Academy
Comments
Post a Comment