Read .xls, .xlsx files using interop and import to datatable

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
  • Open XML SDK

    Open XML SDK by Microsoft

  • XLSX format has a lot of good libraries like ClosedXML that are entirely C#-based, and based on Microsoft implementation of XLSX standard.

  • Sylvan.Data.Excel

    The fastest .NET library for reading Excel data files.

  • I maintain a library that you can try: Sylvan.Data.Excel.

  • 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
  • CsvBenchmarks

    Benchmarks for various .NET libraries.

  • It provides a forward only data reader (DbDataReader) for all common excel formats (.xlsx, .xlsb, and .xls). It is the fastest and lowest allocating Excel reader in the .NET ecosystem.

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