How to make cell value dynamic for the write cell activity

Hi,

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.

image

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.

Thanks,
Shenki

Hi @ShenkiSinghai,

you may follow on this thread.

Good luck.

1 Like