Stop loop if the excel cell is empty

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.

Hi @sawaseem

Have you tried:

Hope this helps.
Thanks and regards.

1 Like