Matlab and Google Sheet Compatibility

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

Answer 1

[Jim Hokanson]

To work with Google Sheets, you would need to use their API.

https://developers.google.com/google-apps/spreadsheets

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:

http://www.mathworks.com/matlabcentral/fileexchange/35693-urlread2

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.

http://www.telerik.com/download/fiddler

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.