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

[nilesh.mahajan]

Hello,

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

[Palaniyappan (Palaniyappan P)]

Hi

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

All about Datatable - UiPath

Hi All, Datatable - variable type is the most commonly used variable type by all UiPath users And it’s been the most often asked queries in forum especially on its manipulation So I would like to have this post as a repository for those who are looking for expressions related to Datatable Let’s go one by one keeping dt as name of datatable variable 1. Get number of rows in a datatable dt dt.Rows.Count (output - int32 type) 2. Get number of columns in a datatable dt dt.Columns.Count (output…

Cheers @nilesh.mahajan

[fernando_zuluaga]

hey

look at this example

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

regards!