Reading Excel Files

Read variable names. You can read variable names from the first row of the file or the first row of the defined range. Values that don't conform to variable naming rules are converted to valid variable names, and the original names are used as variable labels. For information on variable naming rules, see Variable Names.

Worksheet. Excel files can contain multiple worksheets. By default, the Data Editor reads the first worksheet. To read a different worksheet, select the worksheet from the drop-down list.

Range. You can also read a range of cells. Use the same method for specifying cell ranges as you would in Excel.