This video shall help you to understand - how to work with excel and data tables in UiPath. With examples of how to sort data in an Excel file and iterate through all rows.
- Excel application scope
- Opening a workbook - access modes
- Read and write range
- Sort data
- Iterate through all rows
- Output datatable
- Introduction [00:00]
- Excel operations [00:45]
- Misc spreadsheet activities [05:21]
- Sort table [07:15]
- Read / Write cells [08:10]
- Practical Example [10:02]