Matlab to Google Spreadsheets

Matlab functions to send data to Google Spreadsheets.

Description

This set of Matlab functions will allow creating Google
spreadsheets, adding worksheets to them, modifying the
worksheets, and placing data in them.

Acknowledgements

The author wishes to acknowledge the following in the creation of this submission:
Create Google Calendar event with SMS and Email notification, 41 Complete GUI Examples
This submission has inspired the following:
View and add transaction to portfolios on Google Finance

• MATLAB release: MATLAB 7.10 (2010a)

[Jake Hughey]

this set of functions looks great, but what is missing for me is a "getWorksheetCell" function, because I also want to pull data from google spreadsheets into matlab. I don't know java well enough to write one myself.

[Claudiu Giurumescu]

Jake,

Thanks for the suggestion. I've updated the submission. You can now read both the cell value and its formula.

Hope this helps.

[Jake Hughey]

 

[Ted P Teng]

Excellent toolbox! You can also easily modify the 'editWorksheetCell' to edit for an array of cells instead of individual cells for reducing the number of http requests [ http://code.google.com/apis/spreadsheets/data/3.0/developers_guide.html#ListFeeds ].

[Matt Behr]

hello .... is there anyway to avoid the credentials dialog. I want to run a script nightly to update data in google docs.

Thanks!
Matt

[Claudiu Giurumescu]

Matt,

The code below should work (replace connectNAuthorize function in the package with the one below)
urlread should be provided by Matlab.

The 'writely' token is for Google Spreadsheets, the 'wise' token is for Google Docs.

Once you have the tokens you can use the other functions in the package.

Hope this helps,
Claudiu
%%%%%%%%%%%%%%%%%%%%%%
userName='[e-mail]';
password='...';

[authorized, aTokenS]=connectNAuthorize(userName, password,'writely');
if (~authorized)
    result=-1;
    return;
end
[authorized, aToken]=connectNAuthorize(userName, password,'wise');
if (~authorized)
    result=-1;
    return;
end

function [authorized, aToken]=connectNAuthorize(userName, password,service)

[str,authorized]=urlread('https://www.google.com/accounts/ClientLogin','POST',...
    {'Email',userName,'Passwd',password,'source','My-Matlab-1','service',service});

if authorized==1
    aToken=['auth' str(strfind(str,'Auth')+4:end-1)];
else
    aToken='';
end