엑셀 데이터를 JsonTree 형식으로 사용하는 방법(How to Use Excel Data in JSON Tree Format)

Help Activities
, ,
1

엑셀 파일을 읽어 Config 파일로 사용하려 합니다.
이때, Key-Value 형식으로 만들어서(딕셔너리)
시트명.Key => Value 로 사용하고 싶습니다.
예를 들면 Config.Today = 2026-03-31 의 형식으로 나오게 사용하려 합니다(아래 이미지 참고 부탁 드립니다)

위와 같은 방식으로 사용하려면 어떻게 해야하나요?

============================
English ver

I want to read an Excel file and use it as a config file.
At this time, I would like to structure it in a key-value format (dictionary)
so that it can be used in the form of SheetName.Key => Value.

For example, I want to use it like:
Config.Today = 2026-03-31 (please refer to the image below).

How can I implement it in this way?

image
image983×603 11.3 KB

2

@692622

Yes, you can the excel file as config file. You can access the elements as Config(“Key”) => value, even if it is dictionary variable or a json object you have to use this option only.

Per my knowledge, Config.Key => value is not feasible or no supported workaround for this.

For using it as dictionary, follow below steps:

For each row in DataTable
if String.IsNullOrEmpty(CurrentRow(“Key”).ToString):
Continue
else:
ConfigVar(CurrentRow(“Key”).ToString) = CurrentRow(“Value”)

Here, ConfigVar is a variable of type Dictionary(Of String, Object)

Hope this helps.