topic RE: Excel (Working with a collection) in Product Forum

Excel (Working with a collection)

МаксимУманец — Mon, 09 Nov 2020 07:03:00 GMT

Good afternoon, I'm new to the blue prism, there is an Excel file that I added to the collection in it 16 columns and 3000 rows, how to further work with the collection and how to get the necessary data from it? (First you need to get a string and then a few cells from that string)

------------------------------
Максим Уманец
------------------------------

RE: Excel (Working with a collection)

david.l.morris — Mon, 09 Nov 2020 13:53:00 GMT

It sounds like you haven't gone through Foundation Training, which teaches the basics of things like Collection Manipulation. You may want to reach out for training because even with Blue Prism, it's typically not a good idea to develop without having been trained on how to use it.

The short answer for now, though, is that you'll probably want to use Loop stages, choose the collection name inside the loop stage start, and then use calculation stages or multicalculation stages inside the loop with expressions such as [CollectionName.FieldName] to get the values.

------------------------------
Dave Morris
Cano Ai
Atlanta, GA
------------------------------

RE: Excel (Working with a collection)

AndreyKudinov — Mon, 09 Nov 2020 14:35:00 GMT

Use Loop with collection. Every iteration you'll get a next row and refer to its cells as [Collection.ColumnName].

------------------------------
Andrey Kudinov
Project Manager
MobileTelesystems PJSC
Europe/Moscow
------------------------------