I have a number of Excel files which have different schemas and different sheet names. I'd like to import them all at once from one directory and let the user select the sheets they'd like to import.
Additionally, the headers can be on different rows so they need to be pushed down into the data.
I have tried using the Wildcard XLSX Crew Macro, but unfortunately it outputs my data into two different streams and doesn't give me an option to push down the header into the first row (or at least it doesn't work for me, no matter how I configure the macro). This works as long as there's only one file in the non-N output, but it would break my workflow if there were two.
Instead of having two output anchors, is there a solution which unions all files immediately? Even if they have a different number of columns, different file names, different sheet names and the header is on a random row?
