How to Get Excel file cell address for current item which is fetch in For Each


I am looking to get the excel file cell address for which the Item has been displayed.
My purpose to get the cell address is, if the value from that cell address is null then I need to fill that null cell address with another cell address value.
Ex. item.value is from A2 which is null then I need to replace that with K2.value.
And for the same I need the cell address in For each

1 Like


Refer this thread for details on how to get the cell address

Cheers @nilesh.mahajan


look at this example

String.IsNullOrEmpty(CurrentRow(0).ToString) or String.IsNullOrWhiteSpace(CurrentRow(0).ToString)


This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.