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, 2022 in Others by Kithuzzz
• 38,000 points
2,834 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, 2022 by narikkadan
• 63,600 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, 2022 in Others by narikkadan
• 63,600 points
1,290 views
0 votes
1 answer

Microsoft.Office.Interop.Excel for Office 2007

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

answered Nov 5, 2022 in Others by narikkadan
• 63,600 points
1,533 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, 2022 in Others by narikkadan
• 63,600 points
711 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, 2022 in Others by narikkadan
• 63,600 points
1,249 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, 2022 in Others by narikkadan
• 63,600 points
1,744 views
0 votes
1 answer

Unhide all Hidden Excel Columns Without Individual Iteration?

I discovered that the best way to ...READ MORE

answered Dec 16, 2022 in Others by narikkadan
• 63,600 points
952 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, 2022 in Others by Rahul
• 9,680 points
773 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, 2022 in Others by narikkadan
• 63,600 points
1,314 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, 2022 in Others by narikkadan
• 63,600 points
2,201 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