I have a excel file which is semi-structured. There is data in a table, but there are dividers in certain rows that should needs to be ignored. The processing of the data should start with the column headers(Col1 , col2 ....) and only process the rows with actual data. Could anyone suggest the way to achieve this using copy activity in adf .
My source is xls file and target is ADLA (Parquet file)