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

Description Usage Arguments Details Value Author(s) See Also

Import Worksheets From a excel_ws_ls Object

1	.import_excel_ws_ls(excel_ws_ls)

excel_ws_ls

Required. A tibble object created (preferablly) using .create_excel_ws_ls which has a column of file paths and worksheet titles that will be imported.

Imports all worksheets listed in a excel_ws_ls object to a single tibble. Each column in the source worksheets should be of identical names and types.

Returns a tibble with each worksheet listed in the excel_ws_ls object combined into one tibble. A column with source_file_name and source_file_worksheet are also added to keep track of where the data came from.

Daniel Germony daniel.r.germony.civ@mail.mil

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

.grab_cell() pulls the value out of an individual Excel cell and reurns it to R.

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

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