Scripting : Multiple tables from Excel

GroupSquareWolf — Fri, 09 Jun 2023 16:01:16 GMT

Writing a script to open Excel files that contain multiple sheets then do independent analysis with each individual sheet. The names and number of sheets from different Excel files can be different, so would like to write a generic code that can work on different files.

Used Open command to open the file

dt = Open ("file path");

This particular example file has three sheets, so show (dt); gives this result in log:

dt = {DataTable("Sheet 1"), DataTable("Sheet 2"), DataTable("Sheet 3")}

;

Need to assign each datatable in dt to different variables, what is the correct syntax to do that?

I tried:

dt1 = dt (1);

It did not work. dt1 essentially equals dt. show (dt1); gives this result in log:

dt1 = {DataTable("Sheet 1"), DataTable("Sheet 2"), DataTable("Sheet 3")};

Thanks!

Re: Scripting : Multiple tables from Excel

jthi — Fri, 28 Oct 2022 14:45:42 GMT

dt seems to be a list, so reference items by using indices

dt[1]

if you have JMP16 For Each might also be helpful

topic Re: Scripting : Multiple tables from Excel in Discussions

Scripting : Multiple tables from Excel

Re: Scripting : Multiple tables from Excel