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

 

Data AccessWindowsRe: 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?

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