Stop loop if the excel cell is empty

Help
1

Hi,
My scenario is that I have to read data from excel sheet dynamically, which means each sheet has varying number of data. I can assign the starting cell and the robot should read the excel rows until it finds an empty cell. I cannot use read range as the range is not fixed. And Datatable cannot be used for the same reason.
I tried using Dowhile loopusing 'cellValue<>“” ', but it throws an error saying " Int32Converter cannot convert from (null)."
Please help me.

3

Hi @sawaseem

Have you tried:
String.IsNullOrEmpty(cellValue)

Hope this helps.
Thanks and regards.
Despi

1 Like