Up your coding game and discover issues early. SonarLint is a free plugin that helps you find & fix bugs and security issues from the moment you start writing code. Install from your favorite IDE marketplace today. Learn more →
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: Visual Studio C#: Is it possible to manipulate Excel file via Visual Studio | /r/VisualStudio | 2023-06-19Once installed, you can start using ClosedXML directly in your project. Go through their wiki for some sample codes based on what you are trying to achieve in your app.
-
Mergify
Updating dependencies is time-consuming.. Solutions like Dependabot or Renovate update but don't merge dependencies. You need to do it manually while it could be fully automated! Add a Merge Queue to your workflow and stop caring about PR management & merging. Try Mergify for free.
-
-
-
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.
-
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.
-
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
Collect and Analyze Billions of Data Points in Real Time. Manage all types of time series data in a single, purpose-built database. Run at any scale in any environment in the cloud, on-premises, or at the edge.
-
ExcelDna
Excel-DNA - Free and easy .NET for Excel. This repository contains the core Excel-DNA library.
For Excel Add-In in c# i have good experience with ExcelDNA
-
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.
Project mention: Debating how to integrate excel spreadsheets in a C# application | /r/csharp | 2023-03-22I have used the Reogrid library before for displaying excel sheets. It's not the most user friendly as some of the functionality has to be programmatically set up; but it's free & open-source.
-
-
-
Do you mean NetOffice?
-
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
-
BakingSheet
Easy datasheet management for C# and Unity. Supports Excel, Google Sheet, JSON and CSV format.
Project mention: I updated my Spreadsheet (Excel/Google Sheet) converter, now it supports scriptable object as output :D | /r/Unity3D | 2022-10-09 -
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.
Project mention: System.IO / File - Quick Question for updating file content | /r/csharp | 2023-03-04Maybe this one would give you some inspiration: https://github.com/morrisjdev/FileContextCore
-
Project mention: Today I learned that Range.Find() in the Excel interop library respects any filters the workbook was saved with and will not return results from filtered rows. | /r/csharp | 2023-03-10
I'm a fan of Sylvan.Data.Excel myself
-
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.
-
-
Project mention: LocalizationUE4 - open source tool for export and import your localizations to Excel files. Works with UE5 as well. | /r/unrealengine | 2022-12-19
-
-
SonarLint
Clean code begins in your IDE with SonarLint. Up your coding game and discover issues early. SonarLint is a free plugin that helps you find & fix bugs and security issues from the moment you start writing code. Install from your favorite IDE marketplace today.
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).
The latest post mention was on 2023-06-19.
C# Excel related posts
- Visual Studio C#: Is it possible to manipulate Excel file via Visual Studio
- Automate Excel with only powershell?
- Automatisches Auslesen von PDFs
- Library to easily retrieve data from multiple Api Providers.
- Hola, problema con un crud
- Is it possible to use Microsoft Word features programatically?
- Today I learned that Range.Find() in the Excel interop library respects any filters the workbook was saved with and will not return results from filtered rows.
-
A note from our sponsor - SonarLint
www.sonarlint.org | 26 Sep 2023
Index
What are some of the best open-source Excel projects in C#? This list will help you:
| Project | Stars | |
|---|---|---|
| 1 | NPOI | 5,218 |
| 2 | ClosedXML | 3,972 |
| 3 | ExcelDataReader | 3,573 |
| 4 | MiniExcel | 1,958 |
| 5 | Magicodes.IE | 1,937 |
| 6 | EvilClippy | 1,931 |
| 7 | EPPlus | 1,535 |
| 8 | ExcelDna | 1,115 |
| 9 | ReoGrid | 1,094 |
| 10 | Unity-QuickSheet | 984 |
| 11 | ExcelMapper | 641 |
| 12 | NetOffice | 629 |
| 13 | Npoi.Mapper | 539 |
| 14 | ClosedXML.Report | 455 |
| 15 | office-ribbonx-editor | 432 |
| 16 | BakingSheet | 223 |
| 17 | PowerQueryNet | 167 |
| 18 | FileContextCore | 161 |
| 19 | Sylvan.Data.Excel | 119 |
| 20 | BulkPDF | 112 |
| 21 | BookFx | 104 |
| 22 | LocalizationUE4 | 67 |
| 23 | JuliaInXL | 25 |
Clean code begins in your IDE with SonarLint
Up your coding game and discover issues early. SonarLint is a free plugin that helps you find & fix bugs and security issues from the moment you start writing code. Install from your favorite IDE marketplace today.
www.sonarlint.org