MarketplaceListingsCustom ActivitySplit Excel Workbook by Values and Queue Each

Split Excel Workbook by Values and Queue Each

Bronze Certified

Custom Activity

0 reviews

270

Split Excel Workbook by Values and Queue Each

Bronze Certified

Custom Activity

0 reviews

270


Summary

This process makes it simple to make queue items for subsets of data in an Excel sheet.

carouselImage0

Overview

The Split Workbook activity splits the data of an Excel sheet by the values in a given column and creates a separate workbook for each value. The DataTable returned can conveniently be used by the Queue All Workbooks activity to make a queue item for each workbook to be processed by a Performer. The Performer would consume the queued items which contain the path to the generated workbook files.

Benefits

Allows a process built to consume a sheet of data to be easily distributed across many robots. Works around file contingency on a single source file by splitting the file into sets of data to be processed separately.

It is especially useful when you have a group of rows in the sheet that represent a true transaction and therefore should be a single transaction in the queue.

Published: 05 Mar 2021 | Updated: 05 Mar 2021


License

MIT


Code Language

Visual Basic


Runtime

Windows Legacy (.Net Framework 4.6.1)


Tags

queue
workbook

Compatibility

Studio: 2020.10 - 2021.10


Dependencies

UiPath.Excel.Activities UiPath.System.Activities


Similar Listings