DataTable
The DataTable package provides powerful in-memory data manipulation capabilities for RPA automation. It allows you to create, modify, query, and transform tabular data structures similar to database tables or spreadsheets without requiring external files or databases.
DataTables are ideal for:
- Processing and transforming data extracted from various sources (Excel, CSV, databases, web scraping)
- Performing complex data operations like filtering, sorting, merging, and lookups
- Building temporary data structures for automation workflows
- Aggregating and analyzing data before writing to output destinations
Add Column
Robomotion.DataTable.AddColumn
Add Row
Robomotion.DataTable.AddRow
Append DataTable
Robomotion.DataTable.AppendDataTable
Clear DataTable
Robomotion.DataTable.ClearDataTable
Create DataTable
Robomotion.DataTable.CreateDataTable
Filter DataTable
Robomotion.DataTable.FilterDataTable
Get Column
Robomotion.DataTable.GetColumn
Get Row
Robomotion.DataTable.GetRow
LINQ Query
Robomotion.DataTable.LINQQuery
Lookup DataTable
Robomotion.DataTable.LookupDataTable
Merge DataTable
Robomotion.DataTable.MergeDataTable
Remove Column
Robomotion.DataTable.RemoveColumn
Remove Row
Robomotion.DataTable.RemoveRow
Sort Table
Robomotion.DataTable.SortTable