How to reference Microsoft Office Interop Excel dll

0 votes

Using MS Visual Studio 2005, I created an Excel-related solution in 2006. With MS Visual Studio 2012, I can no longer utilize the same reference.

var app = new Microsoft.Office.Interop.Excel.Application();
Workbooks wbs = app.Workbooks;
Oct 9 in Others by Kithuzzz
• 20,660 points
167 views

1 answer to this question.

0 votes

Use NuGet (VS 2013+):

The NuGet package manager is the simplest method in any modern version of Visual Studio. (Even VS2013, with the NuGet Package Manager for Visual Studio 2013 extension.) 

Right-click on "References" and choose "Manage NuGet Packages...", then just search for Excel.

enter image description here

answered Oct 9 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
1 answer

How To Use VBA To Share Excel File With Fellow Office User?

PowerApps were referenced; if you have a ...READ MORE

answered Oct 28 in Others by narikkadan
• 37,660 points
51 views
0 votes
1 answer

Microsoft.Office.Interop.Excel for Office 2007

Each client must install the  2007 Microsoft ...READ MORE

answered Nov 5 in Others by narikkadan
• 37,660 points
73 views
0 votes
1 answer

How to fix a circular reference error by if condition in excel file?

Circular reference in this context refers to ...READ MORE

answered Nov 21 in Others by narikkadan
• 37,660 points
28 views
0 votes
1 answer

How to open an Excel file in C#?

You must have Microsoft Visual Studio Tools ...READ MORE

answered Nov 13 in Others by narikkadan
• 37,660 points
47 views
0 votes
1 answer

How do I get an Excel range using row and column numbers in VSTO / C#?

Use: int countRows = xlWorkSheetData.UsedRange.Rows.Count; int countColumns = xlWorkSheetData.UsedRange.Columns.Count; object[,] ...READ MORE

answered Nov 17 in Others by narikkadan
• 37,660 points
41 views
0 votes
1 answer

can somebody explain me what does "passing by value" and "Passing by reference" mean in C#?

To answer your question, “passing by value” ...READ MORE

answered Feb 10 in Others by Rahul
• 9,680 points
183 views
0 votes
1 answer

Generate a flat list of all excel cell formulas

Hello, you'll have to follow certain steps ...READ MORE

answered Feb 18 in Others by gaurav
• 22,040 points
80 views
0 votes
1 answer

How to Import Excel Worksheet into Microsoft Project?

Solution: Wizard's preliminary settings: New map As a new project Tasks, ...READ MORE

answered Oct 14 in Others by narikkadan
• 37,660 points
59 views
0 votes
1 answer

'Microsoft.Office.Interop.Excel.Range' does not contain a definition for 'get_Default'

You are using C# version 4, the ...READ MORE

answered Oct 16 in Others by narikkadan
• 37,660 points
186 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP