EPPlus
ClosedXML
Our great sponsors
EPPlus | ClosedXML | |
---|---|---|
16 | 26 | |
1,678 | 4,332 | |
2.2% | 2.7% | |
9.5 | 9.5 | |
1 day ago | 19 days ago | |
C# | C# | |
GNU General Public License v3.0 or later | MIT License |
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.
- Exporting ASPX values to an Excel Template
-
EPPlus Question
Their documentation looks okay. I doubt you're going to get many people familiar with a specific library here.
This wiki also contains some useful info (see the links at the right side of the page): https://github.com/EPPlusSoftware/EPPlus/wiki
-
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
-
why c# don't have obfuscate as default?
Suppose it depends on how rampant you expect such piracy/theft would be for what you're making. In practice, I'm not sure how widespread decompilation and code theft is in the .NET world. Hell, many companies/individuals sell licenses of their libraries and publish it open source for non-commercial use. For example, EPPlus is a widely used Excel library that you purchase licenses for and they have it available open source for non-commercial use.
ClosedXML
-
When XML in Word Became Illegal
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:
-
Visual Studio C#: Is it possible to manipulate Excel file via Visual Studio
It should be possible. Check out the ClosedXML library as a starting point.
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.
-
Any tips on converting a XLSX file to HTML without using a licensed library?
Time to dig into those open xml docs. Honestly it’s not that bad once you get your bearings. ClosedXML offers a somewhat thin wrapper as well. I’ve used these with great success but they are quite low level.
- I need a Data-Grid that I can copy/paste excel data with
-
adding cell color in Excel file using c#
ClosedXML is an open wrapper around OOXML.
- How do I get Excel column data type with OpenXml?
-
Discovered a NuGet package called ClosedXML. Takes away the pain of dealing with OpenXML
It's open-source: https://github.com/ClosedXML/ClosedXML
-
cannot create an instance of the abstract type or interface. how to solve this ???
If you are trying to *create* Excel files, then you might take a look at [NPOI](https://github.com/nissl-lab/npoi) which is also open source with a permissive license. There is also [ClosedXml](https://github.com/ClosedXML/ClosedXML), which has these capabilities.
- Dot net libraries/tools that are usefull in many projects
What are some alternatives?
Open XML SDK - Open XML SDK by Microsoft
EPPlus
NPOI - a .NET library that can read/write Office formats without Microsoft Office installed. No COM+, no interop.
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.
MiniExcel - Fast, Low-Memory, Easy Excel .NET helper to import/export/template spreadsheet (support Linux, Mac)
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
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.
ExcelDna - Excel-DNA - Free and easy .NET for Excel. This repository contains the core Excel-DNA library.
PureExcel - A lightweight excel parser