MarketplaceListingsCustom ActivityDataTable Utility Activity

DataTable Utility Activity

Bronze Certified

Custom Activity

0 reviews

524

DataTable Utility Activity

Bronze Certified

Custom Activity

0 reviews

524


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: 2020-04-15T08:21:14+00:00 | Updated: 2020-12-18T00:00:09+00:00

Virangkumar Patel
Development Manager

Sydney NSW, Australia


License

MIT


Code Language

Visual Basic


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