Method to extract values from selected cells of the same column or the same row with a "Loop in Excel" step in DS

Follow

You can set the "Offset" of a "Column" or a "Row" under the Finders tab of an Extract Cell step. Please refer to the procedure below.
For our explanations, we will name the loop range "Cell Loop".

1.png

Procedure

■Selecting a cell in the same column than the one selected in the Loop in Excel step

1. Add an Extract Cell step after the Loop in Excel step.
2. Select "Find At Named Range" under the Finders tab.
3. Select "Cell Loop" next to "Range".
4. Select "Row At Position" next to "Use".
5. Select "By Index" next to "Row".
6. Enter "1" next to "Offset".

2.png

 

■Selecting a cell in the same row than the one selected in the Loop in Excel step

1. Add an Extract Cell step after the Loop in Excel step.
2. Select "Find At Named Range" under the Finders tab.
3. Select "Cell Loop" next to "Range".
4. Select "Column At Position" next to "Use".
5. Select "By Index" next to "Column".
6. Enter "1" next to "Offset".

3.png


<Supplement>

・You can also set this in steps other than an Extract Cell step.
・If you enter a digit different than "1" in "Offset", you will extract the value of the cell separated from the selection according to the offset setting.

4.png

 

2 out of 2 found this helpful

Comments

0 comments

Please sign in to leave a comment.