So, the data in the excel file is scattered and no pattern exists to use loops. For eg. cells to be read are I6,B6, I9, B11, C13, etc.
The question here is: Is there any way i can read the data and send them to fill up a data table of, let’s say, 20 columns.
To note: I’m aware of the schema being prepared using build data table and read range activity, which sends the values to the data table.
Is there a way i can continue and discontinue the read range for each cell in the excel file?
Awaiting your reply.