How can we Exclude the unnecessary rows from Excel File while doing Data Load using Copy activity in ADF

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)

Any help appreciated. Thanks in advance. enter image description here



Read more here: https://stackoverflow.com/questions/66265685/how-can-we-exclude-the-unnecessary-rows-from-excel-file-while-doing-data-load-us

Content Attribution

This content was originally published by Parul at Recent Questions - Stack Overflow, and is syndicated here via their RSS feed. You can read the original post over there.

%d bloggers like this: