I'm very new to ADF using store procedure. I'm building pipeline to import excel file but some files has column names starting from A4 or A9. Is there a way to import all files with dynamic range ? I really appreciate if anybody could help or refer any source to read !

CodePudding user response：

You can parameterize the Range property in the Excel dataset connector and pass the dynamic value from the pipeline as required.