Excel
Using EPPlus or ClosedXML for Excel in C Sharp Projects
Choose between EPPlus and ClosedXML for reading and writing xlsx in C Sharp: licensing, API, performance, formulas and when to use the Open XML SDK instead.
8 min read
Tag
csharp
5 posts
JSON
Reading JSON in C Sharp With System Text Json Defaults
What System.Text.Json does by default in .NET 9: exact-case names, JsonSerializerDefaults.Web, enum surprises, the 64 level depth limit and duplicate keys.
6 min read
XML
Serializing C Sharp Objects to XML Without the Extra Noise
XmlSerializer writes xsi and xsd namespace declarations and a utf-16 header by default. Remove them, control attributes and lists, and see what it ignores.
6 min read
XML
Reading XML in C Sharp With XDocument and LINQ to XML
Load XML into XDocument, query with LINQ, cast attributes and elements to typed values, handle namespaces, and avoid the culture trap in decimal.Parse.
6 min read
CSV
Reading a CSV File in C Sharp With CsvHelper Correctly
Read CSV in C# with CsvHelper 33: case-sensitive headers, typed ZIP codes, silent ragged rows, and a de-DE culture that made a total 91 times too big.
10 min read