Posts Tagged ‘Excel’

Localization of Office add-ins using forms-based resources

The article describes how to create a localized version of an Office add-in by using regular forms-based resources without having to apply them manually to each component, form or control... Read the rest of this entry →

How to customize the appearance of advanced task panes and Outlook regions

Starting with version 8.2, Add-in Express began to open its internal infrastructure, which allows developers to customize some areas of advanced Excel, Word and PowerPoint task panes and Outlook regions. In the new release, it becomes possible to customize the header together with its controls as well as splitter and border. You can also modify the appearance of a minimized region, control the header visibility, change padding, get HitTest info and more... Read the rest of this entry →

Office 365 API – Querying Exchange

Today, we'll investigate how to retrieve data such as contacts, calendar entries and e-mails from Exchange. We'll create a simple Excel add-in, using our favourite Office development toolset, Add-in Express for Office and .net, which will import Exchange e-mails, contacts and calendar events into the active Excel workbook... Read the rest of this entry →

Office context menu add-in for Excel, Outlook, Word, PowerPoint

The blog is about an add-in (with the source code) that adds a button to all context menus of Excel, Outlook, PowerPoint, Project, Publisher, Visio and Word in Office 2010-2013. The button shows the name of the context menu.... Read the rest of this entry →

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

In today's article, we'll write an Excel RTD server that returns the latest stock prices and other information. In case you're not familiar with Excel RTD servers, it is used to communicate with a real-time data source, such as stock quotes and provide the user with a constant flow of changing data... Read the rest of this entry →

Excel Online & Google Sheets for developers – what’s the difference?

In the last few weeks we've covered a lot of aspects of both Google Sheets and Excel Online and we've seen that both platforms offer developers various options to customize and integrate with. In this article we'll evaluate what we've learned so far about Google Sheets and Excel Online and compare the two platforms and what it means for developers ... Read the rest of this entry →

Google add-ons vs Microsoft Office Apps: Read/Write tests

We've been spending a lot of time with the Office/Productivity offerings from Google (Google Drive/Docs/Sheets) and Microsoft (Office 365, SharePoint, Word, Excel) and both of these two platforms have some drawbacks, but also some redeeming factors... Read the rest of this entry →

How to create Excel Apps for Office 365

About a week ago we explored the aspects of extending Google Spreadsheets by creating Apps scripts. In that example, we created a sidebar and custom menus with which the user could specify the orientation their current selection could be changed to. In today's article, we'll attempt the same functionality, but this time using the Napa development tools for Office 365. ... Read the rest of this entry →

Create a status report generator using Excel and Outlook: C# sample

Today, I'll show you how to create a status report using Excel and Outlook. This add-in sample will run within Excel. The user will have a button to click that starts the report process. Instead of creating a new workbook or worksheet, the add-in will insert the task status report into the existing spreadsheet... Read the rest of this entry →

How to import contacts and appointments from Excel into Outlook and vice-versa

Importing contacts and appointments into Microsoft Outlook is a feature that has existed in Outlook for a while. In Outlook 2013 you can find the Import/Export function in the File or Backstage view menu, under Open & Export... Read the rest of this entry →

How to find the last used cell (row or column) in Excel

VB.NET code samples explain some reliable methods for finding the last used cell in an Excel worksheet or a range.... Read the rest of this entry →

Populating Excel workbooks and ranges with arrays

Microsoft Excel, with its almost endless supply of rows and columns, is data DisneyLand. It's fun to work with data and make it easy to consume. Part of the fun, at least for developers, is populating Excel with data. Today, I want to take another look at how to use arrays to populate Excel with data... Read the rest of this entry →

How to use Excel VBA macros and COM add-ins in one solution

The Microsoft Excel Office Object model is a varied and very mature framework and allows you to not only create VBA macros and functions but also COM add-ins. Of course creating these add-ins is made even simpler with the help of Add-in Express... Read the rest of this entry →

Convert an Excel column number to a column name or letter: C# and VB.NET examples

There are a lot of examples floating around on the internet on how to convert Excel column numbers to alphabetical characters. There are a few ways to get the column letter, using either vanilla C# or VB.NET, Excel formulas or the Excel object model. Let's take a look at some of the solutions... Read the rest of this entry →

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 disposing of COM objects... Read the rest of this entry →

Working with Excel pivot tables: VB.NET code examples

Today, I'll show-off some code that shows how to automate pivot tables. It's quite likely your user base is 100% comprised of uber-serious spreadsheet jockeys. These people need your help. This code will help you relate to them and make their life easier... Read the rest of this entry →

Have any questions? Ask us right now!