and, as "A:A" appears to be a valid descriptor of a range
set theList to value of range "A:A"
is supposed to be OK.
I'm also curious to learn if the tip described in an other message to get only non empty values is OK :
here it is again :
# these two instructions aren't speaking to Excel so there is no need to put them in the tell block
set testFile to choose file "PLease select the Excel Workbook!"
set fileName to testFile as string
tell application "Microsoft Excel"
set newWorkbook to open workbook workbook file name fileName
tell sheet 1 of newWorkbook
# the cell B1 is supposed to be empty
set theRange to (column difference range ("A:A") comparison range "B1")
set theResult to (value of theRange)
end tell
end tell
It's a pity when somebody want to test exotic syntax in an app which he doesn't own.
I will try to get the demo version using a mail address which I didn't use once to do that.
KOENIG Yvan (VALLAURIS, France) mercredi 21 août 2013 12:09:40