Internship
Student login
← Robotic Process Automation (UiPath) learning path
Robotic Process Automation (UiPath) · Module 5 of 10

Data manipulation and Excel automation

Process data with DataTables and Excel.

📖 Key ideas

  1. DataTables hold tabular data in memory.
  2. Read Range / Write Range for Excel sheets.
  3. Filter, sort, join and loop through rows (For Each Row).
  4. String manipulation: Split, Replace, Substring, Regex.
  5. Excel activities work with or without Excel installed (workbook activities).
💡 Real-life example: A DataTable is a spreadsheet held in the bot's hands while it works.
DataTableIn-memory table
Read RangeReads Excel data
For Each RowLoops through rows
RegexPattern matching for text