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 →
.NET, COM add-ins, Excel, VBA |
6 Comments
Ty Anderson | November 26th, 2013
The WiX Designer provides a set of designers that allow to quickly configure a WiX-based setup project. The designers will be familiar to you as they do just what you expect (e.g. configure file system, add registry keys, edit file types, configure custom actions, and more)...
Read the rest of this entry →
WiX |
13 Comments
I'm sure by now you are all aware that Microsoft removed all Visual Studio Installer project types with the release of Visual Studio 2012. A suggested alternative to creating setup files was to use the very powerful and flexible WiX toolset. The one big problem, with switching over to WiX for your setup project was that, a lot of people already invested a considerable amount of time building a setup using the Visual Studio Installer project
...
Read the rest of this entry →
Deployment, Visual Studio, WiX |
14 Comments
Eugene Starostin | November 19th, 2013
Currently we are working on new major releases and minor updates of our frameworks and tools. Just yesterday, an intense debate sparked among our team over whether we should continue to support some aged IDEs, e.g. Visual Studio 2005 and Delphi 5...
Read the rest of this entry →
.NET, Delphi, Visual Studio |
32 Comments
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 →
.NET, C#, Excel, VB.NET |
21 Comments
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 →
.NET, COM add-ins, Excel, Visual Studio |
55 Comments
Ty Anderson | October 31st, 2013
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 →
.NET, COM add-ins, Excel |
12 Comments
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 →
C#, COM add-ins, Excel |
7 Comments
Ty Anderson | October 24th, 2013
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 →
.NET, COM add-ins, Excel, VB.NET |
12 Comments
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 →
C#, COM add-ins, Excel |
8 Comments
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 →
.NET, C#, COM add-ins, Excel |
21 Comments
Ty Anderson | October 9th, 2013
We've covered how to write code that automates Excel base objects. Today, I want to focus on the Excel workbook file and its worksheets. Let's take a look at how to perform some useful tasks with these two objects...
Read the rest of this entry →
|
13 Comments
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 →
.NET, C#, Excel, task panes |
10 Comments
Ty Anderson | October 2nd, 2013
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 →
.NET, COM add-ins, Excel, VB.NET |
No Comments
Ty Anderson | September 30th, 2013
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 →
.NET, COM add-ins, Excel, Visual Studio |
2 Comments
In my previous article we looked at some of the different types of UI kits, frameworks, bootstraps and boilerplates available to you as developer to start designing and creating a website quickly. We've also started to build an ASP.Net MVC website using the Foundation framework...
Read the rest of this entry →
ASP.NET |
No Comments