Posts Tagged ‘Excel’

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 - 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 →

Office UX guidelines for Excel 2013 content apps and Word 2013 task pane apps

My original plan for this article was to give you an overview of the new UX guidelines, but I’ve since decided to do a more hands on guide with some code thrown in for good measure. So strap on your web development helmets folks, it’s going to be a wild ride!... Read the rest of this entry →

How to customize context / right click menu of Excel 2013, 2010 and lower: C# sample

Right-click menus of Microsoft Office applications are a very convenient option for the end-user to interact with the host application. And for us, COM add-in developers, creating a custom menu for our users could be just a piece of cake... Read the rest of this entry →

Programming for Office 2010 on Windows 8 with Visual Studio 2012

If you've been following any IT related news lately you would've noticed that Microsoft has a number of new products and ideas up their sleeves. Last week we've seen their tablet offering, Microsoft Surface, announced. Windows 8 is close to release as well as Visual Studio 2012 and Office 2013 will be released in 2013... Read the rest of this entry →

Building integrated Excel extensions: COM Add-in, RTD Server and XLL in one C# project

Add-in Express for Office and .net makes building Microsoft Excel extensions easy. We provide you with a collection of tools and components to get that world-class Excel add-in out of the door and into the world in record time. ... Read the rest of this entry →

Video: Creating Excel add-in using C#, VB.NET

Excel is a popular target application for Office COM Add-ins and Add-in Express has the tools to empower you, the Excel add-in developer. In this relatively short video, we show you how our tools provide components and visual designers to help you quickly... Read the rest of this entry →

Creating Excel 2010, 2007 addin. Customizing Excel Ribbon: C#, VB.NET

In today's article we'll concentrate on the components and tools Add-in Express for Office and .net gives us when developing COM add-ins for Excel 2007 and Excel 2010... Read the rest of this entry →

Have any questions? Ask us right now!