Yes, indeed. The Write Value activity is different and is commonly used to write formulas into excel, however the Write Range activity is basically used to do a bulk insert into the excel using a datatable that was previously populated. Yes, it’s possible, you could follow the logic from the links below, but I have created an example for you.
And you could also use this website to convert your code from C# to VB .NET
converter.telerik.com
I have created an example that reads the excel file and insert its content to an excel file. Kindly check it and if it’s looks like to what you are expecting. I created two examples from the scenario you have provided.
Main.zip (4.2 KB)
ashokkarale
anjani_priya
Dheerendra_vishwakarma
Parvathy
Aakash_Singh_Rawat
Luis_Fernando
bjorn2390
neco
pere
Shiva_Nikhil