You know that little "Merge and Center" button in Microsoft Excel? Here's how to 'click' it in C# with Excel Interop (and this carries over to VB etc, too).

.NET

MS-Excel

interop

Excel Interop, Subscripts and Superscripts

17 Aug 2017 by Dennis Wu CA

A demo that generates a simple Excel spreadsheet with subscripts and superscripts

How to Release COM Interop Objects so the Called Program Can Exit

13 Nov 2013 by Mike Meinz

The COM Interop Runtime Callable Wrapper (RCW) is a "Black Box" that creates references to memory that need to be released before the called program will end.

How to Check Whether Word is Installed in the System or Not

29 Nov 2013 by Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

After the tip on Excel, here we will explore the trick to verify whether Word is installed in the client's system or not by C#.

Call a C# Method From JavaScript Hosted in a WebBrowser

6 May 2011 by AspDotNetDev

This demonstrates how you can call a C# method in a Windows Forms application from JavaScript that is hosted in a webpage inside a WebBrowser control on your form.

How to Convert Excel to CSV using Interop

19 Nov 2013 by Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

This simple Tip will give you the Trick to convert Excel file to CSV file using Interop Services.

How to Check Whether Outlook is Installed in the System or Not

5 Dec 2013 by Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

After the tip on Excel, Word and Powerpoint, here we will explore the trick to verify whether Outlook is installed in the client's system or not by C#.

Get rid of COM Interop DLL by using the new C# 4 dynamic keyword

7 Jan 2011 by Philippe Bouteleux

How to instantiate a COM object wrapper and call a method at runtime

C#4.0

COM

interop

Edit Word Documents using OpenXML and C# Without Automation/Interop

28 May 2015 by koolprasad2003

This tip explains how to use Word Automation using OpenXML and C# without Word Interop.

Inserting an Image into an "inline shape" in Word Document using Microsoft Open XML SDK

21 Jun 2017 by Dankwansere

How to insert an image into an "inline shape" in Word Document using Microsoft Open XML SDK

Releasing Excel after using Interop

23 Mar 2011 by Igor Merabishvili

A small tip how to release Excel object after using Interop

MS-Excel

interop

Handling Excel Lists with Interop

29 Sep 2015 by HP2M

This tip covers handling two Excel lists using Interop.

Migrating Legacy Microsoft Access Database to Excel (or any other database) - Complete Application and Code

1 Jun 2020 by rohitsies

Helps migrate your Microsoft Access database to Excel

Import a CSV File Into an Excel Workbook Programmatically

19 Dec 2010 by Brian C Hart

Code to call Excel Interop to take a Comma-Separated-Values (.CSV) file and suck it into your Excel workbook programmatically, and then Auto-Fit the resultant columns.

MS-Excel

interop

Generate Excel Chart from Data in .NET Applications

3 Dec 2013 by LazyCoder0

This tip describes how to generate Excel charts from data in .NET applications using Office Automation.

Releasing Excel after using Interop

22 Mar 2011 by Klaus Luedenscheidt

Alternatively, you can kill the Excel instance. I have to maintain an application which makes heavy use of Excel. I have written a wrapper for the base functionality. In the Dispose() method of the wrapper, I use the following code to ensure Excel will be released:mExcelApp.Quit(); // My...

MS-Excel

interop

Create an Excel spreadsheet from Datatable

13 Jul 2016 by Jerry Burch

Quickly create a spreadsheet from Datatable using Interop and the Clipboard