EPPlus | EPPlus | |
---|---|---|
8 | 16 | |
3,278 | 1,696 | |
- | 1.1% | |
1.5 | 9.5 | |
about 4 years ago | 1 day ago | |
C# | C# | |
GNU Lesser General Public License v3.0 only | GNU General Public License v3.0 or later |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
EPPlus
-
Automate Excel with only powershell?
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.
-
EPPlus Question
There is some additional samples at their old (abandoned) branch: https://github.com/JanKallman/EPPlus/tree/master/SampleApp
- Reading and writing Excel files (.NET Core & Azure)
-
QuestPDF 2022.9 - font fallback support, new Settings API, increased text rendering performance by 50%, reduced Garbage Collector overhead, quality-of-life improvements
Love this version: https://www.nuget.org/packages/EPPlus/4.5.3.3
-
Read uploaded excel file
EPPlus ExcelDataReader NPOI
-
Cannot figure out how to import jsons via power query and sort them into my custom column headers
For reading JSON -> e.g. ServiceStack.Text. For writing into Excel -> Use EPPlus library version 4.5.3.3. This is the last version of EPPlus under the LGPL License (aka free for commercial uses). You can install it using Nuget Package manager: Which library were you using for CSharp?
-
C# open source application for excel files editing
If you mean library, the older version of EPPlus is still available.
-
Excel csv file created is corrupted
My suggestion would be to avoid using Office Interop. When you use it, it creates a dependency on Office, meaning it has to be installed on the machine in order for your app to run. That's completely unnecessary and wasteful from licensing perspective. There are several packages on Nuget that allow you to work with Excel sheets without the need for Office to be loaded. A couple would be ClosedXML and EPPlus.
EPPlus
-
Automate Excel with only powershell?
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.
- Exporting ASPX values to an Excel Template
- Need help reading an excel file with c# epplus :)
-
EPPlus Question
Their documentation looks okay. I doubt you're going to get many people familiar with a specific library here.
-
I need a Data-Grid that I can copy/paste excel data with
If you're copypasting stuff from excel, another approach I used in a different project is this package: https://github.com/EPPlusSoftware/EPPlus - which works in Blazor. You'd just let users drag/drop or upload their excel and import it, instead of copypasting
- adding cell color in Excel file using c#
-
Kinda new to C#, could use some input.
There is one Excel Library that I would recommend using in C# and that EPPlus. Its great and its free for non-commercial use. The API is simple to use and its got great documentation.
- Exporting data to CSV
-
Does Microsoft have an official NuGet package to open and write to existing Excel Spreadsheets? (.Net 5)
There is a Getting Started section in GitHub and complete API documentation on the home page
-
Theres some way that i can make a .xlsx like this exporting data from a database using Windows Form ?
I've personally had a great experience working with EPPlus. It has both commercial and non-commercial/free licenses: https://epplussoftware.com/
What are some alternatives?
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.
Open XML SDK - Open XML SDK by Microsoft
ExcelDataReader - Lightweight and fast library written in C# for reading Microsoft Excel files
DocX - Fast and easy to use .NET library that creates or modifies Microsoft Word files without installing Word.
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.
Report-From-DocX-HTML-To-PDF-Converter - .NET Core library to create custom reports based on Word docx or HTML documents and convert to PDF
Dropbox.NET - The Official Dropbox API V2 SDK for .NET