2 Replies Latest reply: Jun 10, 2016 6:19 AM by Timur Shaymardanov RSS

    How dynamically identify header size in xlsx files?

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

      I received files with different header size. Sometimes data start from 10 row, sometimes from 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);


      Header size in wizard now 6.

       

      So how dynamically identify header size? What should I change in my script?