ExcelDna
xll
Our great sponsors
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/
xll
-
Python GUIs
My guilty secret is to use Excel for my quick and dirty GUIs. I wrote a library to make that easy if you know C++. https://github.com/xlladdins/xll.
-
Show HN: I've built a C# IDE, Runtime, and AppStore inside Excel
Please tell Satya to show the ancient C SDK a little love. I'd hate to see this disappear: https://github.com/xlladdins/xll#fp-data-type
-
snitch v1.0 -- A lightweight C++20 testing framework
If you want to throw an exception instead of calling `abort` you can use https://github.com/xlladdins/xll/blob/master/xll/ensure.h When running in a debugger it can break execution when it fails and you can inspect the values of relevant variables.
-
I used C++ to embed sqlite into Excel
xll appears to be MIT according to the nuspec. xll_sqlite doesn't have a license, so the author hasn't given anybody to use it.
-
What are the best uses of C++?
Excel. C++ can be embedded in Excel and used interacively. It is more useful than old-fashioned python programming. I wrote something that makes this easy; https://github.com/xlladdins/xll
-
C Compiler Which Targets Excel (MS Office)
This is quite clever, and probably a joke that I'm not getting, but the Excel C SDK lets you call C/C++ from Excel and vice versa. This is one of my bread and butter tools, and I like nice tools, so I wrote a C++ wrapper around the SDK. It also lets you embed C++ objects in Excel: https://github.com/xlladdins/xll
-
What's the coolest thing you've created with c++?
A C++ library that lets you embed C++ objects in Excel. https://github.com/xlladdins/xll.
-
Creating an Excel Add-In in D
Welcome to my world: https://github.com/xlladdins/xll
What are some alternatives?
EPPlus
JetStory2018 - Source code for JetStory2018 game
NetOffice - 🌌 Create add-ins and automation code for Microsoft Office applications.
vulkan-guide - Introductory guide to vulkan.
NPOI - a .NET library that can read/write Office formats without Microsoft Office installed. No COM+, no interop.
hyperformula - HyperFormula is an open-source headless spreadsheet for business web apps. It comes with over 400 formulas, CRUD operations, undo-redo, clipboard support, and sorting. Built in TypeScript, supported by the Handsontable Team.
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.
Notes-To-WAV-converter - A program that converts musical notes stored in a text file into WAV files. I know this is not a good Git repository.
DocX - Fast and easy to use .NET library that creates or modifies Microsoft Word files without installing Word.
liblcl - A common cross-platform GUI library, the core uses Lazarus LCL.
Open XML SDK - Open XML SDK by Microsoft
CIDLib - The CIDLib general purpose C++ development environment