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