How to get a cell number from the value in the excel sheet

[badita (Mihai Badita)]

@vvaidya

Take Alphabets in Array - A B C D

How to Write to Excel CELL index v.2

In this case create an array of string variable Columns = ("A","B","C",..., "AZ"). When using Write Cell you will set the cell to Columns(columnIndex)+rowIndex.ToString `Columns(0)` will return "A" `Columns(1)` will return "B" and so on Everything is parametrized now.