eunice0121.com

Excel, CSV, Data Table activities with RPA(UiPath)

Excel, Data Table with Uipath

 

Excel Application Scope

Used for working with the specified Excel file

 

Making Data Table Activities

  • Build Data Table
  • Read Range
  • Read CSV
  • Data Scraping (Web)
  • Generate Data Table (Text)

 

Editing Data Table Activities

  • Add Data Column
  • Add Data Row
  • Clear Data Table
  • Filter Data Table
  • For Each Row in Data Table
  • Generate Data Table From Text (Text)
  • Joint Data Tables
  • Lookup Data Table : Return a cell value by Lookup option
  • Merge Data Table
  • Output Data Table  (CSV)
  • Remove Data Column
  • Remove Data Row
  • Remove Duplicate Rows
  • Sort Data Table
  • Get Row Item
  • Update Row Item

 

Handling Data Table Activities

  • Append Range : Add Data Table to the end of the specified Excel spreadsheet.
  • Get Table Range : Extract range of Data Table
  • Read Cell : the Cell value to String
  • Read Cell Formula : read the cell Formula and to String
  • Read Column : to IEnumerable
  • Read Row : to IEnumerable
  • Read Range : Read range and save the range of Data Table
  • Write Cell : Type value into Cell
  • Write Range : save Data Table

 

CSV Activity

  • Append CSV : Data Table into CSV file
  • Read CSV
  • Write CSV

Range Activity with Excel

  • Delete Column
  • Insert Column
  • Insert/Delete Columns
  • Read Column
  • Insert/Delete Rows
  • Select Range
  • Get Selected Range : Range of data to String
  • Delete Range
  • Auto Fill Range : Apply the specified formula to the designated range in the Excel file
  • Copy Paste Range : Copy value, formula… and then Paste
  • Lookup Range : Selected range with Lookup
  • Remove Duplicate Range
  • Read Range : Read Excel
  • Append Range
  • Write Range

 

Table Activities with Excel

  • Filter Table
  • Sort Table
  • Create Table : Create Table for range of Data Table

 

Cell Color activities with Excel

  • Get Cell Color : to string
  • Set Range Color : Variable is color and then Set the color to range

 

Sheet Activities with Excel

  • Get WorkbookSheet : Read sheet’s name each index
  • Get Workbook Sheets : Extract Sheets’ name and sort by index
  • Copy Sheet

 

Pivot Table Activities with Excel

  • Refresh Pivot Table : when the data in Pivot Table is changed
  • Create Pivot Table : in a selected sheet with selected parameter

 

Macro Activities with Excel

  • Execute Macro
  • Invoke VBA

 

Official Uipath Activities Documentation :  https://docs.uipath.com/activities/other/latest?fallbackReason=invalidPublicationType&isFallback=true&fallbackCount=1
Official Uipath Forum : https://forum.uipath.com/
Official RPA, UIPATH site : https://www.uipath.com/
All of UIpath Information : https://eunice0121.com/category/uipath/

 

 

 

,
,