XlApplicationInternational Enum

Definition

Namespace:

Microsoft.Office.Interop.Excel

Assembly:

Microsoft.Office.Interop.Excel.dll

Specifies country/region and international settings.

public enum class XlApplicationInternational

public enum XlApplicationInternational

Public Enum XlApplicationInternational

Inheritance

Enum

XlApplicationInternational

Fields

Name	Value	Description
xlCountryCode	1	Country/Region version of Microsoft Excel.
xlCountrySetting	2	Current country/region setting in the Windows Control Panel.
xlDecimalSeparator	3	Decimal separator.
xlThousandsSeparator	4	Zero or thousands separator.
xlListSeparator	5	List separator.
xlUpperCaseRowLetter	6	Uppercase row letter (for R1C1-style references).
xlUpperCaseColumnLetter	7	Uppercase column letter.
xlLowerCaseRowLetter	8	Lowercase row letter.
xlLowerCaseColumnLetter	9	Lowercase column letter.
xlLeftBracket	10	Character used instead of the left bracket ([) in R1C1-style relative references.
xlRightBracket	11	Character used instead of the right bracket (]) in R1C1-style references.
xlLeftBrace	12	Character used instead of the left brace ({) in array literals.
xlRightBrace	13	Character used instead of the right brace (}) in array literals.
xlColumnSeparator	14	Character used to separate columns in array literals.
xlRowSeparator	15	Character used to separate rows in array literals.
xlAlternateArraySeparator	16	Alternate array item separator to be used if the current array separator is the same as the decimal separator.
xlDateSeparator	17	Date separator (/).
xlTimeSeparator	18	Time separator (:).
xlYearCode	19	Year symbol in number formats (y).
xlMonthCode	20	Month symbol (m).
xlDayCode	21	Day symbol (d).
xlHourCode	22	Hour symbol (h).
xlMinuteCode	23	Minute symbol (m).
xlSecondCode	24	Second symbol (s).
xlCurrencyCode	25	Currency symbol.
xlGeneralFormatName	26	Name of the General number format.
xlCurrencyDigits	27	Number of decimal digits to be used in currency formats.
xlCurrencyNegative	28	Currency format for negative currency values:0 = (symbolx) or (xsymbol)1 = -symbolx or -xsymbol2 = symbol-x or x-symbol3 = symbolx- or xsymbol-where symbol is the currency symbol of the country or region. Note that the position of the currency symbol is determined by xlCurrencyBefore.
xlNoncurrencyDigits	29	Number of decimal digits to be used in noncurrency formats.
xlMonthNameChars	30	Always returns three characters for backward compatibility. Abbreviated month names are read from Microsoft Windows and can be any length.
xlWeekdayNameChars	31	Always returns three characters for backward compatibility. Abbreviated weekday names are read from Microsoft Windows and can be any length.
xlDateOrder	32	Order of date elements:0 = month-day-year1 = day-month-year2 = year-month-day
xl24HourClock	33	True if you’re using 24-hour time; False if you’re using 12-hour time.
xlNonEnglishFunctions	34	True if you’re not displaying functions in English.
xlMetric	35	True if you’re using the metric system; False if you’re using the English measurement system.
xlCurrencySpaceBefore	36	True if a space is added before the currency symbol.
xlCurrencyBefore	37	True if the currency symbol precedes the currency values; False if it follows them.
xlCurrencyMinusSign	38	True if you’re using a minus sign for negative numbers; False if you’re using parentheses.
xlCurrencyTrailingZeros	39	True if trailing zeros are displayed for zero currency values.
xlCurrencyLeadingZeros	40	True if leading zeros are displayed for zero currency values.
xlMonthLeadingZero	41	True if a leading zero is displayed in months (when months are displayed as numbers).
xlDayLeadingZero	42	True if a leading zero is displayed in days.
xl4DigitYears	43	True if you’re using four-digit years; False if you’re using two-digit years.
xlMDY	44	True if the date order is month-day-year for dates displayed in the long form; False if the date order is day-month-year.
xlTimeLeadingZero	45	True if a leading zero is displayed in times.