read_sheets: read all the sheets from a Excel file

In mhkhan27/illuminate: Weighted survey analysis

read all the sheets from a Excel file

Description

read all the sheets from a Excel file

Usage

read_sheets(
  dataset_path,
  remove_all_NA_col = T,
  data_type_fix = T,
  na_strings = c("", "NA", "N/A", " "),
  sheets = "all",
  character_cols = NULL
)

Arguments

dataset_path	location of the dataset
remove_all_NA_col	A logical parameter. TRUE (default) with remove columns with all NAs
data_type_fix	will fix the data type.
sheets	Sheet to read. Must be the name of the sheet.Default is all, which will read all the available sheets in the excel file.
character_cols	name of the columns which must read as characters even if its a non character column.
na.string	only valid when data_type_fix is true

Value

All of the sheet as individual dataframe

mhkhan27/illuminate documentation built on March 25, 2023, 5:41 p.m.