I have a column in excel Type and Zone. I am validating for all the rows where Type is Platinum and only against that row in column Zone I want to write South in the respected cell.
Challenge is column with “Zone” name can be anywhere in the excel from A to XFD. So I want to make it dynamic.
Right now I have written the code as below which will solve my issue till column Z. But it is now working if I put Zone in column from AA to XFD.
Convert.ToChar(DT.Columns.IndexOf("Zone")+65)+ (DT.Rows.IndexOf(row) + 2).ToString
Please suggest how can we make dynamic for full excel.