Removing the first line of every Sheet in Excel file while using Dynamic Input

jaycaplan

I want to import all of the Sheets in an Excel file using the Dynamic Input tool with Sheet Names.   The first line only has a merged cell in E5 and the column headers are consistent for all Sheets on Line 2.  Having an issue removing the first line from each Sheet before input.

andyuttley

Hi @jaycaplan 

That's odd, it's working fine on mine. What configuration are you using? Feel free to attached a packaged version (with dummy data)

I just created an xlsx with 3 tabs, all of which had headers on line 2 (and merged cells in line 1).

There's 3 rows of data in each tab (rows 3-5) with headers in row 2, creating a table of 9 rows across the different tabs:

So this is behaving as I'd expect. Like I say, feel free to send an packaged version over, I'm happy to take a look at your specific example. 

Andy