format_from_excel {uscoauditlog}

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)

## End(Not run)