The 'Use Excel File' activity does not have a 'skip header' option

Help Studio
, ,
1

In the ‘Use Excel File’ activity I tried to look for a ‘skip header’ option but can’t find it. I know I can create a ‘RowIndex’ variable and initialize to 0, then increment it, and if RowIndex = 0 then ignore the row in my input Excel. However, this would seem a bit clumsy, and I am wondering if there’s a cleaner way to achieve this via another activity. Any suggestions would be appreciated.

image
image1446×470 28.8 KB

2

Ah, I have just noticed the ‘For Each Excel Row’ activity has the ‘Has Headers’ option. I’ll try this option to see if it achieves what I want to achieve.

3

Yep, this ‘Has Headers’ option in the ‘For Each Excel Row’ activity achieves exactly what I wanted.

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.