3 Replies Latest reply: Jan 26, 2015 6:21 AM by Виталий Чуприна RSS

    How dynamically identify the row where data start?

    Виталий Чуприна

      I received files with different row where data start. Sometimes this data start from 10 row, sometimes in 13.

      Header.png

      In picture you can see part of my file.

      Part of my script:

      FROM

      [\\449629-file1\Data - new\Current\MIS-IB004*.xlsx]

      (ooxml, embedded labels, header is 6 lines);

       

      So how dynamically identify header row?