Changing name column to other names in excel

Help Activities
, , , ,
7

Hi @burak

I hope the list that you have is in the same order as you need already in an excel sheet I believe

Follow these steps

Do all of this in excel scope

  1. Read the sheet which contains all the new names using read range into a datatable(dt)
  2. Now loop through the datatable using for each row(If you open properties you will find an index property assign an integer variable to it)
  3. Inside that add a write cell to the main excel sheet where you have all the columns to be updated. in the ‘What to write’ field provide currentrow(0).tostring
    in ‘Where to write’ field provide “A” + (index+1).ToString

cheers