Subcommands for TYPE=XLS, XLSX, and XLSM (GET DATA command)

For Excel 95 or later files, you can specify a spreadsheet within the workbook, a range of cells to read, and the contents of the first row of the spreadsheet (variable names or data). For files from earlier versions of Excel, use .

Example

GET DATA /TYPE=XLS
   /FILE='/data/sales.xls'
   /SHEET=name 'June Sales'
   /CELLRANGE=range 'A1:C3'
   /READNAMES=on.