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