How to write values into the input file(excel)

Help Activities
, , ,
1

input excel

image

the values which i am getting from text file. I am having all values which i required.
image

My question is how to write those values into excel by comparing the account no.

Thanks in Advance.

2

Hi @Manju_Reddy_Kanughula ,

Use build datatable and add all the required columns.
Then using regex, extract the values from text file and add it to the datatable.

3

@Manju_Reddy_Kanughula

You can use look up datatable and find the account number on the excel which gives you the cell number like A11(Say stored in Str variable)…then you know each column so if you need to fill Branch then in write cell use cell as Str.Replace("A","C") as I see the column is C for branch…accordingly use for other columns as well

Hope this helps

cheers

4

@Manju_Reddy_Kanughula ,
Is it possible to share the input excel and the 2 or 3 text file . So that we can try and update?

Regards,