MarketplaceListingsCustom ActivitySplit Excel Workbook by Values and Queue Each

Split Excel Workbook by Values and Queue Each

by Internal Labs

0

2.2k

Split Excel Workbook by Values and Queue Each

by Internal Labs

0

Custom Activity

2.2k

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 & Privacy

MIT

Privacy Terms

Technical

Version

1.0.1

Updated

09 Nov 2021

Certification

Silver Certified

Tags

queue
workbook

Application

Microsoft Excel

Support

UiPath Community Support