dot-create_excel_ws_ls: .create_excel_ws_ls

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

Description

Create an Excel File and Worksheet Tibble

Usage

.create_excel_ws_ls(folder_path, recurse = TRUE)

Arguments

folder_path	Required. A path to the folder with Excel files you want data on.
recurse	Optional. If TRUE recurse fully, if a positive number the number of levels to recurse. Set to TRUE by default.

Details

Creates a tibble of information on all Excel (".xls" or ".xlsx") files found in a provided folder path.

Value

Returns a tibble with the following columns of data on all ".xls" or ".xlsx" files found at the provided path:

1. path: A full path to each Excel file found at the provided folder path.

2. folder_path: The folder path the Excel file was found in.

3. file_name: The Excel file name (with extention) found in the folder.

4. worksheet_title: The title of each worksheet in the Excel file.

Author(s)

Daniel Germony [e-mail]

See Also

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

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

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

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