5735_en-US

liliconcom

Always Enforce Excel Row 1 as labels?<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />

In my script the user opens an excel data table. I want JMP to Always enforce Excel Row 1 as labels but when the user opens the file, it doesn't give that option. It opens this data table without recognizing the column headings. I think it doesn' recognize them because the data starts with letters, not numbers.

Can anyone help me?         I'm using: Open( Pick File( "  "));

Thank you!

Re: Always Enforce Excel Row 1 as labels?

Thank you very much!

Re: Always Enforce Excel Row 1 as labels?

You can set the Excel preferences like this:

// Set row 1 to be column labels and prompt for which non-blank Excel worksheet should be imported

Preferences(Excel Has Labels(1), Excel Selection(1));

dt = open();