Posts Tagged ‘Excel’

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 →

Customizing built-in Office Ribbon groups – C# Excel add-in example

Customizing the built-in Microsoft Office ribbon groups is something that many people have tried but they usually hit a brick wall in the process. Unfortunately, it is not possible to customize the built-in ribbon groups, however, you can create your custom Office ribbon group and "replace" the built-in group with your own... Read the rest of this entry →

Video: Develop Office 2013 add-ins with Visual Studio 2012 Express

In this video, I show how to create an add-in for Microsoft Office 2013 Outlook, Excel and Word and add a custom ribbon using Add-in Express for Office and .net with Visual Studio Express 2012. Enjoy!... Read the rest of this entry →

Excel 2013 add-ins in Visual Studio 2012: Getting started for VSTO developers

In this article we'll have a look at how you, as a VSTO developer, can get started developing add-ins for Excel using Add-in Express and Visual Studio 2012.... Read the rest of this entry →

Range Selection in Excel add-ins – other good manners for developers

In my yesterday's article I started to muse on Excel's Range Selection and what can be considered good practices for Excel add-in developers. Well, there are some other good manners for the Range Selection. And if you have a closer look at the user interface of Microsoft Excel itself and some popular Excel add-ins, you will find out pretty convenient behavior of the Range Selection functionality like follows below... Read the rest of this entry →

Range Selection in Excel add-ins – good manners for developers

Having been fully absorbed in developing our frameworks for a while, I lost any connection with the other part of our business - ablebits.com. Doh, I shouldn't have allowed this to happen. I clearly realized that on last Saturday evening when, to the wailing of snow storm Xavier raging across this country, I installed the latest version of the Excel Ultimate Suite on my laptop... Read the rest of this entry →

Excel 2013 single document interface (SDI): How to rebuild your task panes to support it

If you're an avid user of Excel, you would've noticed that Excel 2013 has moved from being a Multi document interface (MDI) application to being a Single document interface (SDI) application... Read the rest of this entry →

Excel 2013 Timeline: creating data visualizations with VB.NET, C#

Now that Microsoft Office 2013 is available, it's time to start digging through the "What's New for Office Developers" topics. I'm not sure where these topics will take us because, with each release of Office, Microsoft touts the various new features and objects available to developers... Read the rest of this entry →

Creating a shared ribbon for Office 2013: Word, Excel and PowerPoint

In this article, I want to show you how can create single Microsoft Office 2013 and 2010 ribbon and share it with Excel, PowerPoint, and Word. This scenario is one of many where Add-in Express shines. Using the Add-in Express framework, you can easily build a shared ribbon in a matter of minutes. Best of all, you can also quickly configure your controls to display (or not to display) in the Office host applications your add-in targets... Read the rest of this entry →

How to create an Excel Content Pane App

Last we spoke, I was dealing with the limitations of the Apps for Office development model. This time, I played it straight and didn't try to exceed its limits. I thought life would be simple. I'd find a decent API to use for pulling in some data to Excel via a Content App. Simple right? ... Read the rest of this entry →

How to merge several Office add-in projects into one binary

Before we have a look at the sample project, let's first examine the scenario for when you might want to consider using this approach. In the case of the Ultimate Suite for Excel, loading was a crucial factor, by following this approach the team effectively reduced the loading time by nearly 60%, because only one assembly needs to be loaded instead of 20+ separate ones ... Read the rest of this entry →

How to develop an Excel Task Pane App

Instead of an article, this is more like a memoir... "Ty Anderson: An Apps for Office developer memoir". The new Apps for Office development model provides plenty of new possibilities for Microsoft Office developers. Although new, they give the appearance of familiarity. Do you think I'm crazy? ... Read the rest of this entry →

Creating WiX installation projects for VSTO-based Office add-ins

In the last two articles, I've shown you how to create a WiX installer for Add-in Express based add-ons from scratch and how to convert your existing setup projects to WiX. In this blog, I'll show you how to create a WiX installer for Visual Studio Tools for Office (VSTO) based Office add-in projects... Read the rest of this entry →

HowTo: Create add-ins for Office 2007, 2010 and 2013 with a shared ribbon tab

Office developers need to merge the UI of their add-ins into a single ribbon tab. Just imagine the following scenario: a user wants to install a few COM add-ins from the same vendor. Are they going to get a separate ribbon tab for each add-in's UI?... Read the rest of this entry →

Excel 2013 development – 7 questions developers should ask

Excel 2013 has plenty of new features. From Flash Fill to PowerPivot's native engine, from Quick Analysis to the WebService() function there is plenty to excite the user base. But for Excel developer's, the biggest news has to be the new Apps for Office extension framework... Read the rest of this entry →

Have any questions? Ask us right now!