BookmarkSubscribeRSS Feed

Importing XLS Files

I just installed JMP 8 and can no longer import individual Excel Worksheets. I am using script and setting Excel Selection (1) and Excel Has Labels (1), but all sheets import into tables whether I select specific worksheets or not. Also, no check boxes appear on the dialog box.

Super User


Jun 23, 2011

Re: Importing XLS Files

Windows, Linux, Mac?
8,0, 8.0.1, 8.0.2?

In Windows using 8.0.1 when I open (using Open(filename.xls)) an Excel file containing multiple sheets I do get a dialog asking me to choose. No more checkboxes though, I just select the names I want to import.

The problem I do seem to have though is that I only am getting a reference to the last one. So I see all the sheets but the script only knows about the last one.