Read last cell in each column

[teyssir (Mhedhbi Teyssir)]

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:
Display:cc
Email:cc@gmail
Phone:cc1
Any help please!

[lakshman (Ganta lakshman)]

@teyssir,

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