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 Code | Language |
---|
ar | Arabic |
az | Azerbaijani |
cz | Czech |
de | German |
de_AT | German (Austria) |
de_CH | German (Switzerland) |
el | Greek |
en | English |
en_AU | English (Australia) |
en_AU_ocker | English (Australian Ocker |
en_BORK | English (Bork) |
en_CA | English (Canada) |
en_GB | English (UK) |
en_IE | English (Ireland) |
en_IND | English (India) |
en_US | English (United States) |
es | Spanish |
fa | Farsi |
fr | French |
fr_CA | French (Canada) |
ge | Georgian |
id_ID | Indonesia |
ja | Japanese |
ko | Korean |
lv | Latvian |
nb_NO | Norwegian |
nep | Nepalese |
nl | Dutch |
nl_BE | Dutch (Belgium) |
pl | Polish |
pt_BR | Portugese (Brazil) |
pt_PT | Portugese (Portugal) |
ro | Romanian |
ru | Russian |
sk | Slovakian |
sv | Swedish |
tr | Turkish |
uk | Ukrainian |
vi | Vietnamese |
zh_CN | Chinese |
zh_TW | Chinese (Taiwan) |