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

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.

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

if (FALSE) {
sheet_nrow(sheets$domain$name)}