Page History

Accessing Excel using Visual Studio Tools for the Microsoft Office system

...

The first step is to create a reference in the project to the Excel x.x Object Library (the version number depends on the installed version of Microsoft Office). Right-click on the References folder in the Solution Explorer and choose Add Reference. Choose the COM tab and pick Microsoft Excel x.x Object Library (Figure 1).

Figure 1 Adding an Excel reference

...

using System;
using System.Windows.Forms;  
using org.OpenMI.Standard;
using orgOatc.OpenMI.Sdk.Backbone; 
using System.Diagnostics;
using orgOatc.OpenMI.Sdk.DevelopmentSupport;
using orgOatc.OpenMI.Tools.DataMonitor;
using System.Collections;
using System.Threading;
using System.Reflection;
using System.Runtime.InteropServices;
using Excel=Microsoft.Office.Interop.Excel;

...