I understand that, but if you want help in editing the data you will need to be more specific about:
Where can the changes to be found and what is the "particular path"?
I will have a "Good_File.txt" (my Text file which has already some data), which I will browse from my code.
Also I will have an "Input.xls" file (which has LineNo., Col No.,Value (3 columns) that are to be replaced in the text file) which I will browse from my code.
Now my requirement is:
When I browse these 2 files (text, Excel) and click on "Go" button, code should do the follwing things:
1. From the excel, it should take the value from the "value" column and add it in the text file at the particular position (the position is mentioned in "Line No" and "Col No." columns in the excel)
2. Once after replacing the existing content in the text file with the content mentioned in the Excel, the text file should be saved in a path (this path may be hard coded in the code)
3. Like wise the above 2 steps are to be repeated based on number of rows in the excel and that many text files are to be created and placed in the path.
Sample Excel:
Line No. Col No. Value
2 36 20121026
3 53 HimajaMadineni
Sample Text File:
HDRAutomatic Data Processing, Inc. 201308012013072620130731
POL123456789WC WC12345-01 2012102620131026The Office Cast 11111 Any Avenue AnyTown NJ07940
9737123000corinne.summers@adp.com N2A
CLS123456789WC WC12345-01 2012102620131026 Knope, Leslie 000000010 MD958601ABARBER SHOP N0 00000000012320000000000001590020130707201307202013080120130726018 777000012426 00049
CLS123456789WC WC12345-01 2012102620131026 Lemon, Elizabeth 000000011 MD958601ABARBER SHOP N0 00000000013950000000000000000020130707201307202013080120130726018 777000012426 00049
CLS123456789WC WC12345-01 2012102620131026 Maroney, Jenna 000000014 MD958601ABARBER SHOP N0 00000000010370000000000002360020130707201307202013080120130726018 777000012426 00049
CLS123456789WC WC12345-01 2012102620131026 Dwyer, Andrew 000000019 MD958601ABARBER SHOP N0 00000000011485000000000001400020130707201307202013080120130726018 777000012426 00049