search

opensourceantibiotics / GeneralTopics

General Comments about Open Source Antibiotics Research
6 stars 0 forks source link

DataWarrior Import from Google sheet #7

Open drc007 opened 3 years ago

drc007 commented 3 years ago

We can use this URL

https://docs.google.com/spreadsheets/d/168-a1_l51Nfbms67eG8zU8p-EhEtEO26FUzRInbu7fY/export?format=tsv

to access the first tab of the Google sheet, how do we import from specific tabs?

drc007 commented 3 years ago

Looks like this works (many thanks to Isabelle).

url=https://docs.google.com/spreadsheets/d/168-a1_l51Nfbms67eG8zU8p-EhEtEO26FUzRInbu7fY/export?format=tsv&gid=1078638615 format=td
drc007 commented 3 years ago

I've created 4 macros to import various subsets. OSADataWarriorMacros.zip

Uncompress and save the files somewhere, in DataWarrior in the Macro menu select import. The macro should then appear in the "Run Macro" menu items. @mattodd @danaklug @loriferrins let me know if this works for you.

danaklug commented 3 years ago

@drc007 Yep worked for me - thanks to you and Isabelle!

drc007 commented 3 years ago

Brilliant.