Tag: MS Excel

How to implement auto-update for Office add-ins

How to implement auto-update for Office add-ins

Automatic updates for software applications’ mobile apps have become an everyday occurrence for most users. For a user it provides a level of comfort to know that their software is always up to date with the latest and greatest version. It could also be a source of irritation for many […]

Creating an Excel Stock Information RTD server using the Yahoo Finance API

Creating an Excel Stock Information RTD server using the Yahoo Finance API

Yahoo’s Query Language or YQL allows you to run SQL-like queries against a variety of web services. The amount of available web services are immense! To get a better idea of all the available services,   which services are on offer, and the type of data they return, have a look […]

Convert an Excel column number to a column name or letter

Convert an Excel column number to a column name or letter

Excel worksheet size has increased dramatically from Excel 2000 to Excel 2007. In fact, the number of rows an Excel 2013 worksheet can support has increased 16 times and the number of columns 64 times more than the number Excel 2000 could handle. Read more at Add-in Express. To see […]

How to properly release Excel COM objects

How to properly release Excel COM objects

You’ll see a lot of complaints on the internet about Excel and other Microsoft Office applications not quitting properly after using the object model to perform certain actions, or showing sporadic and unpredictable behavior in COM add-ins. In the end most of these issues boil down to developers not properly […]

Importing data from SQL databases and other sources to Microsoft 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 […]

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

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

When it comes to visualizing data nothing beats charts and there are only few applications that tie data and charts so well together as Microsoft Excel. Adding charts in your Excel add-ins using the Excel object model is easier than you might think. Read more at Add-in Express. To see […]

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

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 […]

Creating custom task panes for Excel 2013 – 2003

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. Let’s have a look at how you can use both of these approaches in your Microsoft Excel add-ins with […]

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

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 […]

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

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

So we’ve taken a look at how to get started with developing Office add-ins using Add-in Express when you have a Visual Studio Tool for Office (VSTO) background and How to create Outlook 2013 add-in in VS 2012. In this article we’ll have a look at how you, as a […]