Ask Your Question

Is it possible to access external google api from a macro? [closed]

asked 2014-08-15 01:59:49 +0100

sup gravatar image

I have a spreadsheet on google docs (I use it with other people to share information and cannot make them to use anything else). I would need to pull out some data out of it and do some work on them in a macro in Calc. I have written a macro before, so I sort of know how to do the processing once I get the data, but I don't have much idea how to access the API. I want to use this - bindings seem to be in net and java only. Does this mean I have to write an external program in those languages that I can then call from my macro, or can I use the API directly?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-02 00:02:22.492017

1 Answer

Sort by » oldest newest most voted

answered 2014-08-15 09:32:35 +0100

karolus gravatar image

updated 2014-08-15 09:33:29 +0100


So far i see there are also api-Libs for python.
(search there for Python)
install these via
pip install whatever_its_name --user

drop your ugly basic and continue with python.

edit flag offensive delete link more


Ah, wonderful, I had no idea I could use python to write macros, that is great.

sup gravatar imagesup ( 2014-08-15 11:44:54 +0100 )edit

Question Tools

1 follower


Asked: 2014-08-15 01:59:49 +0100

Seen: 281 times

Last updated: Aug 15 '14