Read Excel from starting cell until the end with range expression

Francisco Dominguez 386 Reputation points
2021-07-12T07:20:59.823+00:00

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!

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,705 questions
0 comments No comments
{count} votes

0 additional answers

Sort by: Most helpful