uscoauditlog (version 1.0.3)

format_from_excel: Helper Function

Description

Reads in the outputted excel file from the clean_data_to_excel function and formats and returns the data as a dictionary that uses FIELD types as keys and NON-FIELD types as the values of those keys

Usage

format_from_excel(filename)

Arguments

filename

Input the cleaned .xlsx sheet outputted from the function clean_data_to_excel

Value

Returns a vector dictionary that contains the formatted version of the cleaned data.

Examples

# NOT RUN {
filename = "data.xlsx"
filename = clean_data_to_excel(filename)
format_from_excel(filename)
# }