codebook_fromSpreadsheet: Import a code book specification from a spreadsheet
In rock: Reproducible Open Coding Kit

View source: R/codebook_fromSpreadsheet.R

codebook_fromSpreadsheet

R Documentation

Import a code book specification from a spreadsheet

Description

Import a code book specification from a spreadsheet

Usage

codebook_fromSpreadsheet(
  x,
  localBackup = NULL,
  exportGoogleSheet = TRUE,
  xlsxPkg = c("rw_xl", "openxlsx", "XLConnect"),
  silent = rock::opts$get("silent")
)

Arguments

`x`	The URL or path to a file.
`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.
`xlsxPkg`	Which package to use to work with Excel spreadsheets.
`silent`	Whether to be silent or chatty.

Value

The code book specification as a rock code book object

Examples

### This requires an active internet connection
if (FALSE) {
  gs_url <- paste0(
    "https://docs.google.com/spreadsheets/d/",
    "1gVx5uhYzqcTH6Jq7AYmsLvHSBaYaT-23c7ZhZF4jmps"
  );
  codebook <- rock::codebook_fromSpreadsheet(gs_url);
}

rock documentation built on Dec. 28, 2022, 1:55 a.m.