topic Re: Read only Particular Data In Excel in Product Forum

Read only Particular Data In Excel

Vikash011 — Wed, 25 Aug 2021 16:12:18 GMT

Hi All,

I want to read only particular data from excel to collection. I have attached the template sheet screenshot. The highlighted in yellow is the value I need to read.

Re: Read only Particular Data In Excel

HarpreetKaur — Thu, 26 Aug 2021 01:32:21 GMT

Hello Vikash,

3 ways come to mind to achieve this:

If the excel strictly follows the same pattern i.e. the cells you want to read will never change position, you can start a collection loop, use GoTo <cell> and read it value and capture it in the collection field, Then go to the next cell bottom or right and keep looping through until you've covered the desired area. The logic build may take some time while writing it in blue prism studio but once set it should be fairly quick.
Get the entire excel into a collection and then use collection manipulation actions to find your values and transfer those into a separate collection.
IF the location is not going to be fixed you can simply write a macro and call it via the Excel VBO.

Regards
Harpreet

Re: Read only Particular Data In Excel

EVIPUTI — Thu, 02 Sep 2021 07:32:37 GMT

1) Get Worksheet as Collection Offset ,only selecting the columns you want with infinite rows.
2) Delete Empty Rows .

Or

1) Get Worksheet as Collection
2) Read All Fields from Collection
3) Loop All Fields from Collection | Decision stage--> Delete what is not required.