Data from external source

Question

Level 1

9 points

Data from external source

Is it possible in Numbers to link a spreadsheet to an external data source? Right now, I am copying and pasting data from a Google Docs spreadsheet onto a table in Numbers.

MacBook Pro, Mac OS X (10.5.6)

Posted on Feb 15, 2011 11:39 AM

Reply

Answer 1

Barry

Level 9

60,023 points

Feb 15, 2011 11:52 AM in response to oravecz

Only by using an AppleScript to fetch the data from the external source.

Yvan Koenig has written several scripts to do this. I don't recall if any of them referenced a Google Docs spreadsheet, though.

A search of this forum over the past year may turn up some leads.

Or Yvan may be along later with a response.

Regards,
Barry

Reply

Answer 2

KOENIG Yvan

Level 8

41,819 points

Feb 15, 2011 11:57 AM in response to Barry

I never entered Google Docs because I want to keep my datas for myself.

If I have some time available, I will look at this service.

Yvan KOENIG (VALLAURIS, France) mardi 15 février 2011 20:57:21

Reply

Answer 3

KOENIG Yvan

Level 8

41,819 points

Feb 15, 2011 12:20 PM in response to KOENIG Yvan

I had a quick look and will not have more.

(1) I refuse to give my mail.address to Google which prove to be far from respectful of confidentiality.

(2) Seen from France, their spreadsheet is absolutely ridiculous :

it use English functions names
it use the decimal period
it use the semicolon as parameters delimiters

So, I will not be helpful in this area.

Yvan KOENIG (VALLAURIS, France) mardi 15 février 2011 21:20:16

Reply

Answer 4

oravecz Author

Level 1

9 points

Feb 15, 2011 12:32 PM in response to Barry

I'm a programmer, so I can check into the GoogleDocs integration. I first have to learn what is possible with Numbers in AppleScript.

Reply

Answer 5

KOENIG Yvan

Level 8

41,819 points

Feb 15, 2011 1:23 PM in response to oravecz

oravecz wrote:
I'm a programmer, so I can check into the GoogleDocs integration. I first have to learn what is possible with Numbers in AppleScript.

You can go to my idisk

Look in the folder :

For_iWork:iWork '09:for_Numbers09:

which contain a lot of scripts.

For the asked problem, it may be helpful to look at :
For_iWork:iWork '09:for Numbers09:insert_Currenciesrates.zip
and
For_iWork:iWork '09:for Numbers09:insertquotes.zip

Yvan KOENIG (VALLAURIS, France) mardi 15 février 2011 22:23:33

Reply

Answer 6

oravecz Author

Level 1

9 points

Feb 15, 2011 4:21 PM in response to KOENIG Yvan

Generous offer Yvan, thanks. What's the link to your iDisk?

Reply

Answer 7

KOENIG Yvan

Level 8

41,819 points

Feb 16, 2011 1:48 AM in response to oravecz

Oops, I forgot to paste it 😟

My iDisk is available as :

<http://public.me.com/koenigyvan>

Yvan KOENIG (VALLAURIS, France) mercredi 16 février 2011 10:48:00

Reply

Answer 8

Feb 13, 2016 8:03 AM in response to KOENIG Yvan

Hi Yvan,

Do you still have these apple scripts available to pull data from external sources into Numbers?

Thanks,

Rod

Reply

Answer 9

Barry

Level 9

60,023 points

Feb 14, 2016 12:05 AM in response to RodChristiansen

Hi Rod,

Yvan has not posted in this community for several years now. Many of his scripts are still available in his Box account, and can be reached at the link provided.

Regards,

Barry

Reply

Answer 10

Feb 15, 2016 4:11 PM in response to Barry

Thanks Barry, very kind of you to share this

Reply