{"id":2129,"date":"2026-06-17T07:22:40","date_gmt":"2026-06-16T23:22:40","guid":{"rendered":"https:\/\/xlwings.net\/blog\/?p=2129"},"modified":"2026-03-28T07:37:13","modified_gmt":"2026-03-28T07:37:13","slug":"how-to-use-applicationinternational-in-the-xlwings-api-way","status":"publish","type":"post","link":"https:\/\/xlwings.net\/blog\/how-to-use-applicationinternational-in-the-xlwings-api-way\/","title":{"rendered":"How to use Application.International in the xlwings API way"},"content":{"rendered":"\n

The Application.International<\/code> property in Excel is a read-only property that returns information about the current country\/region and international settings in Excel. This is particularly useful for creating locale-aware macros or scripts that need to adapt to different regional formats, such as date formats, currency symbols, list separators, and more. In xlwings, this property can be accessed via the api<\/code> object, which provides a direct gateway to Excel’s underlying object model. Understanding how to use International<\/code> allows developers to write more robust and portable code that functions correctly across various international versions of Excel.<\/p>\n\n\n\n

The syntax for accessing the International<\/code> property in xlwings is straightforward. Since International<\/code> is a property of the Application<\/code> object, you first need to get a reference to the Excel application through xlwings, typically via app = xw.App()<\/code> or by using the active app. Then, you can access the property using app.api.International<\/code>. The key aspect is that International<\/code> accepts an index argument (a constant or numeric value) that specifies which setting to return. This index corresponds to Excel’s XlApplicationInternational<\/code> constants, which are enumerations defining various international parameters. For example, xlCountryCode<\/code> (value 1) returns the country\/region code, while xlCurrencyDigits<\/code> (value 25) returns the number of decimal digits used in currency formats. The available indices are numerous, and developers should refer to the official Excel VBA documentation for a comprehensive list, as xlwings does not redefine these constants but relies on Excel’s built-in enumerations.<\/p>\n\n\n\n

Here is a table of some common XlApplicationInternational<\/code> indices and their meanings, which can be used with International<\/code> in xlwings:<\/p>\n\n\n\n

Index Constant (VBA Name)<\/th>Value<\/th>Description<\/th><\/tr><\/thead>
xlCountryCode<\/td>1<\/td>Returns the country\/region code for the current system.<\/td><\/tr>
xlCountrySetting<\/td>2<\/td>Returns the country\/region setting from the Windows Control Panel.<\/td><\/tr>
xlCurrencyDigits<\/td>25<\/td>Returns the number of decimal digits used in currency formats.<\/td><\/tr>
xlCurrencyCode<\/td>27<\/td>Returns the currency symbol for the current locale.<\/td><\/tr>
xlDateSeparator<\/td>17<\/td>Returns the date separator character (e.g., “\/” or “-“).<\/td><\/tr>
xlTimeSeparator<\/td>18<\/td>Returns the time separator character (e.g., “:”).<\/td><\/tr>
xlListSeparator<\/td>5<\/td>Returns the list separator character (e.g., “,” or “;”).<\/td><\/tr>
xlDayCode<\/td>21<\/td>Returns the day symbol used in date formats.<\/td><\/tr>
xlMonthCode<\/td>20<\/td>Returns the month symbol used in date formats.<\/td><\/tr>
xlYearCode<\/td>19<\/td>Returns the year symbol used in date formats.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

In xlwings, you can use these indices by their numeric values directly, as the constants are not natively provided in the xlwings module. However, for clarity, you can define them in your code based on the VBA enumerations. The property returns a value that can be a string, number, or character, depending on the index. It is important to note that the behavior might vary slightly across different Excel versions, so testing in the target environment is recommended.<\/p>\n\n\n\n

Below are practical examples of using the Application.International<\/code> property with xlwings in Python. These examples demonstrate how to retrieve various international settings and use them in data processing or formatting tasks.<\/p>\n\n\n\n

Example 1: Retrieving basic locale information.<\/p>\n\n\n\n

import xlwings as xw\n\n# Connect to the active Excel application\napp = xw.apps.active\n\n# Get the country\/region code (index 1)\ncountry_code = app.api.International[1]\nprint(f\"Country\/Region Code: {country_code}\")\n\n# Get the list separator (index 5)\nlist_separator = app.api.International[5]\nprint(f\"List Separator: '{list_separator}'\")\n\n# This can be used to dynamically format CSV files or split text based on locale.<\/code><\/pre>\n\n\n\n
Example 2: Working with date and currency formats.<\/p>\n\n\n\n
import xlwings as xw\n\napp = xw.apps.active\n\n# Get date and time separators\ndate_sep = app.api.International[17] # xlDateSeparator\ntime_sep = app.api.International[18] # xlTimeSeparator\nprint(f\"Date Separator: {date_sep}, Time Separator: {time_sep}\")\n\n# Get currency digits and symbol\ncurrency_digits = app.api.International[25] # xlCurrencyDigits\ncurrency_symbol = app.api.International[27] # xlCurrencyCode\nprint(f\"Currency Digits: {currency_digits}, Symbol: {currency_symbol}\")\n\n# Use these to format numbers in a worksheet dynamically\nsheet = app.books.active.sheets[0]\ncell = sheet.range(\"A1\")\ncell.value = 1234.56\ncell.number_format = f\"#{currency_symbol}0.{'0' * currency_digits}\" # Custom format based on locale<\/code><\/pre>\n\n\n\n
Example 3: Adapting data parsing based on international settings.<\/p>\n\n\n\n
import xlwings as xw\n\napp = xw.apps.active\n\n# Get the day, month, and year codes for date formats\nday_code = app.api.International[21] # xlDayCode\nmonth_code = app.api.International[20] # xlMonthCode\nyear_code = app.api.International[19] # xlYearCode\nprint(f\"Date Format Codes: Day={day_code}, Month={month_code}, Year={year_code}\")\n\n# This information can help in parsing date strings from different locales,\n# especially when dealing with text data imported into Excel.<\/code><\/pre>\n\n\n\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
The `Application.International` property in Excel is a read-only property that returns information a…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25],"tags":[],"class_list":["post-2129","post","type-post","status-publish","format-standard","hentry","category-xlwings-api-reference"],"_links":{"self":[{"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/posts\/2129","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/comments?post=2129"}],"version-history":[{"count":1,"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/posts\/2129\/revisions"}],"predecessor-version":[{"id":3254,"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/posts\/2129\/revisions\/3254"}],"wp:attachment":[{"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/media?parent=2129"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/categories?post=2129"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/tags?post=2129"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}