Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,426 questions
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Morning,
I have this excel file. I have to skip the first couple of rows and then start reading the excel file until the end. Right now, in my ADF dataset, I have set the Range for the source excel file as A4:Z100
This is not a nice solution, because I could encounter an excel file with more than 100 rows to read. Is there any expression I could use to read from A4 until the end of column Z?
Thanks in advance!
Hey,
Just map the initial part .
eg : A4