Message Boards

7939 Views

2 Replies

2 Total Likes

View groups...

Follow this post

Share this post:

GROUPS:

Import and Export Wolfram Cloud Wolfram Development Platform

Wolfram Cloud - Workaround for Import[<url>, "Data"] bug ?

Fredrik Doberl, Ablona

Posted 11 years ago

Import["https://docs.google.com/spreadsheets/d/1Vj5v4Tx-BidF5KaoqyrLWpnUSMKvnqW6dVS4b7w-r8M/edit?usp=sharing", "Data"]; Import only imports the first 100 elements of the spreadsheet. According to the support, it depends on a restriction in Google Spreadsheet Anyone has any ideas for a workaround?

POSTED BY: Fredrik Doberl

2 Replies

Sort By:

Posted 11 years ago

You may try Import["https://docs.google.com/spreadsheets/d/1Vj5v4Tx-BidF5KaoqyrLWpnUSMKvnqW6dVS4b7w-r8M/export?format=csv&id=1Vj5v4Tx-BidF5KaoqyrLWpnUSMKvnqW6dVS4b7w-r8M&usp=sharing", "CSV"] This is the link from the Google SpreadSheet when one does a File -> Download as -> Comma-separated values (.csv, current sheet) which is the source attribute on an iframe on this web page. Splicing that iframe src with the base URL, removing the gid adding usp=sharing. The final URL seems to import the data you want. To do this for any other similar google doc report explore the DOM with your browser's development kit or examine your network traffic to see where the download as links take you.

POSTED BY: Hans Michel

Posted 11 years ago

Great! It worked even better with my real data when I replaced the csv value for the format parameter and parameter to Import with xlsx. Date and structure was more like the straightforward import of the direct sharing link.

POSTED BY: Fredrik Doberl

Reply to this discussion

Reply Preview

Attachments

Remove Add a file to this post

Follow this discussion

or Discard

Feedback