Read last cell in each column

Hello ,
I want to read each last non emtpy cell in each column and assign each value to a variable
I want to have the folowing values:
Any help please!


  1. First take read range activity to read the excel data and it give you output as DataTable. And also select ‘Add Headers’ in property section.
  2. Assign int index = DataTablename.Rows.count+1
  3. write cell:
    Range: If it is ‘A’ Column then use “A”+index.toString
    Value: yourValue