460689_en-US

liliconcom

How do I skip a particular worksheet while importing an Excel file?

Hello JMP Forum,
I'm using JMP 16. I'm looking for a way to import an Excel spreadsheet with several worksheets, but want to skip importing a particular worksheet named 'Summary'. Is there a way to write a script for this?

 

Please note: I create a report using such an Excel file periodically. And the number and names of the worksheets (other than 'Summary') vary every time.

 

Thanks

 

ScriptingWindowsRe: How do I skip a particular worksheet while importing an Excel file?

Hi,

A simple "dirty" way to handle this would be to open all worksheets, record the names of all open tables [ Get Data Table List()], and discard the table with name == "Summary", [Close (dt, NoSave)].

Let us know if you need an actual example of a script to assemble these commands?

Best,

TS

 

Re: How do I skip a particular worksheet while importing an Excel file?

Thanks Thierry!

 

I'm not much familiar with using List(), so an example script would be helpful

 

My plan is to concatenate the rest of the worksheets (excluding 'Summary').

 

Regards

Re: How do I skip a particular worksheet while importing an Excel file?

Here is a short script to discard any Data Table with a name containing "Summary:

 

Names Default to Here (1);

tb_list = Get Data Table List ();

for (i = 1, i <=  N Items (tb_list), i++,

 tb_name = tb_list [i] << Get Name;
 
 if (contains(tb_name, "Summary"), Close (tb_list[i],NoSave))


);

You can then rerun the Get Data Table List () command and concatenate the remaining tables into a new data table.

Best,

TS