We were founded in 2005 in a tiny apartment in Bucharest, Romania as DeskOver.

Fittingly, it was a customer who, in 2012, first saw the immense possibilities for us in the fledgling RPA market. Our desktop automation product launched in 2013. In 2015, we introduced our enterprise platform along with our new name.

Today, UiPath is the fastest-growing enterprise software company in history with scores of offices, thousands of employees, partnerships with the world’s best consulting and BPO firms, a 500,000-strong developer community, and 5MM+ robots at work in over 5,000 global enterprises.

Our mission is to deliver the leading Robotic Process Automation platform to our clients for an automation first mindset.

We build software robots that automate repetitive processes. Our software robots take on the tedious, mind-numbing work and free people to do the more stimulating, creative work worth doing.

But no matter how much we’ve grown, one thing hasn’t changed. We’re still building a company we love to work for

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.

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)

StatusFileFormat - currently only two formats are supported: Excel (default) or CSV

StatusFileExcludeColumns - allows you to omit specific columns from the Status file.

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

Excel ファイルや CSV ファイルなど、表形式データソースからの入力データを取得するために設定および最適化された Robotic Enterprise Framework。 入力データを Excel ファイルなどの表データから取得するプロセスを自動化するための出発点として、このテンプレートを使用できます。

RPA Consultant

What is the advantage of using this template? Is it possible to run thin on multiple robots at once?

When using this framework Status file doesnot have header

Hi Silviu,Is it possible to edit the name of this project? to promote re use of this framework?Thanks,Owen

Hi Silviu,An enhancement, in framework request to add remarks for Success transaction for status file ion Remarks column in status file is empty for Success Transaction (Remarks=string.empty). Is it worth creating out argument for Remarks in Process.xaml.If you can suggest some other better workaround for it.Please mailTo: dnigam@vmware.com for any queries and questions. Thanks,Devashish

Hi Silviu, Thanks for developing this. This saves a ton of time. Can you explain how to install it such that it will appear as an option on UiPath Studio?

Hey Silviu, great work so far!Question: if I need to append one extra column (scrapped text from application) to the generated status file (excel sheet) what do you recommend doing? modifying settransaction data or doing directly on the process? so basically I have a tabular data that I input in a application, but I would like to add that extra information that is generated after those inputs are done (something like a confirmation code) on a windows desktop custom app

Thanks a lot for the template. It is really useful. I'm expericencing some troubles while extracting zip files though. 12 files encountered errors in the headers, including Config.xlsx. I think I can make them up on my own, but it would be nice if you can fix this in case anyone else faces it in the future.

Ready made REFrameWork for Excel - Interesting modification to the original REFrameWork to be ready made for Excel files. The additions of the Status File with configurable log fields is very nice and allows for further manipulations of the failed transactions by the operations team. Although not many structural changes to the original version, really helps to get started in the same way for tabular input for all projects.
The modularity also helps and one can change the SetTransactionStatus.xaml as well as the new CreateStatusFile.xaml to fit different needs.
I would suggest as new features for a future release:
Configurable columns in the Status File - based on the log fields maybe? Although a separation might be better. This might be required in case parts of the transaction information is confidential and one might want to hide certain columns from the status file (which can be further sent over email automatically)
Currently Excel is supported without modification of the framework. The input file can be csv for instance, so a check for the extension and automatically using the correct activity (Read CSV vs Read Range). Also, native support for DB. Maybe another layer of separation (outside of Init) which will output the Transactions DataTable.
An interesting and useful feature is having support for resuming the work done based on what has been already processed (status file) - kind of the same mechanism that the Orchestrator queue has, but limited to one robot only (locally).


Very Useful - Thanks Silviu for this, it is very useful!


Very useful - Hello Silviu
, thanks for the collaboration. I have used this framework without any failure.


Excellent Work - Framework really wonderful. Added more additional sequences. Excellent work guys.


A very useful RE Framework - This is a very useful REFramework if you don't need Orchestrator. Very clean and friendly framework. Very good job Silviu !


Clean and Useful REFramework!  - Very useful if you don't use Orchestrator. Congrats! Good Job!


Very useful !!  - Very useful !! After few bug fixes it would be great (Bugs URL: https://go.uipath.com/question/reframework-for-tabular-data)


Very useful and nicely built - Very useful and the workflow is quite user friendly and easily understandable.. Well done..
As an additional node, I was think about getting data from text files which are delimited by a special character. Would be glad if such scenarios also can be considered and added as a structured datatable which can be used for processing. It would go hand in hand with CSV's and excel files :)
Thanks for your effort on this.. This is one of the best solutions i have seen for structured data..


Useful as a design pattern! - Useful as a framework design pattern for processing Excel tabular data!
Thank you!


 - Very simple REF but powerful and comes in handy!!!
Great work !


 - Thanks Silviu - really appreciate you taking the time to create this. I've used it on many occasions when tabular data is used. :) 


Looks like a great template but I am getting errors extracting the downloaded zip file. This was also recently reported by someone else in the Questions section
(resubmitted review changing from 3 to 5 stars: I was able to successfully extract the zip when downloaded from github. Hopes this helps someone else looking to use this template)

- Thanks Silviu, It is very useful framework! I will use it a lot! Good Job!

ReFramework for Tabular Data

ReFramework for Tabular Data

Help

How To