I'm trying to import data from excel through syntax; however, whenever I do the error message below pops up. I'm on a Mac, running this on version 26 of SPSS. This is my first time trying to import data through syntax so I'm not entirely sure how it works.

This is what I'm typing in on syntax:

GET DATA

/TYPE=XLS

/FILE='C:\Users\file name'

/SHEET=name 'file name'

/CELLRANGE=FULL

/READNAMES=ON

/DATATYPEMIN PERCENTAGE=95.0

/HIDDEN IGNORE=YES

EXECUTE.

This is the error message that pops up:

>Error. Command name: GET DATA

>(2202) Unexpected syntax found:

>..."HIDDEN"

>Execution of this command stops.

Never mind, I fixed it.

Support Member

Yes, the subcommand /HIDDEN IGNORE=YES is only for Excel files 2007 and above (*.xlsx). If you use older XLS file format just remove the subcommand and it will work.

See also

https://www.ibm.com/support/knowledgecenter/en/SSLVMB_26.0.0/statistics_mainhelp_ddita/exceldac/idh_idd_xlscellrange.html

"Ignore hidden rows and columns

Hidden rows and columns in the Excel file are not included. This option is available only for Excel 2007 and later files (XLSX, XLSM)."