Please enable JavaScript to view this site.


Navigation: Holidays

The Generated Holidays Explorer

Scroll Prev Up Next More

The Holidays Explorer is used to sort, filter, group and export the holidays occurrences and associated rules of all the generated holidays on your workstation.


To access the holidays explorer, use the holidays explorer menu item.


When the holidays explorer is launched, you are given a few options.


Range of Years


The first option is the option of restricting the range of years to load into the Holidays Explorer. By default, you are offered the range that includes the current year and the 2 following years. You can choose to extend this range to cover all the years for which holidays were generated, but it is not recommended that you do so as the generated holidays table can become very large, and unless its range is restricted it will take a while for the Holidays Explorer to become fully loaded.


Length of Holiday Names


You can also specify the maximum length of the holiday names displayed. This limit will affect the maximum length of each holiday exported to Excel. The default limit of 150 characters should be sufficient for most cases, but you can increase it to 1000 characters (although this will also increase the time needed for the holidays explorer to become fully loaded).




The NameVars option specifies if the holidays in the holidays explorer should have their name variations evaluated, or left as is (which can be useful to keep a backup copy of the rules of your holidays).


The Holidays Explorer Interface



After the Holidays Explorer is fully loaded, it appears as shown below.




At the center of the Holidays Explorer is an advanced data grid component, which can be used to sort, filter or group the list of generated holidays, usually in view of exporting them to Excel.


See also: the worldwide public holidays browser.


Topic 174930, last updated on 14-May-2024