How can I use "Get Row Item " in bulk from multiple columns?


#1

Hi there. I want to extract row items from excel spread sheet. The sheet has columns named Column1, Column2, Column3 and has 10 rows with data in each columns.

I created the flow as below, but No.1-3 is too troublesome to define for each columns. Is there any way to do this in a one action?

In For each Row,

  1. Get Row Item (Column1)
  2. Get Row Item (Column2)
  3. Get Row Item (Column3)

Regards.


Sorry I found my mistake in the process and fixed.


#2

Natsumi様、

ExcelシートLoop するため

Excel Application Scope のなかしたの①と②ポイントやってください。

①Read Excel Activityつかってください。
②その あと
For Each Rowのなか
get row item つかってください。


#3

@Nara, thank you. I found my mistake in the process and fixed the topic. please refer my first posting again.
I also attached sample file. Regarding “Get Row Item” I do not want to repeat for the number of column… because in my actual work the number of column is 100.
test.zip (8.6 KB)


#4

Hello @NatsuOK

This post might help you on this :slight_smile:

Regards…!!
Aksh


#5

Thank you @aksh1yadav! It is very helpful for me.
Actually i want to assign each row item to different vaiable.
In the zip example, the variable is only 1 named “data”.

If I want to what i wanna do, the only way i can do is nest “For Each”?
Sorry for trouble you because i am just a beginner of programming…

–> for example;

DATA
variable = {nameV, ageV, sexV}
colmun_name = {nameC, ageC, sexC}
row1 = {Alex, 25, male}
row2 = {Sara, 30, female}

LOGIC (it seems too terrible)
For each row in DT
----For each item in column_name[]
--------For each item in variable[]
------------assign variable.item = column.item
------------do something for each variable
--------For each
----For each
For each row


#6

Why you are creating a variable array?
I have not tried and not sure about it. what about the scope of those variables and how you will create and use those in studio?
or you can use directly column value "Item(“columnName/columnNumber”) inside for each loop.


#7

awesome… done!

thank you very much:)