Comprehensive list of Excel Enumerations

Post your working scripts, libraries and tools.
Inspector
Posts: 28
Joined: 29 Jul 2019, 05:17
Contact:

Comprehensive list of Excel Enumerations

Post by Inspector » 16 Apr 2024, 07:09

Hi all,

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

Return to “Scripts and Functions (v2)”