Check if specific cell is empty

Help
1

Hi, I would like to check if a specific cell in excel is empty. For example, row 1/column A.
And then I want to write in that cell the value from another specific cell, for example row 5/column A.

Thanks !

2

Hi @Jad_Bennis,

Use Read Range activity to read the data from excel file and will give you output as DataTable and say ‘DT’. And then check below condition.

   IF DT.Rows.Count > 0
   Then it has data 
   Else no data
   you add another specific cell data to columnA

Refer this link- Check for empty excel file - #3 by Veselin_Ganchev

Hope this will helps,if it works mark as solution.

Regards,
Neelima.

3

You can use excel read cell or workbook read cell image

Read value, check with its length like

cellValue.ToString.length

If length > 0 then we have data else its empty