Lets have simple loop:
value=srcSheet.getCellByPosition(0,srcRowNo).String DO While value<>"" srcRowNo=srcRowNo+1 value=srcSheet.getCellByPosition(0,srcRowNo).String Loop
is it possible assign variable in DO WHILE condition check so i dont have to read the value for the initial time?
Something like this does not work:
DO While value=srcSheet.getCellByPosition(0,srcRowNo).String<>"" srcRowNo=srcRowNo+1 Loop