Import a (pre)registration form specification from a spreadsheet

Source: R/form_fromSpreadsheet.R

With this function, you can import a (pre) registration from a spreadsheet. See the "Creating a form from a spreadsheet" vignette for more information. That is available at https://preregr.opens.science/articles/creating_form_from_spreadsheet.html or can be shown by running vignette("creating_form_from_spreadsheet", package = "preregr")

form_fromSpreadsheet(
  x,
  localBackup = NULL,
  exportGoogleSheet = TRUE,
  xlsxPkg = c("rw_xl", "openxlsx", "XLConnect"),
  silent = preregr::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 thr 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 preregr form specification

Details

An empty simple example spreadsheet is available at https://docs.google.com/spreadsheets/d/14Qbak7JbBhTqmJaMgJ4tU9ZROaBbUfq37_UzkoHnM60 and can be initialized as the almostEmptyForm form with prereg_initialize()