This content has been marked as final. Show 3 replies
I received files with different row where data start. Sometimes this data start from 10 row, sometimes in 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);
So how dynamically identify header row?