Pull Information from Target Setting Tool "Home" Tab

This function extract information stored in the Target Setting Tool Home tab to identify either the country or what the fiscal year is.

Usage

grab_info(filepath, type)

Arguments

filepath

file path to the Target Setting Tool importing, must be .xlsx

type

either "country" or "year"

Examples

if (FALSE) {
path <- "../Downloads/DataPack_Jupiter_20200218.xlsx"
cntry <- grab_info(path, "country")
fy <- grab_info(path, "year")
}