Share via

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.
11,426 questions
0 comments
Accepted answer
  1. Nandan Hegde 34,866 Reputation points MVP
    2021-07-12T07:44:36.85+00:00

    Hey,
    Just map the initial part .
    eg : A4

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.