How to write captured data in a specicc column in excel

Help
1

Hi,

I am new to RPA.

My scenario is:

  1. I have master excel
    image

  2. I am reading License number in master excel & login to our internal web application & search by Insurance number.

  3. I am capturing issue date, expire date & Status in application using get full text.

  4. I am storing captured data in variables

Here my problem is I want to update captured data ( Issue date, expire date & Status) in master excel, based on licence number.

Ex: If i captured data related to 12345 License number then i want to update captured data in Excel where license number is 12345 row

Pls any one help me, Thanks in advance

2

Are you using Read Range activities to read this as a datatable?