Subscribe Bookmark RSS Feed

Using the right options for reading Excel files

poulravn

Community Trekker

Joined:

Jan 25, 2012

Hi,

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

xlsFID="myfile.xlsx";

Open(xlsFID);

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.

Thanks

Poul