similar,
it would be
dictionary(string, dictionary(of string, string) for most
excel file = dictionary (sheet (string), dictionary (string (key (range a)), string (value (range b)))
but also
excel file = dictionary (sheet (string), dictionary(string (subDictionary index name) , dictionary (string (key (range a)), string (value (range b)))
so I need a dictionary that can handle string, dic (string, string) but also string, dic(string, dic(string, string)
individually I can make these, but I cannot figure out how to add them all into one dictionary
in other languages I can do this in minutes, but because the data type must be set beforehand I cannot figure this out.
Ideally I want to be able to call values like this
ConfigDic(“section”)(“key1”) and ConfigDic(“section”)(“subsection1”)(“key1”)
I have attached my test excel file.
configFile.xlsx (18.2 KB)