I need to copy range of excel cell in to application
How to copy
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
I will attach my sample application and excel sheet pls help
Thanks for reply
|#||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|
PLEASE advise how to copy details cell by cell
PLEASE ANY ONE HELP
@Amila_Darshana inside the for each use get row item
I NEED ADD A1 VALUE- CONTRACT NO
B2 DUE TYPE
NEXT RECORD HOW TO APPLY
A2 PLEASE HELP
Is it possible to share excel file and the application link if it web means
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
dear friends please help
Can you please tell me the process after you load the a record ? And you have any button click action ?
if you have any button click , use delay activity to trace process.
Thanks . how to repeat this procss please advise
You have to repeat the process by the loop.
can you logging to team viwer and check this issue
after process need to click add next record but next record will copy another place