Import data from google sheets to matlab

Question

Hüseyin Cagdas Yatkin 2019-12-12

1
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/496246-import-data-from-google-sheets-to-matlab

评论： O.Hubert 2024-6-5

Hello guys,

I wanted to import data from google sheets to matlab. However I couldn't find any information about it. Since the google sheets always geting update I can't just copy and paste so I wanted to import new data for every time I run the matlab script. Is there a way?

Thanks in advance.

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Vinicio Moya 2020-6-26

Did you resolve it?

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Donald 2021-3-4

9
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/496246-import-data-from-google-sheets-to-matlab#answer_639401

在 MATLAB Online 中打开

First, find the ID for your Sheet. It's the long string if you look at the URL. For example,

http s://docs.google.com/spreadsheets/d/bladjaljd77442n2j3ljk2j3j2jdkdjad/edit#gid=1498695871

Then it's easy

ID = 'bladjaljd77442n2j3ljk2j3j2jdkdjad'
sheet_name = 'My Sheet';
url_name = sprintf('https://docs.google.com/spreadsheets/d/%s/gviz/tq?tqx=out:csv&sheet=%s',...
    ID, sheet_name);
sheet_data = webread(url_name);

5 个评论
显示 3更早的评论隐藏 3更早的评论

Bennet Den Hoed 2021-8-3

Stuart,

I am finding that any headers that I have in my Google Sheet get included into the "header" of the MATLAB table (unsure of the technical term - see yellow highlight in screenshot). Only the numeric values are included in the MATLAB table itself, making it 4x2 instead of 5x2.

I am actually interested in having the headers included in the table (5x2 case is desirable for me). I've played around a bit, without much luck.

Inserting another row of "dummy headers" in row 1 of the Google Sheet: The two strings get concatenated and left in the "header" of the MATLAB table, still.
Placing the headers at the bottom row of the Google Sheet: These headers are ignored and generic names (Var1, Var2) are instead assigned.
Creating a table of only characters in the Google Sheet: First row is put into the MATLAB "header" and the body of the MATLAB table becomes the other strings.

It seems that the table must be either all numbers or all strings. Again, I would like there to be a mix of this (5x2 case, with the headers as the first row of the MATLAB table).

Can anyone help me figure out how to do this?