Hi folks,
I am using JMP scripts to import the data of 30 Excel files. When I run it, there will be 30 data tables opened during the "Open" action. So I have to manually close each of these 30 data tables, which is very tedious. Is there a way that I can read / import the data from Excel without opening the data table so that I do not need to close the data table one by one? Your comments / suggestions are much appreciated.
For example:
Names Default To Here(1);
dt01 = Open("SAMPLE_DATA/Big Class01.jmp);
dt02 = Open("SAMPLE_DATA/Big Class02.jmp);
dt03 = Open("SAMPLE_DATA/Big Class03.jmp);
dt04 = Open("SAMPLE_DATA/Big Class04.jmp);
dt05 = Open("SAMPLE_DATA/Big Class05.jmp);
dt06 = Open("SAMPLE_DATA/Big Class06.jmp);
....