ReFramework for Tabular Data

Bronze Certified

Template

15 reviews

1.1k

Summary

Robotic Enterprise Framework configured and optimized to get the input data from a tabular data source, such as an Excel or CSV file.

Overview

This template can be used as a starting point for automating processes where the input data comes from an Excel file or other tabular data.
The project was created starting from the standard Robotic Enterprise Framework, available in UiPath Studio starting with version 2018.1. Several changes were made:
TransactionItem variable type changed to DataRow, instead of QueueItem.
Input data is read in the Init state and kept in memory in the TransactionData variable.
GetTransactionData workflow was changed accordingly to get a DataRow from input data based in Transaction Number.
A status file is created in the Init state and updated after each transaction, in SetTransactionStatus workflow.
Added new parameters in the Config file:
InputFilePath - can be either a CSV file (.csv file extension) or an Excel file (any supported extension)
InputFileSheetName (used only for Excel input files)
InputFileEncoding (used only if input file is in CSV format)
StatusFilePath
StatusFileFormat - currently only two formats are supported: Excel (default) or CSV
StatusFileExcludeColumns - allows you to omit specific columns from the Status file.

Benefits

Published: 18 May 2020 | Updated: 30 Oct 2020

Internal Labs

License

By clicking download you agree to the following license.

Code Language

Visual Basic

Runtime

.NET Framework

Enhanced REFrameWork…

Template

A UiPath Studio template upon which you can build, test and run attended and unattended business processes, irrespective of process data types and process linearity…

29 reviews

3.9k

Bronze Certified

Supported by Publisher

ReFramework for MailMessage Data…

Template

The Robotic Enterprise Framework configured and optimized to get the input data from a list of emails. This is an adapted framework version of the Generic ReFramework. …