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_CH

Chinese

zh_TW

Chinese (Taiwan)