MarketplaceListingsCustom ActivityDataTable Utility Activity

DataTable Utility Activity

Bronze Certified

Custom Activity

0 reviews

563

DataTable Utility Activity

Bronze Certified

Custom Activity

0 reviews

563


Summary

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

Overview

This custom activity provides seven custom functionalities around DataTable object in UiPath:

1. Convert To HTML - This activity converts the DataTable to HTML table. This is useful to output DataTable in HTML table format for email or for web pages.

2. Convert To JSON - This activity converts DataTable to JSON object. This is particularly useful when calling any external REST API that requires data in JSON format.

3. Get Average Value - This activity returns the average of a given column in a DataTable.

4. Get Min Value - This activity returns the minimum value of a given column in a DataTable.

5. Get Max Value - This activity returns the maximum value of a given column in a DataTable.

6. Get Columns - This activity returns the list of string with DataTable's column names. This is useful when you need to check if a column exists in a DataTable before performing any operation.

7. Rename Column - This activity renames the existing column in a DataTable to a new name and returns the DataTable object with updated column name.

Benefits


Published: 15 Apr 2020 | Updated: 18 Dec 2020

Virangkumar Patel
Development Manager

Sydney NSW, Australia


License

MIT


Code Language

Visual Basic


Runtime

.NET Framework


Tags

custom-activity
datatable
[hackathon]

Compatibility

Tested on UiPath 2019.10.4 but should be able to run on older versions.


Dependencies

Newtonsoft.JSON version 12.0.3 or higher


Similar Listings