Import data from google sheets to matlab
196 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
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.
Respuestas (3)
Donald
el 4 de Mzo. de 2021
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);
4 comentarios
Umair Mughal
el 21 de Dic. de 2021
That's really great, but doesn't work for protected sheets. The url returns the html content of google login page
dimuthu chathuranga
el 9 de Abr. de 2021
I have same problem please help me I want to real time uptade data fron google sheet to mathlab gui
1 comentario
Vinicio Moya
el 9 de Abr. de 2021
Editada: Walter Roberson
el 9 de Abr. de 2021
Yes.. you can use this funtion:
Ver también
Categorías
Más información sobre Google en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!