Sign In
Create your first automation in just a few minutes.Try Studio Web →
Split Excel Workbook by Values and Queue Each
by Internal Labs
0
Activity
2.6k
Summary
Summary
This process makes it simple to make queue items for subsets of data in an Excel sheet.
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
UiPath.Excel.Activities, UiPath.System.Activities
Code Language
Visual Basic
Runtime
Windows (.Net 5.0 or higher)
Technical
Version
1.0.3Updated
May 27, 2024Works with
Studio: 22.10 - 23.10
Certification
Silver Certified
Application
Support
UiPath Community Support
Similar Listings
