Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

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

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

Find more posts tagged with

English

Monarch

Accepted answers

All comments

Altair Forum User

Hi Al Rice,

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

Roger DeAngelis_21630

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