Reading/Writing Excel (and Other) files directly from Google Drive??

Question

Hello All

I am a Monarch 14 user.  Does anyone know if it is possible to directly read & write to Excel (or Other) files stored on Google Drive using Monarch Models and Projects.

Thanks,

Al Rice

Roger DeAngelis_21630 · Answer

Monarch and altair personal slc reading and writing google sheets

Too long to post to a listserve, see github

github

https://github.com/rogerjdeangelis/utl-monarch-and-altair-personal-slc-reading-and-writing-google-sheets

https://community.altair.com/discussion/6385/reading-writing-excel-and-other-files-directly-from-google-drive?tab=all&utm_source=community-search&utm_medium=organic-search&utm_term=monarch%20excel

Note: It is very easy to convert an excel sheet to an R dataframe and then create a google sheet;

df <- read_excel("path/to/your/excelfile.xlsx")

PROCESS (I assume you have access to google sheets)

1 set up a googlesheets api and Oath

EDIT code below

Replace  abcdefghij with your Oath

  Replace  abcd with your API

  myapp is arbitrary

client = gargle::gargle_oauth_client(

    id = "abcd",

    secret = "abcdefghij",

    name = "myapp"

  )

2 Create google sheet. sheet_new using R builtin irsis dataframe

  Note gs4_create will automatically overwrite a google sheet if it exists

3 create dataframe, df, from google sheet 'sheet_new

  and use sql to subset for species=setosa

4 create wpd dataset from the subsetted sheet

Altair Forum User · Answer

Hi Al Rice,

For now, Monarch can only get data from FTP, Sharepoint, AWS and Webdav. Thanks