I am currently reading data out of an excel by the read range activity. The excel consists of a “header” with some information, followed by a table which needs to be imported into a datatable.
Unfortunately the “table” does not always start at the same row in the excel eg A13 or A14.
Currently I am reading the whole sheet in the datatable, but then I don’t know how to filter the datatable dynamically such that all rows above the index that I could already define are deleted.
Can you help me?
Thanks a lot!