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, in…… Continue reading NetOffice.Excel – Add Validation to a Cell
Author: andysprague44
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: https://bitbucket.org/andysprague44/excel-dna-examples/…CustomImage Built-in icons You can add…… Continue reading Custom Icons in Excel-DNA Custom Ribbon
Show Message Boxes with Excel-DNA
Often a simple way to get user feedback is to show a pop-up message box. Read on for a tutorial on how to do this. As an example, this is the result we will get from this blog: The second section of this blog deals with how to handle message boxes during asynchronous operations,…… Continue reading Show Message Boxes with Excel-DNA
Excel-DNA Custom Ribbon Cheat Sheet
In this blog I’ll give some helpful snippets of code to work with Custom Ribbons in Excel-DNA. I will assume you have already got a project that creates a custom ribbon, and you now want my amazing insight on how to add something that is more elaborate than, say, a button that writes a hard-coded…… Continue reading Excel-DNA Custom Ribbon Cheat Sheet
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
My First Blog
It’s not a long one. Just to say welcome to my site. Hope you enjoy coding and can at least stomach rugby, else you may be in for a long ride (actually, I’d advise just surfing off somewhere else if that’s the case)
