Rank: 1692 based on 69 downloads (last 30 days) and 3 files submitted
photo

Claudiu Giurumescu

E-mail
Company/University
UCSD
Lat/Long
32.87694549560547, -117.2408294677734

Personal Profile:
Professional Interests:
stochastic processes, computational chemistry, computational biology

 

Watch this Author's files

 

Files Posted by Claudiu View all
Updated   File Tags Downloads
(last 30 days)
Comments Rating
20 Jun 2011 Matlab to Google Spreadsheets Matlab functions to send data to Google Spreadsheets. Author: Claudiu Giurumescu data export, data import, spreadsheet, import, export, google 36 10
  • 4.83333
4.8 | 7 ratings
11 May 2011 Screenshot Render text to image Renders text to an image using a true type font of choice. Author: Claudiu Giurumescu text rendering 13 0
12 Feb 2008 LZW encoder/decoder Implements a TIF compatible LZW encoding/decoding algorithm Author: Claudiu Giurumescu compression, lzw, encoder, decoder, decompression, tif 20 1
  • 3.5
3.5 | 2 ratings
Comments and Ratings by Claudiu View all
Updated File Comments Rating
26 Apr 2012 Matlab to Google Spreadsheets Matlab functions to send data to Google Spreadsheets. Author: 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='...@gmail.com';
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

20 Jun 2011 Matlab to Google Spreadsheets Matlab functions to send data to Google Spreadsheets. Author: 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.

Comments and Ratings on Claudiu's Files View all
Updated File Comment by Comments Rating
23 Apr 2014 Matlab to Google Spreadsheets Matlab functions to send data to Google Spreadsheets. Author: Claudiu Giurumescu Conover, Kent

Great idea, but "MatlabGoogTest" returns "Could not obtain authorization tokens from Google." when I try to log in. I am eager to see a fix!

11 Oct 2013 Matlab to Google Spreadsheets Matlab functions to send data to Google Spreadsheets. Author: Claudiu Giurumescu Sven

Wonderful work. The two things stopping 5 stars at the moment is documentation (none of the functions that the user must call have any help contents) and the 1-cell-at-a-time functionality only.

It would be very advantageous to supply similar functionality to xlsread/xlswrite, which both accept a cell range to read/write, and if no range is given, xlsread simply returns the full contents of that worksheet.

09 Apr 2013 Matlab to Google Spreadsheets Matlab functions to send data to Google Spreadsheets. Author: Claudiu Giurumescu Ahm, Malte

Really great functions! what is missing for me is a "editWorksheetCellBatch" function to be able to edit larger worksheets quicker.

I can see, that the Google API should support it:

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

I have tried making the function myself, but my experience with java and html protocols is very limited. I keep getting an error 400 (Bad Request) when i try to send the data to the server (ps.print(event)).

08 Apr 2013 Matlab to Google Spreadsheets Matlab functions to send data to Google Spreadsheets. Author: Claudiu Giurumescu Thomas

How long is the authentication valid for? I'm running this in a loop and I start getting 403 errors after about 500 seconds, which doesn't happen if I run each iteration by itself

08 Apr 2013 Matlab to Google Spreadsheets Matlab functions to send data to Google Spreadsheets. Author: Claudiu Giurumescu Thomas

Contact us