Yes it is, but first of all you have to download the office primary interop assemblies before, here two links
If you work with Office 2003 Click here
If you work with Office 2007 Click here
The last one is updated so it works with both 2003/2007
To install them follow the instructions

To install Office primary interop assemblies

In Control Panel, choose Add or Remove Programs.
Select Microsoft Office in the Currently installed programs list.
Click Change.
Select Add or Remove Features, and then click Next.
Select Choose advanced customization of applications, and then click Next.
Expand Microsoft Office Excel, click the box next to .NET Programmability Support, and then click Run from My Computer.
Expand Microsoft Office Outlook, click the box next to .NET Programmability Support, and then click Run from My Computer.
Expand Microsoft Office Word, click the box next to .NET Programmability Support, and then click Run from My Computer.
Expand Office Tools, click the box next to Microsoft Forms 2.0 .NET Programmability Support, and then click Run from My Computer.
Under Office Tools, click the box next to Smart Tag .NET Programmability Support, and then click Run from My Computer.
Under Office Tools, expand Microsoft Graph, click the box next to .NET Programmability Support, and then click Run from My Computer.
Follow the same procedure to install primary interop assemblies for any other Office applications you want.
Click Update.

The primary interop assemblies are installed in the global assembly cache.

You should include the Microsot.Office.interop.Excel

using Microsoft.Office.interop.Excel; // for C#

Imports Microsoft.Office.interop.Excel // for VB.NET

to create a workbook use this code

Excel.workbook myWorkbook = this.Application.workbooks.add();

To open an exisitng workbook

this.Application.workbooks.Open(filename);

To close a workbook

this.Application.workbooks.Close(filename);

To save an already existing workbook

this.Application.workbooks.Save(filename);

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

santhosh18y ago
thank u .......
0
Bechir Bejaoui18y ago
Yes it is, but first of all you have to download the office primary interop assemblies before, here two links
If you work with Office 2003 Click here
If you work with Office 2007 Click here
The last one is updated so it works with both 2003/2007
To install them follow the instructions
To install Office primary interop assemblies

In Control Panel, choose Add or Remove Programs.

Select Microsoft Office in the Currently installed programs list.

Click Change.

Select Add or Remove Features, and then click Next.

Select Choose advanced customization of applications, and then click Next.

Expand Microsoft Office Excel, click the box next to .NET Programmability Support, and then click Run from My Computer.

Expand Microsoft Office Outlook, click the box next to .NET Programmability Support, and then click Run from My Computer.

Expand Microsoft Office Word, click the box next to .NET Programmability Support, and then click Run from My Computer.

Expand Office Tools, click the box next to Microsoft Forms 2.0 .NET Programmability Support, and then click Run from My Computer.

Under Office Tools, click the box next to Smart Tag .NET Programmability Support, and then click Run from My Computer.

Under Office Tools, expand Microsoft Graph, click the box next to .NET Programmability Support, and then click Run from My Computer.

Follow the same procedure to install primary interop assemblies for any other Office applications you want.

Click Update.

The primary interop assemblies are installed in the global assembly cache.
You should include the Microsot.Office.interop.Excel
using Microsoft.Office.interop.Excel; // for C#
Imports Microsoft.Office.interop.Excel // for VB.NET
to create a workbook use this code
Excel.workbook myWorkbook = this.Application.workbooks.add();
To open an exisitng workbook
this.Application.workbooks.Open(filename);
To close a workbook
this.Application.workbooks.Close(filename);
To save an already existing workbook
this.Application.workbooks.Save(filename);
0

how to create excel workbook project in visual studio 2005

To install Office primary interop assemblies