C# Excel

Open-source C# projects categorized as Excel
Edit details
Topics: Office XLSX Word CSV Spreadsheet
The modern identity platform for B2B SaaS
The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.
workos.com
Sponsored

Top 23 C# Excel Projects

  • NPOI

    a .NET library that can read/write Office formats without Microsoft Office installed. No COM+, no interop.

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

    • Project mention: When XML in Word Became Illegal | news.ycombinator.com | 2023-10-12

    It's also country specific.

    I work on Excel library and the text to number/date feature was one of less fun things to implement at least semi-correctly.

    I remember my comment on the PR back then:

    https://github.com/ClosedXML/ClosedXML/pull/1899

  • WorkOS

    The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

    WorkOS logo

  • ExcelDataReader

    Lightweight and fast library written in C# for reading Microsoft Excel files

  • MiniExcel

    Fast, Low-Memory, Easy Excel .NET helper to import/export/template spreadsheet (support Linux, Mac)

  • EvilClippy

    A cross-platform assistant for creating malicious MS Office documents. Can hide VBA macros, stomp VBA code (via P-Code) and confuse macro analysis tools. Runs on Linux, OSX and Windows.

  • Magicodes.IE

    Import and export general library, support Dto import and export, template export, fancy export and dynamic export, support Excel, Csv, Word, Pdf and Html.

  • EPPlus

    EPPlus-Excel spreadsheets for .NET (by EPPlusSoftware)

    • Project mention: Automate Excel with only powershell? | /r/PowerShell | 2023-06-06

    Like others, I recommend using the ImportExcel module. It uses and wraps EPPlus Software (EPPlus - Create advanced Excel spreadsheets using .NET (GitHub Project Old / New)) which is a DLL that is included with the ImportExcel PowerShell Module.

  • 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

  • ReoGrid

    Fast and powerful .NET spreadsheet component, support data format, freeze, outline, formula calculation, chart, script execution and etc. Compatible with Excel 2007 (.xlsx) format and working on .NET 3.5 (or client profile), WPF and Android platform.

  • ExcelDna

    Excel-DNA - Free and easy .NET for Excel. This repository contains the core Excel-DNA library.

  • Unity-QuickSheet

    Unity-QuickSheet enables you to use spreadsheet file data within Unity editor.

  • ExcelMapper

    An Excel to object mapper. Maps POCOs to and from Excel. Configuration via convention, attributes, or fluent methods.

  • NetOffice

    🌌 Create add-ins and automation code for Microsoft Office applications.

  • sqlnotebook

    Casual data exploration in SQL

    • Project mention: Show HN: My Go SQLite driver did poorly on a benchmark, so I fixed it | news.ycombinator.com | 2023-12-14

    The meat of the P/Invoke code is in here: https://github.com/electroly/sqlnotebook/tree/master/src/Sql...

    The parent directory includes code that uses it. I'm most proud of this SQLite virtual table module that proxies queries to remote ADO.NET connections, allowing you to write joins directly between local SQLite tables and remote SQL Server tables. https://github.com/electroly/sqlnotebook/blob/master/src/Sql...

    I've also got a generic virtual table module that lets me easily write table-valued functions in C#: https://github.com/electroly/sqlnotebook/blob/master/src/Sql...

    The goal is to provide various "supercharged" features to base SQLite by taking advantage of all the extension points I can. I wish some went further; in particular the virtual table API doesn't "push down" enough of the original query to allow the module to avoid doing O(N+1) queries in some cases.

  • Npoi.Mapper

    Use this tool to import or export data with Excel file. The tool is a convention based mapper between strong typed object and Excel data via NPOI.

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

  • office-ribbonx-editor

    An overhauled fork of the original Custom UI Editor for Microsoft Office, built with WPF

    • Project mention: How can I distribute a VBA macro as an add in? | /r/vba | 2023-06-14

  • BakingSheet

    Easy datasheet management for C# and Unity. Supports Excel, Google Sheet, JSON and CSV format.

  • PowerQueryNet

    Run M Language (Power Query Formula Language) from anywhere.

    • Project mention: Library to easily retrieve data from multiple Api Providers. | /r/dotnet | 2023-04-30

    One of the things that I really like about the "M" formula language used in Power Query is the ability to functionally express such mappings, and a graphical environment for creating the expressions. Because your post got me curious about using M from C#, I did some Googling and found this: https://github.com/gsimardnet/PowerQueryNet. I sure the project would benefit from other developers/contributors.

  • FileContextCore

    FileContextCore is a "Database"-Provider for Entity Framework Core and adds the ability to store information in files instead of being limited to databases.

  • Sylvan.Data.Excel

    The fastest .NET library for reading Excel data files.

  • BulkPDF

    BulkPDF is a free and easy to use open source software, which allows to automatically fill an existing PDF form with differen values. Only a spreadsheet (Microsoft Excel 2007/2010/2013, LibreOffice or OpenOffice Calc) with the desired values is required.

  • BookFx

    Composing Excel spreadsheets based on a tree of nested components like the HTML DOM.

  • LocalizationUE4

    Translation Editor for Unreal Engine 4

  • SaaSHub

    SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

    SaaSHub logo
NOTE: The open source projects on this list are ordered by number of github stars. The number of mentions indicates repo mentiontions in the last 12 Months or since we started tracking (Dec 2020).

C# Excel related posts

Index

What are some of the best open-source Excel projects in C#? This list will help you:

Project Stars
1 NPOI 5,510
2 ClosedXML 4,407
3 ExcelDataReader 3,792
4 MiniExcel 2,387
5 EvilClippy 2,049
6 Magicodes.IE 2,035
7 EPPlus 1,687
8 ReoGrid 1,281
9 ExcelDna 1,233
10 Unity-QuickSheet 1,010
11 ExcelMapper 728
12 NetOffice 665
13 sqlnotebook 588
14 Npoi.Mapper 577
15 ClosedXML.Report 504
16 office-ribbonx-editor 456
17 BakingSheet 301
18 PowerQueryNet 175
19 FileContextCore 166
20 Sylvan.Data.Excel 164
21 BulkPDF 119
22 BookFx 105
23 LocalizationUE4 91

Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com