ExcelDna
ImportExcel
Our great sponsors
| ExcelDna | ImportExcel | |
|---|---|---|
| 11 | 98 | |
| 1,233 | 2,361 | |
| 2.7% | - | |
| 8.6 | 5.3 | |
| 8 days ago | 12 days ago | |
| C# | PowerShell | |
| zlib License | Apache License 2.0 |
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/
ImportExcel
- Show HN: Query Your Sheets with SheetSQL
-
Is there a function similar to VLOOKUP in Excel?
Examples here that are similar to what you are trying to accomplish - https://github.com/dfinke/ImportExcel
- Automate Excel with only powershell?
-
PS Module "ImportExcel" - Output is faulty
Did you visit the GitHub repo and read the docs & examples? https://github.com/dfinke/ImportExcel
-
ImportExcel and conditional formatting inconsistancies
If you can create a reproducible example with sample data and code that re-creates the issue from nothing, post it to the project's issues on Github. The module's authors have been very quick to resolve the issues I've had, usually fixing the problem in a week or two.
- How do I ingest data from a daily CSV report into a 'main' report?
-
Create multiple tables from a single table based on a column?
If you're using scripting, I have to recommend ImportExcel for Powershell.
-
update csv cell without new export
You might be able to use https://github.com/dfinke/ImportExcel to alter single cells in a csv file but I'm not 100% sure.
-
PowerShell Export-Excel Pivot Table Issue
Have you looked at the examples? Examples
-
Powershell & MSWord: Pulling AD Information and making it look “nice”?
Maybe look at ImportExcel, it allows to put any list of objects right into Excel sheets, with insane customization capabilities.
What are some alternatives?
EPPlus
PSWriteHTML - PSWriteHTML is PowerShell Module to generate beautiful HTML reports, pages, emails without any knowledge of HTML, CSS or JavaScript. To get started basics PowerShell knowledge is required.
NetOffice - 🌌 Create add-ins and automation code for Microsoft Office applications.
sqlite-utils - Python CLI utility and library for manipulating SQLite databases
NPOI - a .NET library that can read/write Office formats without Microsoft Office installed. No COM+, no interop.
WinPython - A free Python-distribution for Windows platform, including prebuilt packages for Scientific Python.
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.
psPAS - PowerShell module for CyberArk Privileged Access Security REST API
DocX - Fast and easy to use .NET library that creates or modifies Microsoft Word files without installing Word.
PoshBot - Powershell-based bot framework
Open XML SDK - Open XML SDK by Microsoft
PSScriptAnalyzer - Download ScriptAnalyzer from PowerShellGallery