Hi, I need some advice. I am learning how applescript and need advice on the best way to copy data from a web site and import this data into a spreadsheet document.
I don’t want someone to send me a script on how to do this. Instead, I want someone to point me in the right direction. For instance, is the best process to; copy the web data onto clipboard and then paste into the spreadsheet; or link each part of the web data to a particular variable, which will be connected to each spreadsheet cell. the website I want to extract data from is located at
http://www.travelex.co.uk/uk/personal/rateslist.aspx
the specific data I want to import is ‘currency’ and ‘We sell’ column.
Ideally, I would like to write an applescript to automatically import this particular web data to a particular spreadsheet and then manipulate that data among other spreadsheets.
I just want to know, what is the best process to follow.
Any help would be greatly appreciated.
