English
Summary
This package contains automations of advanced and frequently used DataTable features.
Overview
- Change Column Order - Changes the ordinal or position of the DataColumn to the specified ordinal or position.
- DataTable Operations - It compares DataTables to get matched, unmatched, combine list of all rows in both tables.
- DataTable to Dictionary - Converts DataTable to Dictionary.
- DataTable to HTML - Writes a DataTable to HTML String.
- DataTable to JSON- Writes a DataTable to JSON String.
- JSON String to DataTable - Writes a JSON String to DataTable.
- DataTable to XML- Writes a DataTable to XML String.
- Display DataTable Columns - It will print all column names of DataTable.
- Merge DataTable Horizontal - It will merge two DataTables Horizontally.
- Rename Column - It renames the column name with new name.
- Replace string in DataTable - It will help you to replace a particular string with a new string in the entire DataTable.
- Select certain Columns - It helps to select certain columns from DataTable.
- Skip/Take Rows - Skip/Take rows from a specified DataTable.
- Transpose DataTable - It converts DataTable Columns to Rows and Rows to Columns.
- DataTable Aggregate Functions - It helps to apply aggregate functions like Average, Count, Min, Max and Sum on a specified column in a given DataTable.
Benefits
Published: 24 Apr 2020 | Updated: 18 Dec 2020
License
Apache 2.0
Code Language
Visual Basic
Runtime
.NET Framework
Tags
Compatibility
Compatible with previous and current versions of UiPath Studio.
Dependencies
Newtonsoft.Json [12.0.3]
Documentation
Support
UiPath Community SupportSimilar Listings
Supported by Publisher
DataTable Manipulation
The Package contains multiple activities which are used to manipulate DataTable in a more advanced way like selecting and removing particular columns and row etc..
2 reviews
951
Bronze Certified
Easy DataTable Activities
The custom activities provide you to convert the data type, convert the dictionary to datatable and show the datatable values with column type.
1 reviews
3.7k
Bronze Certified
DataTable Utility Activity
This Custom Activity provides the ability to convert DataTable to HTML table, convert to JSON, find Min,Max and Average of a column, find column names and rename column in a DataTable
637
Bronze Certified
Mastek - Generic - Convert DataTable to HTML Table
This component is used to convert DataTable into HTML table format. The Output is HTML string which will be used directly or under HTML body to represent the HTML table
263
Bronze Certified
