get_cell: Determine cell location in spreadsheet.

Description Usage Arguments Details Value

Description

get_cell finds a cell specified by a column that corresponds to user_col and a row specified by today's date, possibly shifted by shift.

Usage

1
get_cell(d, user_col, date = Sys.Date(), shift = 0)

Arguments

d

A data frame version of the "Data" worksheet in spreadsheet ss (see googlesheet).

user_col

A character string providing a username, which should correspond to a column in the spreadsheet.

date

an optional parameter to specify the date in a YYY-MM-DD format. Default is Sys.Date().

shift

An integer to define the number of days by which the data entry date should be shifted. Default is 0. The day after today (tomorrow) is +1, yesterday is -1, etc.

Details

This function is not called directly, but is a helper function for write_time.

Value

The function returns the alpha-numeric location of the cell (e.g, "D42") as a character string.


bochocki/slackrsheets documentation built on May 8, 2019, 9:46 a.m.