dot-grab_cell: Get Excel Cell Value

In daniel-r-germony/dstCSDR: Tools for Cost and Software Data Reporting (CSDR) Data

Description

A function which pulls the value out of an individual Excel cell and reurns it to R.

Usage

.grab_cell(path, cell_range)

Arguments

path	Required. The full path to an Excel file.
cell_range	Required. The cell range where you want to pull data form. Must be in the "A1" style.

Value

Returns the value from the Excel file as an "NA" if the cell was blank or as a character otherwise

See Also

.create_excel_ws_ls() to create a tibble of files and worksheet names.

.import_excel_ws_ls() for how to import worksheets identfied in the tibble created with this function.

Other dstCSDR Import Excel Data Functions: .create_excel_ws_ls, .import_excel_ws_ls

daniel-r-germony/dstCSDR documentation built on Jan. 4, 2020, 12:16 a.m.