Posts Tagged ‘Excel’

Importing data from SQL databases and other sources to Microsoft Excel

A number of people I've met had no idea about one of Microsoft Excel's most powerful features. I'm talking about the ability to add data from external sources to your Excel sheet and manipulate it from there. Of course as a developer this can come in very handy when you want to provide your users with an intuitive and flexible way to access your data and empower them to create their own reports... Read the rest of this entry →

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 →

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 →

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 →

Have any questions? Ask us right now!