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!
- 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.
- Assign int index = DataTablename.Rows.count+1
- write cell:
Range: If it is ‘A’ Column then use “A”+index.toString