Skip to content

Instantly share code, notes, and snippets.

Embed
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 http://closedxml.codeplex.com/wikipage?title=Showcase&referringTitle=Documentation
// 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 : http://www.lcube.se/closedxml-det-enkla-sattet-att-exportera-till-excel/
using ClosedXML.Excel;
namespace HelloClosedXML
{
class Program
{
static void Main(string[] args)
{
var wb = new XLWorkbook();
var ws = wb.Worksheets.Add("Contacts");
//Title
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");
rngTable.Cells().Style
.Font.SetBold()
.Fill.SetBackgroundColor(XLColor.CornflowerBlue);
// 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;
//DateTime
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);
//Numeric
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
ws.Columns().AdjustToContents();
//Save file on desktop
string path = Environment.GetFolderPath(Environment.SpecialFolder.Desktop);
string excelFilePath = System.IO.Path.Combine(path, "ShowcaseÅÄÖ.xlsx");
wb.SaveAs(excelFilePath);
}
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment