New DataTable Automation Activities Package for UiPath Windows Project - Available on UiPath Marketplace

[lakshman (Ganta lakshman)]

Hello UiPath Community!

I am excited to share that I’ve developed a new set of activities to streamline DataTable automation in UiPath. These activities are now available for download on the UiPath Marketplace under the package name DataTable.Activities.

With this activity library, you can easily manage, manipulate, and automate tasks involving DataTables. Whether you’re performing complex transformations or just need simple DataTable operations, these activities will save you time and simplify your workflows.

You can find the package by searching for DataTable.Activities in the Package Manager.

I hope these activities enhance your UiPath automation projects. Feel free to try it out and share any feedback or suggestions. Happy automating!

This package contains the below activities:

• Change Column Order - Changes the ordinal or position of the DataColumn to the specified ordinal or position.
• CheckMandatoryColumnsExist - Checks if all the mandatory columns exists in the DataTable.
• ConvertArrayIntoDataTable - Converts an array into the DataTable.
• DataTable Operations - Compares DataTables to be matched, unmatched, combines 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 - Prints all column names of a DataTable.
• Merge DataTable Horizontal - Merges two DataTables horizontally.
• Rename Column - Renames the column name with a new name.
• Replace string in DataTable - Replaces a particular string with a new string in the entire DataTable.
• Select certain Columns - Selects certain columns from a DataTable.
• Skip/Take Rows - Skips/Takes rows from a specified DataTable.
• Transpose DataTable - Converts DataTable Columns to Rows and Rows to Columns.

Features

1. We can easily change the column position.
2. We can easily convert the given DataTable to Dictionary, JSON, XML and HTML String, and we can also convert JSON string to DataTable.
3. We can easily replace a particular string in an entire DataTable.
4. We can easily convert Columns to Rows and vice versa.
5. We can easily replace column names and print all column names in a given DataTable.
6. We can merge two DataTables horizontally.
7. We can easily convert Arrays into DataTable.

DataTable Activities - RPA Component | UiPath Marketplace | Overview