Spreadsheet to collection and filter if required for Blue Prism

Hover over an image to enlarge

$0.00
Q4 Associates

This product is electronically distributed.

 

Description

A simple reusable process that you can call to load a spreadhseet into a collection. 

It handles all instance management and also allows you to pass through a filter. 

Prerequisities

Utility - Collection Management

Execution

Paste this page into any process and call as required

Inputs 

Path Name (text) - Path to the excel file

Lookup Value (text) - The value to filter on if required

Lookup Column Name (text) - The column to filter on if required

Worksheet Name (text) - The worksheet name if not sheet1

Remove Blank Rows? - Specifies to remove blank rows

Outputs

Output Collection (collection) - The collection returned

Row Count (number) - The count of rows returned. 

Objects Included

 

List of Actions

 

 

No posts found

Write a review
Immediately Available

Most products are downloadable and available immediately after purchase

Quality assurance and service

We vet all products for quality and best practise

Refunds within 20 days

You have 20 days to test your purchase and request a refund if it doesn't meet your expectations