read_all_excel: read_all_xls

In caimiao0714/MiaoTruck: Data manupulation for the NSF truck data.

Description

This function provides a way of reading all Microsoft Excel files (.xlsx & .xls) in the folder.

Usage

read_all_excel(path = getwd(), add_variable = TRUE)

Arguments

path	The path from which you want to read all the Microsoft Excel files (with the extension of .xlsx OR .xls). The default value of the parameter path is the current working directory.
add_variable	If the add_variable is TRUE, then an extra variable "file_name" will be added to each data.frame in the output list. The default value is set as TRUE.

Value

a list of dataframes, which can be combined using the rbindlist function in data.table package.

Examples

# Let's assume there are three files (A.xlsx, B.xlsx, C.xls) in the path "C:/data".
all_excel = read_all_excel(path = "C:/data")
# The above code should read all .xlsx & .xls files into the list "all_excel". You can access each data.frame by all_excel[["A"]], all_excel[["B"]], and all_excel[["C"]].
# If the parameter "add_variable" is set as TRUE, an extra variable "file_name" will be added to each data.frame in the output list.

caimiao0714/MiaoTruck documentation built on May 28, 2019, 7:14 p.m.