I'm trying to read part of an Excel spreadsheet, specifying the range
that I want to read. The syntax generated is
GET DATA /TYPE=XLS
/FILE='C:\\Datafile.xls'
/SHEET=name 'Raw Data'
/CELLRANGE=range 'B2:T300'
/READNAMES=on
/ASSUMEDSTRWIDTH=32767.
This works correctly in SPSS 15, and works in 16.01 when the same syntax
is pasted in, but when trying to do it in 16.01 on a point-and-click
basis with the menus it fails with the message:
"The range B2:T300 is not within the sheet's range of cells."
This looks like a bug in 16.01. Can anyone else confirm this, please?
David Hitchin
=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD
Locked
