Uipath Marketplace

はじめてのオートメーションをわずか数分で作成できます。Studio Web を試す

Data Manipulations

Data Manipulations

作成者: Lahiru Fernando

3

アクティビティ

ダウンロード数

10.8k

[戻る] ボタン
[戻る] ボタン
carouselImage0
[次へ] ボタン
[次へ] ボタン

要約

要約

Advanced Excel functions to manipulate data are quite hard to implement. This package includes activities that can be used to perform such advanced data manipulations without the need of Excel.

概要

概要

Activity Description

Performing advanced Excel functions without the use of Excel is quite hard. These functions are most of the time required by automation projects to handle different scenarios. This Data Manipulations package is an effort to ease out the hassle of using these advanced data manipulations within UiPath itself.

Activities included - All these activities are independent and does not require Excel to run:

  • Data Transpose: Similar to the Excel Transpose function. Provide a DataTable with data and it will transpose the data for you.
  • Network Days: Provide the start date and end date along with the holidays that fall within the period defined by the two dates. It will generate the number of working days and hours (number of days * 24).
  • Custom Date Series: Similar to the WORKDAY.INTL function in Excel. Provides a custom list of days based on the date pattern provided.

How it works

How it all works is described in the documentation attached. Please refer to the Resources section.

This is the initial version of this component. There will be many more activities coming up in future versions. Stay tuned for more activities that ease out your automation.

機能

機能

The activities in this package allow to perform complex data manipulations quite easily just by passing the required values in to the activity. The activities replace the requirement of writing highly complex code and logic to get the data manipulations done without using Excel.

その他の情報

その他の情報

依存関係

UiPath.Excel.Activities: 2.6.0 UiPath.Mail.Activities: 1.5.0 UiPath.System.Activities: 19.5.0 UiPath.UIAutomation.Activities: 19.5.0

コード言語

C#, Visual Basic

ランタイム

Windows レガシ (.Net Framework 4.6.1)

公開者

Lahiru Fernando

公開者ページを表示

ライセンス契約とプライバシー条項

MIT

プライバシー条項

技術情報

バージョン

1.0.6

更新日

2023年6月3日

対応製品

Studio: 21.10 - 22.10

認定

シルバー 認定済み

アプリケーション

Microsoft Excel

サポート

UiPath コミュニティ サポート

リソース

類似のコンポーネント