Forum Discussion
Get external data from web not showing
Hello, I am trying to link external information from a url to my Excel spreadsheet, but for whatever reason the "Get data from Web" option is not showing up on my menu. Does anyone have any idea ...
This works
https://www.youtube.com/watch?v=QH2Dx5LgkJg&ab_channel=DSMStrength
https://www.youtube.com/watch?v=QH2Dx5LgkJg&ab_channel=DSMStrength
Hey JeanPaulGedeon did you read the other posts? We are looking for a solution to automatically pull data from a Google sheet to excel on Mac OSx
- Google sheets are not HTML tables, so web query will not work. Copy and paste from Google sheets does work. There is a web browser called OmniWeb that is scriptable. In theory, you could write an Applescript that copies a range from OmniWeb and pastes it into an Excel worksheet. I haven't test this, however.
- I just tested and the following code works. Assume I already selected a range of cells in Omniweb and want to copy and paste that range and put it into Excel. This is just the core code. You'd need to decide just how much automation you want.
This is the code:
tell application "OmniWeb" to activate
tell application "System Events"
tell process "Omniweb"
keystroke "c" using command down
keystroke tab
end tell
end tell
delay 0.3
tell application "Microsoft Excel" to activate
tell application "System Events"
tell process "Microsoft Excel"
keystroke "v" using command down
keystroke tab
end tell
end tell
