Write the review tables hosted on Google Sheets to the package

CAUTION: This function must be used only with packages that follow the sqlr system.

write_sheet() reads and write the review tables hosted on Google Sheets in the data directory of an R package.

You must have a sheets data object with the sheets metadata before running this function. See write_metadata() to learn more.

write_sheet() don't rewrite the sheets, reference or document table. It also don't write non-entity tables.

write_sheet(name = NULL, package = rutils:::get_package_name())

Arguments

name

(optional) A character object indicating the name or names of the sheets that the function must write (default: NULL).

package

(optional) a string indicating the package with the database data. If not assigned, the function will try to use the name of the active project directory (requires the rstudioapi package).

See also

Other Google Sheets functions: range_write(), read_sheet(), sheet_nrow(), write_metadata(), write_query()

Examples

if (FALSE) {
## To write all sheets

write_sheet()

## To write one or more specific sheets

write_sheet(sheets$domain$name)}