ExcelDna
Open XML SDK
Our great sponsors
ExcelDna | Open XML SDK | |
---|---|---|
11 | 23 | |
1,233 | 3,869 | |
2.7% | 1.6% | |
8.6 | 9.1 | |
8 days ago | 5 days ago | |
C# | C# | |
zlib License | 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.
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/
Open XML SDK
-
Libcurl
While it doesn't appear to have been updated in many years, Microsoft built a similarly useful tool[1] that lets you browse the structure of a given Office document and see C# code that generates various components of it.
[1] https://github.com/dotnet/Open-XML-SDK/releases/tag/v2.5
-
Is it possible to use Microsoft Word features programatically?
If you use this check out the productivity tool, it will convert a word doc to csharp for you. https://github.com/dotnet/Open-XML-SDK/releases/tag/v2.5
-
Go library that supports extraction and generation of word documents with complex formulae, equations, tables and images.
You’re looking for OpenXML handling. C# probably has the best support, since there’s a Microsoft supported SDK - https://github.com/dotnet/Open-XML-SDK
-
If you had to pick a library from another language (Rust, JS, etc.) that isn’t currently available in Python and have it instantly converted into Python for you to use, what would it be?
https://github.com/dotnet/Open-XML-SDK Yeah, it can be kind of wrapped with pythonnet and stuff. But having it totally pyhtonized would be sooooo great.
- Creating a Web App using Excel
-
Count lines, words, and characters of a MS Word file? ( i.e. Test1.docx )
As an alternative, you could use the Powershell module Open-XML-SDK or PSwriteWord, or PSWriteOffice
-
OpenXml throws a different exception given identical code and similar build configuration for two distinct solutions. Why?
PackageLoader was introduced in https://github.com/OfficeDev/Open-XML-SDK/commit/522200f65b9182f65a112130f830403467f54936
-
Programatically replacing text in docx
In the official GitHub repository you will find similar tools listed, if you have a very particular requirement not fulfilled by OpenXML SDK.
-
Formatting issues from Mac to Windows
Or alternatively you can create a .NET application using the Open XML SDK that does the same thing.
-
Launch HN: Windmill (YC S22) – Turn scripts into internal apps and workflows
This looks amazing and I'd love to try it out for this one thing I have in mind.
I'm not familiar with the Deno part of Typescript. Would it somehow be possible to use a C# library as a dependency?
For example https://github.com/OfficeDev/Open-XML-SDK I need for a way to edit (not create) the openXML content of Microsoft Office files
What are some alternatives?
EPPlus
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.
NetOffice - 🌌 Create add-ins and automation code for Microsoft Office applications.
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.
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