Hi everyone! I’m very new to Meltano, and I’m just learning how to use it at the moment. I’m using tap-spreadsheets-anywhere to load some Excel files, but one of the files has the headers on the 4th row. Is there any way of passing something to config to skip the first three rows?

Hi, most of the possible options are found in the tap itself, so you will have to read through the documentation of the tap here: https://github.com/ets/tap-spreadsheets-anywhere From a cursory reading, I didn’t find anything though. The spreadsheets-anywhere tap has an impressive number of variants though, so perhaps if you look through the documentation for those you might find something. Variants can be quite different from each other, it is at times almost unfair to call it a variant. If you happen to read from an SFTP server, I have a primitive variant of tap-sftp that reads excel files and has an option to skip lines: https://github.com/radbrt/tap-sftpexcel. It is a pretty hacky version that I did for my own needs, so it isn’t well documented or anything. Edit: I have a particular excel-sftp tap that can easily be adjusted to skip headers if you need, but does not currently do that.

Thanks Henning, I’ll take a look at that!