MarketplaceListingsCustom ActivitySplit Workbook by Values and Queue Each

Split Workbook by Values and Queue Each

Bronze Certified

Custom Activity

0 reviews

81

Split Workbook by Values and Queue Each

Bronze Certified

Custom Activity

0 reviews

81


Summary

These activities allow the user to easily convert a process written to handle a sheet of data from a workbook to a Dispatcher-Processor model that can be run on many concurrent robots.

Overview

The Split Workbook activity splits the data of a 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 Processor. The Processor would consume the queued items which contain the path to the generated workbook files.

Benefits


Published: 2021-03-05T08:01:58+00:00 | Updated: 2021-03-05T08:01:58+00:00


License

By clicking download you agree to the following license.


Code Language

Visual Basic


Runtime

.NET Framework


Tags

queue
split workbood
workbook

Compatibility

Studio 2020.10


Dependencies

UiPath.Excel.Activities UiPath.System.Activities