NetOffice.Excel – Add Validation to a Cell

My most recent blogs have been focused on Excel-DNA, and the pretty cool ability it brings to easily add your own custom ribbons.  This blog is looking at the other component of writing a C# app that can talk to Excel – namely NetOffice.Excel. NetOffice.Excel provides the ability to interact with Excel COM elements, inContinue reading “NetOffice.Excel – Add Validation to a Cell”

Custom Icons in Excel-DNA Custom Ribbon

When adding options to your menu, you’ll need icons.  There are about 9,000 already available icons (yikes!), so you’ll probably find one that is suitable and is consistent with the UX of Excel.  You can also add custom icons.  As always code is available on my bit bucket account:…CustomImage Built-in icons You can addContinue reading “Custom Icons in Excel-DNA Custom Ribbon”

My First Custom Excel Ribbon using Excel-DNA

In this blog I give a tutorial on getting started with Excel-DNA, a project to build excel add-ins using .NET. By the end you will have a new custom tab in your excel ribbon that contains a button. I will also show you how to debug this excel plugin by running the project directly from Visual Studio