Feeds:
Posts
Comments

Posts Tagged ‘.NET’

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.

 ExcelReference


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.

Advertisements

Read Full Post »