Discovered a NuGet package called ClosedXML. Takes away the pain of dealing with OpenXML

This page summarizes the projects mentioned and recommended in the original post on /r/csharp

Our great sponsors
  • InfluxDB - Power Real-Time Data Analytics at Scale
  • WorkOS - The modern identity platform for B2B SaaS
  • SaaSHub - Software Alternatives and Reviews
  • ClosedXML

    ClosedXML is a .NET library for reading, manipulating and writing Excel 2007+ (.xlsx, .xlsm) files. It aims to provide an intuitive and user-friendly interface to dealing with the underlying OpenXML API.

  • It's open-source: https://github.com/ClosedXML/ClosedXML

  • programmatically-manage-excel-spreadsheets-with-dotnet

    Sample code to create an Excel spreadsheet and manipulate data with dotnet

  • I created a sample CLI to create a spreadsheet to track daily electricity costs for demo purposes: https://github.com/Dev-Power/programmatically-manage-excel-spreadsheets-with-dotnet/tree/main

  • InfluxDB

    Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

    InfluxDB logo
  • ClosedXML.Report

    ClosedXML.Report is a tool for report generation with which you can easily export any data from your .NET classes to Excel using a XLSX-template.

  • Also shoutout to the report package for exporting classes to spreadhsheets. https://github.com/ClosedXML/ClosedXML.Report

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts