curl - Octave doesn't read google spreadsheet -

curl - Octave doesn't read google spreadsheet -

urlread fails open spreadsheet available link. opens browser, urlread gives error:

octave:1> a=urlread('https://docs.google.com/spreadsheets/d/.../edit?usp=sharing'); error: urlread: curl: peer certificate cannot authenticated given ca certificates

is there way import google spreadsheet octave program?

this seems work, need link google spreadsheet can view assume have because end of url posted contains "sharing".

octave:1> urlwrite("https://docs.google.com/spreadsheets/d/.../export?format=csv", "filename.csv") octave:2> = load("filename.csv") = 1 23 4 5 1 6 3 7 1 6 6 7

replace ... id of google spreadsheet.

the key component here /d/.../export?format=csv specifies download of file csv. google spreadsheets supports several different filetypes if don't want utilize csv.

curl octave google-docs