Scilab and Google drive spreadsheet

General usage
1

Dear all,

is it possible to import the content of a google spreadsheet (stored at google drive) to scilab?

I was hoping that getURL() would download the content, even if it would be in a messy way, but it did not.

Thank you,
Philipp

2

Hello,

See

For example, the following sheet :

https://docs.google.com/spreadsheets/d/1W3W7VfpKR4_aFWWB8vYJ_lNyb1Nf1hDx4-ZYpNmgEZE/

can be downloaded in csv format by (the follow=%t is mandatory)

http_get("https://docs.google.com/spreadsheets/d/1W3W7VfpKR4_aFWWB8vYJ_lNyb1Nf1hDx4-ZYpNmgEZE/export?gid=0&format=csv",follow=%t)

S.

3

Hello Stéphane,

thank you.

I think there is something going on with my spreadsheet.

Accessing your example is working fine, even with get URL.

[myFile, content] = getURL(....)

However it does not work with my spreadsheet.
I tried to change access rights, but no success.

I always get something like this:

<!DOCTYPE html><html lang="de"><head><meta name="description" .....

Best regards,
Philipp

4

The url you are using in getURL or http_get should also work when you paste it in the address field of your navigator. What message do you get instead ?

S.

5

https://docs.google.com/spreadsheets/d/SPREAD_SHEED_ID

→ opens the spreadsheet in the browser

https://docs.google.com/spreadsheets/d/SPREAD_SHEED_ID/export?gid=0&format=csv

→ works with the spread sheet you provided
→ does not work with my spread sheet

The error message is something like this:

  • File currently can not be openend.
  • Check your adress and try again.

I kind of hesitate to publish the link to the spreadsheet here, but if you like I can send it to you via private E-Mail.

Thank you,
Philipp

6

Yes, send it to so that I can make some tests.

S.

7

With the shorter URL (without the gid parameter)

http_get("https://docs.google.com/spreadsheets/d/SPREAD_SHEET_ID/export?format=csv",follow=%t)

it works for me with the SPREAD_SHEET_ID you sent me.

S.

8

Stèphane,

this is working.

Many thanks.
Philipp

1 Like