Skip to content

Instantly share code, notes, and snippets.

Last active August 29, 2015 14:12
What would you like to do?
Example of ClosedXML handling ÅÄÖ
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
// to use close xml use nuget Package Manager Console: Install-Package ClosedXML
// example from
// This example is to prove that closedXML has no problem with strings containing å ä ö swedish letters with umlauts and circles.
// it adds person with name Tösse Långbänk
// Its from question here :
using ClosedXML.Excel;
namespace HelloClosedXML
class Program
static void Main(string[] args)
var wb = new XLWorkbook();
var ws = wb.Worksheets.Add("Contacts");
ws.Cell("B2").Value = "Contacts";
//First Names
ws.Cell("B3").Value = "FName";
ws.Cell("B4").Value = "John";
ws.Cell("B5").Value = "Hank";
ws.Cell("B6").SetValue("Dagny"); // Another way to set the value
ws.Cell("B7").Value = "Tösse";
//Last Names
ws.Cell("C3").Value = "LName";
ws.Cell("C4").Value = "Galt";
ws.Cell("C5").Value = "Rearden";
ws.Cell("C6").SetValue("Taggart"); // Another way to set the value
ws.Cell("C7").Value = "Långbänk";
//Format the ÅÄÖ
var rngTable = ws.Range("B7:C7");
// Boolean
ws.Cell("D3").Value = "Outcast";
ws.Cell("D4").Value = true;
ws.Cell("D5").Value = false;
ws.Cell("D6").SetValue(false); // Another way to set the value
ws.Cell("D7").Value = true;
ws.Cell("E3").Value = "DOB";
ws.Cell("E4").Value = new DateTime(1919, 1, 21);
ws.Cell("E5").Value = new DateTime(1907, 3, 4);
ws.Cell("E6").SetValue(new DateTime(1921, 12, 15)); // Another way to set the value
ws.Cell("E7").Value = new DateTime(1912, 2, 29);
ws.Cell("F3").Value = "Income";
ws.Cell("F4").Value = 2000;
ws.Cell("F5").Value = 40000;
ws.Cell("F6").SetValue(10000); // Another way to set the value
ws.Cell("F7").SetValue(13000); // Another way to set the value
//Adjust column widths
//Save file on desktop
string path = Environment.GetFolderPath(Environment.SpecialFolder.Desktop);
string excelFilePath = System.IO.Path.Combine(path, "ShowcaseÅÄÖ.xlsx");
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment