I have collected all Excel enumerations from the Microsoft website in a single JSON file. For me it was quite difficult to search this data when I was writing excel automations so I wanted to make some sort of an enum class to be able to easily access thiese properties, say red := XLENUM.COLOR.RED. So far I have stopped after I collected all of them in a single file. Maybe some of you have ideas on what to do with it. I am open to new ideas. Example enumeration:
Code: Select all
"xlconditionvaluetypes": {
"xlConditionValueAutomaticMax": {
"Name": "xlConditionValueAutomaticMax",
"Value": 7,
"Description": "The longest data bar is proportional to the maximum value in the range."
},
"xlConditionValueAutomaticMin": {
"Name": "xlConditionValueAutomaticMin",
"Value": 6,
"Description": "The shortest data bar is proportional to the minimum value in the range."
},
"xlConditionValueFormula": {
"Name": "xlConditionValueFormula",
"Value": 4,
"Description": "Formula is used."
},
"xlConditionValueHighestValue": {
"Name": "xlConditionValueHighestValue",
"Value": 2,
"Description": "Highest value from the list of values."
},
"xlConditionValueLowestValue": {
"Name": "xlConditionValueLowestValue",
"Value": 1,
"Description": "Lowest value from the list of values."
},
"xlConditionValueNone": {
"Name": "xlConditionValueNone",
"Value": "-1",
"Description": "No conditional value."
},
"xlConditionValueNumber": {
"Name": "xlConditionValueNumber",
"Value": 0,
"Description": "Number is used."
},
"xlConditionValuePercent": {
"Name": "xlConditionValuePercent",
"Value": 3,
"Description": "Percentage is used."
},
"xlConditionValuePercentile": {
"Name": "xlConditionValuePercentile",
"Value": 5,
"Description": "Percentile is used."
}
},Here is the repo:
https://github.com/kensain/ExcelEnums