Excel Reader Macro - set row number?

[swetharao]

hi,

Is there a way to select starting row number on each excel sheet on the Excel reader Macro?

Thanks

[AbhilashR]

Hi @swetharao, assuming you downloaded the excel reader macro from the Public Gallery, could you provide us a link to it? It'll help us study the config of the macro and suggest accordingly.

Generally speaking all Input tools allow you to specify the row number from which you want to the tool to read, and so by extension most macros can be configured to accommodate that feature. 

[swetharao]

https://gallery.alteryx.com/#!app/Read_All_Excel_Files/58dd51b3a18e9e18fca64172

[AbhilashR · Accepted solution]

Hi @swetharao, this macro was not structured to allow its user to define the row from which data had to be read, and I wouldn't recommend attempting to modify it either. Theoretically can you modify it, but that would be a lot of effort. Instead, I recommend using a combination of tools to read-in the files. What file extension are you looking to bring in? We might be able to create a proof of concept that you can leverage.