Loop excel

Learn Academy Feedback
1

Hi all
I need to copy range of excel cell in to application
A1 name
B1 age
How to copy
A2
B2

2

You mean to say you want to extract the data from Respective Columns?
If yes, then simply use a read range activity. That will give you a Data Table.
Then Iterate through that data table and extract the data using row(“Name”) and row(“Age”).
Now use these values in your application.

Tell me if this helps you :slight_smile:
Regards
Niket Ghai

3

I will attach my sample application and excel sheet pls help

4

Thanks for reply

5

222

# Contract Number Due Type Amount (Rs.) Journal Remark
1 VH/01/1/6077/G Hire Charge 1,588.80 WHT Deduction - Apr/May/Jun 2018
2 VH/01/1/5928/G Hire Charge 3,834.90 WHT Deduction - Apr/May/Jun 2018
3 VH/01/1/5931/G Hire Charge 1,560.00 WHT Deduction - Apr/May/Jun 2018
4 VH/01/1/5932/G Hire Charge 1,560.00 WHT Deduction - Apr/May/Jun 2018
5 VH/01/1/5933/G Hire Charge 1,560.00 WHT Deduction - Apr/May/Jun 2018
6 VH/01/1/5935/G Hire Charge 1,612.80 WHT Deduction - Apr/May/Jun 2018
6

PLEASE advise how to copy details cell by cell

7

PLEASE ANY ONE HELP

8

@Amila_Darshana inside the for each use get row item

9

DEAR FRIEND,
I NEED ADD A1 VALUE- CONTRACT NO
B2 DUE TYPE
C3 AMOUNT
D4 REMARKS
THEN
SAVE
NEXT RECORD HOW TO APPLY
A2 PLEASE HELP

10

Is it possible to share excel file and the application link if it web means

11

Thanks for the Q respond using for each query excel data continuously can repeat but second record not paste on correct place it’s placed on another filling space please check this below and kindly advise

12

jc122
jc1221366×768 207 KB

13

jc111
jc1111366×768 206 KB

14

wccjpg
wccjpg1366×768 215 KB

15

dear friends please help

16

Hi @Amila_Darshana,

Can you please tell me the process after you load the a record ? And you have any button click action ?

Note :

if you have any button click , use delay activity to trace process.

Regards
Balamurugan.S

17

Thanks . how to repeat this procss please advise

18

Hi @Amila_Darshana,

You have to repeat the process by the loop.

Regards
Balamurugan

19

dear friend

can you logging to team viwer and check this issue

20

after process need to click add next record but next record will copy another place :confused:
please help