Removing specific rows in an Excel file using Azure Data Factory

Question

I have a set of excel files inside ADLS. The format looks similar to the one below:

The first four rows of a document are always the header information, and the final three rows are two empty rows and a marker marking the conclusion of the page. There are an undetermined amount of rows for the employee data. Using ADF, I want to remove the first four rows and the final three rows.

Can any help me with what should be expressions in the Derived column / Select?

Answer 1

Under the 'Source' tab, choose the number of lines you want to skip.