ExcelDna
CSHARP_COM
Our great sponsors
| ExcelDna | CSHARP_COM | |
|---|---|---|
| 11 | 1 | |
| 1,233 | 1 | |
| 2.7% | - | |
| 8.6 | 10.0 | |
| 8 days ago | over 1 year ago | |
| C# | C# | |
| 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.
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/
CSHARP_COM
-
Issue with .tlb file in Excel
you need to specify Guids and use an interface.See https://github.com/peno64/CSHARP_COM for a com example project and called from excel.
What are some alternatives?
EPPlus
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.
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.
DocX - Fast and easy to use .NET library that creates or modifies Microsoft Word files without installing Word.
Open XML SDK - Open XML SDK by Microsoft
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
ExcelDna-Unpack - Command-line utility to extract the contents of Excel-DNA add-ins packed with ExcelDnaPack
ExcelDataReader - Lightweight and fast library written in C# for reading Microsoft Excel files
MiniExcel - Fast, Low-Memory, Easy Excel .NET helper to import/export/template spreadsheet (support Linux, Mac)
PureExcel - A lightweight excel parser
xll - Excel add-in library