read_spreadsheet: Convenience function to read spreadsheet-like files

In psyverse: Decentralized Unequivocality in Psychological Science

Convenience function to read spreadsheet-like files

Description

Currently reads spreadsheets from Google Sheets or from xlsx, csv, or sav files. Normally, you don't use this, but instead you use dct_from_spreadsheet().

Usage

read_spreadsheet(
  x,
  sheet = NULL,
  columnDictionary = NULL,
  localBackup = NULL,
  exportGoogleSheet = TRUE,
  flattenSingleDf = FALSE,
  xlsxPkg = c("rw_xl", "openxlsx", "XLConnect"),
  failQuietly = FALSE,
  silent = psyverse::opts$get("silent")
)

Arguments

x	The URL or path to a file.
sheet	Optionally, the name(s) of the worksheet(s) to select.
columnDictionary	Optionally, a dictionary with column names to check for presence. A named list of vectors.
localBackup	If not NULL, a valid filename to write a local backup to.
exportGoogleSheet	If x is a URL to a Google Sheet, instead of using the googlesheets4 package to download the data, by passing exportGoogleSheet=TRUE, an export link will be produced and the data will be downloaded as Excel spreadsheet.
flattenSingleDf	Whether to return the result as a data frame if only one data frame is returned as a result.
xlsxPkg	Which package to use to work with Excel spreadsheets.
failQuietly	Whether to give an error when x is not a valid URL or existing file, or just return NULL invisibly.
silent	Whether to be silent or chatty.

Value

A list of dataframes, or, if only one data frame was loaded and flattenSingleDf is TRUE, a data frame.

Examples

### Note that this example requires an internet connection!
read_spreadsheet(
  paste0(
    "https://docs.google.com/",
    "spreadsheets/d/",
    "1bHDzpCu4CwEa5_3_q_9vH2691XPhCS3e4Aj_HLhw_U8"
  )
);

psyverse documentation built on March 7, 2023, 8:31 p.m.