Reading data from google spreadsheet
55 views (last 30 days)
Show older comments
Hello,
I'm reading data from a google spreadsheet file using the following code:
url_name = sprintf('https://docs.google.com/spreadsheets/d/%s/gviz/tq?tqx=out:csv&sheet=%s',docid);
sheet_data = webread(url_name);
where docid is the spreadsheet's identifier and sheet_data is a table type variable.
The problem is that the headers are all messed up (spaces between words are removed, special characters such as "ã, ç,ô,...", are ignored, and so on) and I'll need them further in the code.
This only occurs with the headers. The other cells in the spreadsheet that contain text are properly imported.
Is there a way to overcome these issues?
Thanks in advance.
Answers (1)
See Also
Categories
Find more on Google in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!