nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

678056_en-US

liliconcom

Multiple excel file import, extracting data from specific sheet

Dear expert JMP users,

I have a lot of data files generated by an instrument that I've used - each one is consistent in format but they are all in individual sub-folders and each folder contains other files that are not of interest.

Is there a way of writing a script (I'm completely new to JMP scripting) to look in all sub-folders of a given directory, search for excel files ending in ' infos.xlsx', and extracting the data from the 13th row and columns 3 to 25 of a worksheet called "Datas", and appending the full filename of each file to each data row??

Please help, I've got 600 files to process!!

Best regards

Ian

Automation and Scripting

Data Exploration and Visualization

Quality and Process Engineering

Comments

There are no comments yet