Loop excel


#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


#13


#14


#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