sheet_nrow: Get the number of rows from a review table hosted on Google...

In gipsousp/sqlr: A System for Systematic Quantitative Literature Reviews

Get the number of rows from a review table hosted on Google Sheets

Description

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

sheet_nrow() returns the number of rows of a review table hosted on Google Sheets.

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

Usage

sheet_nrow(name, package = rutils:::get_package_name(), rm_header = TRUE)

Arguments

name	A string indicating the name of the sheets that the function must evaluate.
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).
rm_header	(optional) A logical value indicating if the function must consider the header when computing the number of rows. This only works when the sheets have one line as header (default: TRUE).

See Also

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

Examples

## Not run: 
sheet_nrow(sheets$domain$name)
## End(Not run)

gipsousp/sqlr documentation built on Sept. 29, 2023, 11:41 a.m.