MATLAB Answers

Matlab and Google Sheet Compatibility

27 views (last 30 days)
Giuseppe Naselli
Giuseppe Naselli on 13 Mar 2015
Answered: Jim Hokanson on 13 Mar 2015
Hi, Matlab is one of the most used languages in the world such is Google in terms of on-line products. So i guess you have now all understood what question I am going to ask
Despite I have been using Matlab for many years now, my experience with Matlab online is limited to sending an email through my Google email account.
So I wish to find out what are the basics principles and commands to create, write/update Google sheets from a computer with Matlab and internet connection and a Google account obviously. *If any specific commands exit *
However, my "googling" + the Mathworks website have not given me information at all (a part this link,
but the comments left on it do not seems to be promising) and this is actually surpricing for m so my question is then for this community.
Thanks in advance to all of you
Cheers
G

  0 Comments

Sign in to comment.

Answers (1)

Jim Hokanson
Jim Hokanson on 13 Mar 2015
To work with Google Sheets, you would need to use their API.
This API is language agnostic and communication is via HTTP.
The tricky part then is sending the correct HTTP requests. You can use urlread to send HTTP requests or my FEX submission which gives you a bit better control:
That being said, you still need to implement OAUTH2, which is much easier than OAUTH1 but still not trivial.
On Windows you can use a program called Fiddler to observe the HTTP traffic between Matlab and any client you are sending requests to if you want to get a better feel for how HTTP requests work.
Ultimately I think the best way forward with this is to write a wrapper for the Python bindings. Interaction with Python is supported since Matlab 2014b.

  0 Comments

Sign in to comment.

Sign in to answer this question.

Products