I have a scenario, where in i want to increment the cell character…
Eg:
We have a cell name in an excel sheet as “A1”,now, for the next iteration,i want to make it as “B1” and “C1” and so on, basically only alphabet should increment but not the numeric.
there are several method to do this simple method is create a char array of A to Z and loop char array and assign the value into Read cell activity value
charArry = {A,B,C,D,…,Z}
Loop
Cell value ----> char+“1”
I build a Data Table to iterate the column range. Please go through this it useful for your increment of column range.1.xlsx (7.8 KB) Main.xaml (8.5 KB)