The link above teaches project organization and within it there is a concept of how to use select(), which can be found in more detail in the below link.
What I actually want to do is to find the first empty cell in an Excel sheet without using the method of getting all the data to a datatable and doing a loop. In the tutorial at the first line of this writing, the tutor used select(“status is not null”), which will be my ultimate goal to test for my goal.
But when I read data from a worksheet and use “select()” function, it returns an object which cannot be printed on the output panel. I tried to receive it with a variable of array[datarow] and print it but it does not work. I tried item(0) and item(0).tostring but none of them worked.
Do you have any idea of how to convert an object type derieved from the select() function into other types such as string or datarow?
Or if you have anything to say regarding this approach, it will be really appreciated, thank you!