Setting the Locale

Search Knowledge Base by Keyword

< Back

You can specify a Locale for each sheet before generating data, using the Locale function to set the language and/or geography of the generated data. This is relevant to functions that generate country specific information, such as phone numbers, addresses, or zip codes. It also determines the lists used to create fictitious personal information such as names.

To set the local, use the function =DataGen.SetLocale() , and type the locale code in double quotes.

For instance, the function =DataGen.SetLocale(“SV”) sets the locale to Sweden.

The cell in which you have set the locale will confirm the locale set.

Note: the locale codes are case sensitive.

The following locales are provided in the Add-In:

Locale CodeLanguage
arArabic
azAzerbaijani
czCzech
deGerman
de_ATGerman (Austria)
de_CHGerman (Switzerland)
elGreek
enEnglish
en_AUEnglish (Australia)
en_AU_ockerEnglish (Australian Ocker
en_BORKEnglish (Bork)
en_CAEnglish (Canada)
en_GBEnglish (UK)
en_IEEnglish (Ireland)
en_INDEnglish (India)
en_USEnglish (United States)
esSpanish
faFarsi
frFrench
fr_CAFrench (Canada)
geGeorgian
id_IDIndonesia
jaJapanese
koKorean
lvLatvian
nb_NONorwegian
nepNepalese
nlDutch
nl_BEDutch (Belgium)
plPolish
pt_BRPortugese (Brazil)
pt_PTPortugese (Portugal)
roRomanian
ruRussian
skSlovakian
svSwedish
trTurkish
ukUkrainian
viVietnamese
zh_CHChinese
zh_TWChinese (Taiwan)