Extracting data from a spreadsheet
Extracting data from a spreadsheet
- Subject: Extracting data from a spreadsheet
- From: Paul Garfield <email@hidden>
- Date: Sun, 28 Jul 2002 21:55:24 +0100
I have a large quantity of information is a spreadsheet, but cannot get
to read the values in the cells.
Eventually I'll loop round them all, but cannot get a single cell just
now??
tell the window of theObject
set checkOne to "1"
repeat
-- Kick Appleworks
tell application "AppleWorks 6"
activate "contacts.xls"
-- set a fixed cell for test only
set cellNAME to "A2"
-- THIS IS THE BIT WHICH DOES NOT RESPOND
set x to contents of cell cellNAME
end tell
-- display what was found for show only while testing
set contents of text field "FoundInCell" to x
end repeat
end tell
Thanks,
Paul Garfield
_______________________________________________
applescript-users mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/applescript-users
Do not post admin requests to the list. They will be ignored.