Accelerators
Partner Solutions
Professional Services
Collections
Sign In
Accelerators
Partner Solutions
Professional Services
Collections
Split Excel Workbook by Values and Queue Each
by Internal Labs
0
Activity
2.6k
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)
License & Privacy
MIT
Privacy Terms
Technical
Version
1.0.1Updated
Nov 9, 2021Works with
Studio: 21.10 - 22.10
Certification
Silver Certified
Tags
queue
workbook
Application
Microsoft Excel
Support
UiPath Community Support
Similar Listings