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

    How dynamically identify header size in xlsx files?

    Vitalii Chupryna

      I received files with different header size. Sometimes data start from 10 row, sometimes from 13.


      In picture you can see part of my file.

      Part of my script:


      [\\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?