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
a .NET library that can read/write Office formats without Microsoft Office installed. No COM+, no interop.Project mention: Hola, problema con un crud | /r/programacion | 2023-04-17
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-19
Once 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.
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.
Lightweight and fast library written in C# for reading Microsoft Excel filesProject mention: Use spreadsheet as data source? | /r/dotnet | 2023-02-11
Fast, Low-Memory, Easy Excel .NET helper to import/export/template spreadsheet
Import and export general library, support Dto import and export, template export, fancy export and dynamic export, support Excel, Csv, Word, Pdf and Html.
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.
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.
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.
Excel-DNA - Free and easy .NET for Excel. This repository contains the core Excel-DNA library.Project mention: Excel Add-in | /r/VisualStudio | 2023-03-05
For Excel Add-In in c# i have good experience with ExcelDNA
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-22
I 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.
Unity-QuickSheet enables you to use spreadsheet file data within Unity editor.
Map POCO objects to Excel files
🌌 Create add-ins and automation code for Microsoft Office applications.Project mention: C# Net6 - Convert XLS to XLSB - Open Source (Free) only. | /r/csharp | 2022-10-07
Do you mean NetOffice?
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 is a tool for report generation with which you can easily export any data from your .NET classes to Excel using a XLSX-template.
An overhauled fork of the original Custom UI Editor for Microsoft Office, built with WPFProject mention: How can I distribute a VBA macro as an add in? | /r/vba | 2023-06-14
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
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 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-04
Maybe this one would give you some inspiration: https://github.com/morrisjdev/FileContextCore
The fastest .NET library for reading Excel data files.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 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.
Composing Excel spreadsheets based on a tree of nested components like the HTML DOM.
Translation Editor for Unreal Engine 4Project mention: LocalizationUE4 - open source tool for export and import your localizations to Excel files. Works with UE5 as well. | /r/unrealengine | 2022-12-19
JuliaInXL C# code to create JuliaInXL plugin for Microsoft Excel
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.
C# Excel related posts
Visual Studio C#: Is it possible to manipulate Excel file via Visual Studio
2 projects | /r/VisualStudio | 19 Jun 2023
Automate Excel with only powershell?
3 projects | /r/PowerShell | 6 Jun 2023
Automatisches Auslesen von PDFs
2 projects | /r/de_EDV | 16 May 2023
Library to easily retrieve data from multiple Api Providers.
1 project | /r/dotnet | 30 Apr 2023
Hola, problema con un crud
1 project | /r/programacion | 17 Apr 2023
Is it possible to use Microsoft Word features programatically?
6 projects | /r/dotnet | 14 Apr 2023
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.
1 project | /r/csharp | 10 Mar 2023
A note from our sponsor - SonarLint
www.sonarlint.org | 26 Sep 2023
What are some of the best open-source Excel projects in C#? This list will help you: