How to Read an Excel File Starting from a Specific Row

[Masond3]

Hi Team,

I have a question that might seem a bit basic, but I need to read an Excel file starting from row 12 onwards. I was under the impression
that the Input Data tool had an option to specify the starting row for data import.

However, I can't seem to find this option in my current version (2022.1.1.30961).

Could someone guide me on how to achieve this?

Thank you!

[OTrieger]

@Masond3  This option is only for xlsx format not for xls

Which format is your file?

[Masond3]

@OTrieger  OOh.., good spot i didn't check the file extensions,  these are in XLS.. i guess to get it work i need to change the extension from xls to xlsx ? 

[OTrieger]

😎

[Masond3]

This simple POC is becoming a nightmare, is there any way i can do this within alteryx ? 

If not i will go back to the team and ask for a consistent format ( only sending me three different file formats, csv, xls, xlsx ) 

[alexnajm · Accepted solution]

Consistent format is definitely better so I'd start there, but if you need to work with .xls files then you can Input Data --> Skip 1st N Rows with a Sample tool, and Take Field Names from First Row with a Dynamic Rename to get it into a useable format!