Convert Excel column letter to index

[ronanpeter]

Excel activities do not support R1C1 Reference Style

A small work-around that I thought of for this is the use of ASCII codes: ex: you have the code 65 for capital A and you can use CHR(65+variable)+rownumber.ToString to enter any range you need. Hope this helps

Some code here will help.