Working with Excel tables & ranges: VB.NET code samples

Microsoft Excel, being a spreadsheet application, automatically brings structure to your thinking. You can build models to help you think through just about anything. You can organize your data and create lists of any imaginable type. In fact, most apps in the mobile app stores these days can easily be replaced by Excel files. Even games... Read the rest of this entry →

Working with Excel charts: how to change a chart style, color or type programmatically

Adding charts in your Excel add-ins using the Excel object model is easier than you might think. In this article we'll take a look at how to insert charts programmatically, format their style and colors as well as how to change the chart's display by filtering its data... Read the rest of this entry →

Working with Excel cell values, formulas and formatting: C# code samples

If you look at the title of this article, it almost sums up what Microsoft Excel is. Without cells, values and formulas, you just cannot get much done in Excel. Of course everything is contained within worksheets and workbooks and you can do so much more with Excel, but at the heart of it all lies cells... Read the rest of this entry →

Working with Excel workbooks and worksheets: VB.NET examples

We've covered how to write code that automates Excel base objects. Today, I want to focus on the Excel workbook file and its worksheets. Let's take a look at how to perform some useful tasks with these two objects... Read the rest of this entry →

Creating custom task panes for Excel 2013 – 2003

When building task panes for Microsoft Excel, Add-in Express provides developers with two options; using the standard Microsoft Office task pane or the more flexible Add-in Express advanced Office task panes... Read the rest of this entry →

Customizing Excel main menu, context menus, and Backstage view

Today we will tackle the issue of customizing Excel menus and back stage view. As you know, there are multiple versions of Excel "in-play" and it is wise to architect your solutions to work seamlessly with them. Add-in Express provides the tools, but it helps to know how to use them... Read the rest of this entry →

Customizing Microsoft Excel ribbons and toolbars

I think Excel's ribbon UI and toolbars are like a workbench, or set of tools. They are neatly arranged and reasonably grouped by task (although I know this is debatable). Today, we'll cover how to create custom ribbons and toolbars for Excel using Add-in Express for Office and .net... Read the rest of this entry →

Creating ASP.Net MVC websites using the Foundation Framework, part 2

In my previous article we looked at some of the different types of UI kits, frameworks, bootstraps and boilerplates available to you as developer to start designing and creating a website quickly. We've also started to build an ASP.Net MVC website using the Foundation framework... Read the rest of this entry →

Customizing the Excel User Interface: What is and isn’t customizable

Anytime Excel runs into a business process, users discover they require more of Excel. They can have more too by extending Excel via its API. Today, I'll cover what you user interface customizations are available to you when developing Excel add-ins with Add-in Express... Read the rest of this entry →

Excel add-in development in Visual Studio: Application and base objects

Today we start a new series to explain the basics (and more) of Excel add-in development. This is going to be serious fun because Excel rocks. Next to Outlook it might be the most popular target of Office add-ins... Read the rest of this entry →

Add-in Express for Office and Delphi VCL will support Delphi XE5 soon

You have probably read my announcement a few days ago that Add-in Express sim-ships with Visual Studio 2013. If you are a Delphi developer like me, I am happy to report good news to you too. The coming version of Add-in Express for Office and Delphi VCL will support Delphi XE5... Read the rest of this entry →

Create ASP.Net MVC websites: CSS UI Kits, frameworks, bootstraps and boilerplates

In this article, which will be the first in a series of articles, we'll dive into the various types of UI frameworks and begin to look at how you can start using the Foundation framework... Read the rest of this entry →

Add-in Express sim-ships with Visual Studio 2013

Good news for .NET developers! Add-in Express will ship simultaneously with the upcoming release of Visual Studio 2013... Read the rest of this entry →

Working with Microsoft Word templates: C# sample

This is a continuation of the work we did in my previous article. The difference is, we will use a pre-built template for inserting data. Instead of inserting data "willy-nilly", we need to find where to insert it within the document's pre-defined structure... Read the rest of this entry →

Populating Word documents with data from external sources (database, SharePoint, Outlook, etc.)

Today, I have three main C# code samples that insert data into Word. Each sample method creates and then goes to town inserting data. It is a simple strategy and works very well to get you started integrating data into Word... Read the rest of this entry →

Working with Word document properties, bookmarks, content controls and quick parts

Even though the object model can be somewhat daunting it gives you amazing flexibility and power over programmatically bending MS Word to your will. In today's article we'll have a look at the Microsoft Word document properties, content controls, quick parts and bookmarks, and how you can access and use these objects in your own add-ins... Read the rest of this entry →

Have any questions? Ask us right now!