Handling two different Excel header formats
Hi everyone, I'm working on a JSL script in JMP to automate the import of BOM (Bill of Materials) Excel files. These files come from different sources and unfortunately don't follow a consistent format. I’m dealing with two specific formats: - Format 1: headers are on row 5, data starts on row 6 - Format 2: headers are on row 6, data starts on row 7 Right now, my script is hardcoded to use F...