Copy the Comments from Excel and paste in application

#1
There is a client Application :in application after process of Account in Comment section we need to provide comments , the comments template will be in Excel , there will be around 10 accounts ,selection the comments is based on process of Accounts.

for ex comments in Excel: Client ABC received the payment of (1**) from Name(2***) Account number (3****) on the date(4***), Refund(5***) will be payed to Respective Customer for pre-payment
the below information is spied from Application while processing
1-500
2-sssss
3-123456
4-28/08/1995
5-150

the below comments should be given in application

Client ABC received the payment of 500$ from Name sssss Account number 123456 on the date 28/08/1995 , Refund150$ will be payed to Respective Customer for pre-payment.
 
#2
Hello, you can try:

MS Excel VBO -> Select
Cell Reference : [starCellOfRange]&":"&[endCelllOfRange]
MS Excel VBO -> Copy

After, in your application, use this

Utility - Environment -> Get Clipboard
 
Top