Here is an expanded version of the script given in the first link above, showing how you can access the data in the records it produced:
do AppleScript {{
tell application "Microsoft Excel"
open "Macintosh HD:Users:doug:Desktop:Data.xls"
get value of the used Range of worksheet 1
end tell
}}
put the result into fullData -- a list of lists
put "Raw Data (a list of lists):"
put fullData
-- convert to a list of records, using the first row titles as the keys
put item 1 of fullData into header -- get the column titles
delete item 1 of fullData
repeat with each row of fullData
set record to (:)
repeat with n=1 to the number of items in header
set property (item n of header) of record to item n of row
end repeat
insert record after recordList
end repeat
put return & "Records (a list of property lists):"
put recordList
put return & "Names and Descriptions:"
repeat with each record in recordList
set (name, description) to record's (request_name,request_desc)
put
put "Name: " & name
put "Description: " & description
end repeat
Using the data file you posted (be sure to set the path correctly in the AppleScript for your own file) and changing “usedRange” to “used range” I got the following output:
Raw Data (a list of lists):
((request_name,request_desc),(Test1,Checking 1),(Test2,Checking 2),(Test3,Checking 3),(Test4,Checking 4),(Test5,Checking 5),(Test6,Checking 6))
Records (a list of property lists):
((request_desc:“Checking 1”, request_name:“Test1”),(request_desc:“Checking 2”, request_name:“Test2”),(request_desc:“Checking 3”, request_name:“Test3”),(request_desc:“Checking 4”, request_name:“Test4”),(request_desc:“Checking 5”, request_name:“Test5”),(request_desc:“Checking 6”, request_name:“Test6”))
Names and Descriptions:
Name: Test1
Description: Checking 1
Name: Test2
Description: Checking 2
Name: Test3
Description: Checking 3
Name: Test4
Description: Checking 4
Name: Test5
Description: Checking 5
Name: Test6
Description: Checking 6