I have a local excel which I need to read but the condition is headers starts from 6th row and its data from 7th row data above row 6 needs to be skipped . Also the complete data table which I need to extract is till column O .
to summarize . Extract table data form column A to O. starting from Row 6 till the no of row data is available.
I have use the below range but this activity gives error:- "object refence not set to an instance of an object "
You can delete the first 5 row and then save the file and read it again
you need to give a read range => A6:N23 => if you know rows
@mukesh.singh -I cannot delete the Above 5 rows. Also I am not user on ending rows .
is there a way to delete the top 5 rows after extracting from Data-table during run time.
In Read Range try giving only "A6" and try running the flow.
Let me know if you have any queries.
Regards