EPPlus
ExcelDna
Our great sponsors
EPPlus | ExcelDna | |
---|---|---|
8 | 11 | |
3,278 | 1,233 | |
- | 2.7% | |
1.5 | 8.6 | |
about 4 years ago | 6 days ago | |
C# | C# | |
GNU Lesser General Public License v3.0 only | zlib 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.
-
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.
ExcelDna
-
Excel Add-in
For Excel Add-In in c# i have good experience with ExcelDNA
-
Show HN: I've built a C# IDE, Runtime, and AppStore inside Excel
Does this use https://excel-dna.net/ behind the scenes?
-
Is there a more valuable alternative to VBA?
VBA is a fine language for many Excel tasks and is unlikely to go away any time soon. In terms of alternatives though you might consider the .NET family of languages F# and C# and VB.NET that are used across the software development industry. I am designing an addin that tightly integrates F# as a scripting language to replace many of the capabilities of VBA as well as providing easier access to external data sources. You can check it out at https://www.sharpcells.com If you need to customise the ribbon you could also look at https://excel-dna.net/ which allows you to work with any .NET language with more ability to customise Excel but is not as tightly integrated.
-
Issue with .tlb file in Excel
I would suggest to you to take a look into excel-dna, it's a pretty good project to build functions for excel. https://github.com/Excel-DNA/ExcelDna
-
Trying VSTO, what to expect?
ExcelDNA is an open source project that takes care of a lot of the complexity of the COM API and lets you use .Net for writing Excel Addins but not for other Office applications. Their latest versions should work with .Net 5+.
-
US Equity Index Options Pricing and Scenarios
Not sure why paying for a plug-in that lets you call python functions in excel is still a thing anymore when there’s pretty activity community that integrates excel with .NET. From there it’s easy to use python. https://excel-dna.net
- Trying to combine 2-3 documents sandwiched between 2 pages of an excel spreadsheet, but don't have access to Adobe Acrobat.
- Using C to Create Performant Excel Functions
-
Creating an Excel Add-In in D
Yeah, it's practically archaeology now! It is very fast for doing some things, though.
If anyone's interested in it from a Dot Net perspective, ExcelDNA [0] was excellent when I used it a few years ago.
[0] https://excel-dna.net/
What are some alternatives?
NPOI - a .NET library that can read/write Office formats without Microsoft Office installed. No COM+, no interop.
NetOffice - 🌌 Create add-ins and automation code for Microsoft Office applications.
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
DocX - Fast and easy to use .NET library that creates or modifies Microsoft Word files without installing Word.
ExcelDataReader - Lightweight and fast library written in C# for reading Microsoft Excel files
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