How to read multiple table from one excel

Read the whole excel sheet then and try to manipulate the data.

You could forexample find out the Cell for “Table 1”, then assume that the Cell below it is the start of your table, then try to found “Table 2” and do the same.

You can even let the table number be a variable that you increment in a while loop so that as long as there are “Table {x}” you continue, if you don’t find Table 11, you exit the loop