Desky.Datatable.Activities 1.0.10

.NET 6.0 This package targets .NET 6.0. The package is compatible with this framework or higher. 
dotnet add package Desky.Datatable.Activities --version 1.0.10                

                    
                

            
NuGet\Install-Package Desky.Datatable.Activities -Version 1.0.10
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package. 
<PackageReference Include="Desky.Datatable.Activities" Version="1.0.10" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
paket add Desky.Datatable.Activities --version 1.0.10                

                    
                

            
#r "nuget: Desky.Datatable.Activities, 1.0.10"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package. 
// Install Desky.Datatable.Activities as a Cake Addin
#addin nuget:?package=Desky.Datatable.Activities&version=1.0.10

// Install Desky.Datatable.Activities as a Cake Tool
#tool nuget:?package=Desky.Datatable.Activities&version=1.0.10

image

Desky Datatable Activities

Desky Datatable Activities is a custom Uipath library for UiPath designed to simplify and enhance data manipulation within DataTables. This library provides a variety of activities for converting data types, merging tables, splitting tables, summing values, and more.

Features

  • Convert Columns to Numeric: Converts specified columns in a DataTable to a numeric data type (double).
  • Convert Columns to Date: Converts specified columns in a DataTable to the DateTime data type.
  • Convert DataTable to HTML: Converts a DataTable into an HTML table format.
  • Merge DataTable: Merges two DataTables into one.
  • Reorder DataTable Columns: Reorders the columns of a DataTable based on specified order.
  • Split DataTable Vertically: Splits a DataTable into two separate DataTables based on a specified column index.
  • Sum Column Values: Calculates the sum of the values in a specified column of a DataTable.
  • Get Column Name By Index: Retrieves the name of a column at a specified index.
  • Get Column Index By Name: Retrieves the index of a column with a specified name.

Installation

  1. Download the latest release of the Desky Datatable Activities library.
  2. In UiPath Studio, go to Manage Packages and select nuget.org.
  3. Search Desky Datatable Activities* .
  4. Click Install to add it to your project.

Usage

Activities Overview

1. Convert Columns to Numeric

  • Description: Converts specified columns in a DataTable to a numeric data type (double).
  • Input: DataTable, List of Column Names.
  • Output: DataTable with converted columns.

2. Convert Columns to Date

  • Description: Converts specified columns in a DataTable to DateTime.
  • Input: DataTable, List of Column Names, Date Format.
  • Output: DataTable with converted columns.

3. Convert DataTable to HTML

  • Description: Converts a DataTable into HTML format.
  • Input: DataTable.
  • Output: HTML string representation.

4. Merge DataTable

  • Description: Merges two DataTables.
  • Input: Destination DataTable, Source DataTable.
  • Output: Updated Destination DataTable.

5. Reorder DataTable Columns

  • Description: Reorders DataTable columns based on specified order.
  • Input: DataTable, List of Expected Column Names.
  • Output: DataTable with reordered columns.

6. Split DataTable Vertically

  • Description: Splits a DataTable into two based on a specified column index.
  • Input: DataTable, Column Index.
  • Output: Two DataTables.

7. Sum Column Values

  • Description: Calculates the sum of values in a specified column.
  • Input: DataTable, Column Name.
  • Output: Sum of numeric values.

8. Get Column Name By Index

  • Description: Retrieves the name of a column at a specified index.
  • Input: DataTable, Column Index.
  • Output: Column Name.

9. Get Column Index By Name

  • Description: Retrieves the index of a column by its name.
  • Input: DataTable, Column Name.
  • Output: Column Index.

Contributing

Contributions are welcome! If you have suggestions for improvements or new features, please fork the repository and submit a pull request.

License

This project is free to use.

Contact

For any inquiries or issues, please contact [mydeskstones@gmail.com]. Contributors : David Oku, Chinyere Isiekwu

Product Compatible and additional computed target framework versions.
.NET net6.0-windows7.0 is compatible.  net7.0-windows was computed.  net8.0-windows was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

  • .NETFramework 4.6.1

    • No dependencies.

  • net6.0-windows7.0

    • No dependencies.

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
1.0.10 116 9/30/2024
1.0.8 100 9/30/2024

Features:
1.)Convert Columns to Numeric: Converts specified columns in a DataTable to a numeric data type (double).
2.) Convert Columns to Date: Converts specified columns in a DataTable to the DateTime data type.
3.) Convert DataTable to HTML: Converts a DataTable into an HTML table format.
4.) Merge DataTable: Merges two DataTables into one.
5.) Reorder DataTable Columns: Reorders the columns of a DataTable based on specified order.
6.) Split DataTable Vertically: Splits a DataTable into two separate DataTables based on a specified column index.
7.) Sum Column Values: Calculates the sum of the values in a specified column of a DataTable.
8.) Get Column Name By Index: Retrieves the name of a column at a specified index.
9.) Get Column Index By Name: Retrieves the index of a column with a specified name.