Forum Discussion
Attempting to add a locale to the exporting Excel file
I am trying to use C# to insert numbers and datetime into Excel with the format of a predefined locale (e.g., "fr-FR"), and my computer is running the Windows operating system with the "en-US" locale...
When an Excel file is opened, cells with a date format are automatically displayed in the correct language, using the Windows locale settings. Same applies to numbers: the correct decimal and thousands separators are automatically applied when the file is opened.