We’re asking you to select a content label when starting a new topic in the Discussions area. Read more to find out why.
Choose Language Hide Translation Bar
Level IV

Using the right options for reading Excel files


I have an annoying problem when trying to read from an Excel file. I use this technique:



The top of the Excel file is in the snip. The resulting jmp files is also included.

My problem is to find the correct way of telling jmp how to read all rows form the Excel file into a data table. As you can see, for the two first colums, jmp uses data from the Ecel cells to name the colums. Whereas the later colums have the default names. (The rows of the Excel sheet are also empty.)

It looks as if jmp imports the data as if I had chosen the 'paste with colum names' option in the paste menu. In this case that is not what I want. Mere geneally I would like to know excatly how to control this.

Any help appreciated.