Posts Tagged ‘Visual Studio .NET IDE’

In your Visual Studio IDE go to the projects (at the top) -> add references -> com (tab) -> add the Microsoft Excel library installed.


Or you can use the project explorer.

Right click on the references-> add references -> com (tab) -> add the library.


Please refer to the image below.


Then simply what you need to do is Import the Excel.

Imports Microsoft.Office.Interop.Excel for VB

using Microsoft.Office.Interop;              for C#


The “Microsoft Excel X Object Library” where X will depend on whatever version of Excel you have in the computer.
So the X depends on which version of Excel is installed on your machine.


Read Full Post »