rebel_sheet: Rebel against godly Excel worksheet

In kikirinrin/lucifer: What the Package Does (One Line, Title Case)

Description

Rebel against godly Excel worksheet

Usage

rebel_sheet(
  sheet,
  path,
  row_headers = NULL,
  col_headers = NULL,
  cluster = NULL,
  row_type = NULL,
  col_type = NULL,
  row_omit = NULL,
  col_omit = NULL,
  unfiscalize = c(month_start = NULL, rule = NULL),
  print_posnames = FALSE,
  crop = NULL
)

Arguments

sheet	Sheet to read. Either a string (the name of a sheet), or an integer (the position of the sheet). Ignored if the sheet is specified via range. If neither argument specifies the sheet, defaults to the first sheet.
path	Path to the xls/xlsx file.
row_headers	Row position of merged colnames
col_headers	Column position of merged rownames
cluster	List of parameters to control unclusterize. dir direction of the cluster evolution either of "h" (horizontal) or "v" (vertical) pos row- or column- position of the key to locate the cluster regex same as that of unclusterize offset same as that of unclusterize dim same as that of unclusterize info same as that of unclusterize
row_type	Type of row one of Y year YM year-month jY Japanese year jYM Japanese year-month fisY fiscal year fisYM fiscal year-month fisjYM fiscal Japanese year-month
col_type	List of parameters to control gather_cols
row_omit	List of parameters to control rm_matchrow
col_omit	List of parameters to control rm_matchcol
unfiscalize	List of parameters to control unfiscalize
print_posnames	Same as that of ceasefire
crop	Params from crop() in list format

kikirinrin/lucifer documentation built on Nov. 10, 2021, 9:37 p.m.