title: How to Import Data from excel to SPSS
body: <p>Sorry if the title is ambiguous or repetitive, but my question is kinda different.</p>
  
  <p>I know how to import data file form excel to SPSS, and by default SPSS reads variable name from excel first row.</p>
  
  <p>My question is that, in SPSS can we specify from which row to read variable names instead of only first row (From 2nd row or third).</p>
  
  <p>For eg:</p>
  
  <p>Excel file I am having have variable names in 3rd row and data from 4th  row onward. And when I am importing in SPSS, I only get an option to read variable name from first row (that is vacant in excel). I want to specify that SPSS reads variable name from 3rd row not first row.</p>
  
  <p>---------------xxx----------------</p>
  
  <p>By Directly I mean, when I import through SPSS shortcuts and not via syntax editor.</p>
  
  <p>Syntax used by me (Giving me Error):</p>
  
  <pre><code>GET DATA /TYPE=XLSX
    /FILE='C:\Users\nikhil.gupta\Desktop\Jaspercolin_Barometer_Study_Excel_07Mar15_595Comp.xlsx'
    /SHEET= name 'RID to QIName'
    /CELLRANGE= RANGE 'A6:JB601'
    /READNAMES=on
    /ASSUMEDSTRWIDTH=32767.
  DATASET NAME DataSet20 WINDOW=FRONT.
  </code></pre>
  
  <p>And Syntax when I do the import via SPSS Shortcut(Working):</p>
  
  <pre><code>GET DATA /TYPE=XLSX
    /FILE='C:\Users\nikhil.gupta\Desktop\Jaspercolin_Barometer_Study_Excel_07Mar15_595Comp.xlsx'
    /SHEET=name 'RID to QIName'
    /CELLRANGE=full
    /READNAMES=on
    /ASSUMEDSTRWIDTH=32767.
  DATASET NAME DataSet1 WINDOW=FRONT.
  </code></pre>
  
  <p>Error I am getting: </p>
  
  <pre><code>Error.  Command name: GET DATA 
  (2063) Error reading information for sheet. 
  * Sheet Name: "RID to QIName" 
  Execution of this command stops.
  </code></pre>
  
  <p>Its reading sheet name When I import via SPSS, but doesn't when I do the same via syntax editor. I guess error points to the same condition, isn't it?</p>