MarketplaceListingsCustom ActivitySplit Excel Workbook by Values and Queue Each

Split Excel Workbook by Values and Queue Each

by Internal Labs

0

2.1k

Split Excel Workbook by Values and Queue Each

by Internal Labs

0

Custom Activity

2.1k

carouselImage0

Summary

Summary


Overview

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.

Features

Features

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.

Additional Information

Additional Information

Dependencies


Code Language

Visual Basic

Runtime

Windows Legacy (.Net Framework 4.6.1)

Publisher

Internal Labs

Visit Publisher's Page

License

MIT

Technical

Version

1.0.1

Updated

09 Nov 2021

Certification

Silver Certified

Tags

queue
workbook

Application

Microsoft Excel

Support

UiPath Community Support