MarketplaceStudioActivitySplit Excel Workbook by Values and Queue Each

Create your first automation in just a few minutes.Try Studio Web

Split Excel Workbook by Values and Queue Each

Split Excel Workbook by Values and Queue Each

by Internal Labs

StarStarStarStarStarStarStarStarStarStar

0

Activity

Downloads

2.6k

back button
back button
carouselImage0
next button
next button

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)

Publisher

Internal Labs

Visit publisher's page

License & Privacy

License Agreement

Privacy Terms

Technical

Version

1.0.3

Updated

May 27, 2024

Works with

Studio: 22.10 - 23.10

Certification

Silver Certified

Application

Microsoft Excel

Support

UiPath Community Support

Similar Listings