storing data tables from open() into a list

anders_bankefor

Hi,

 

I would like to use the open() keyword to open multiple worksheets and storing these datatables into a list.

 

Tables = {};
//normaly I would like to use a for loop here, however the number of worksheets will vary.
Tables = Open ("pathway",
invisible, info about the data..);
 
//do something with the tables
for (i = 1, i <= NITEMS(Tables), i++,
close(Tables[i], nosave);
);

 

Additional question:

Also is it possible to use a username/password protected searchengine/library to search and download information to jmp?

 

Kind regards

Anders

ms

I think a loop will be required here to build the list. The Files in Directory() function is useful if the number of files vary, and they all are found in the same directory.

An example:

// Define path and file type
mypath = "path";
ftype = ".jmp";

// Make list of files, remove all non-matching files
flist = Files In Directory(mypath);
For(i = N Items(flist), i > 0, i--,
    If(!Ends With(flist[i], ftype),
        Remove From(flist, i)
    )
);

// Open and create list of tables
Tables = Repeat(
    i = 0;
    {i++ ; Open(mypath || flist[i])};,
    N Items(flist)
);

//do something with the tables
For(i = 1, i <= N Items(Tables), i++,
    Close(Tables[i], No Save)
);