You need to have installed Microsoft Visual Studio Tools for Office (VSTO).
VSTO can be selected in the Visual Studio installer under Workloads > Web & Cloud > Office/SharePoint Development.
After that create a generic .NET project and add a reference to Microsoft.Office.Interop.Excel via ‘Add Reference… > Assemblies’ dialog.
Application excel = new Application(); Workbook wb = excel.Workbooks.Open(path);
Missing.Value is a special reflection struct for unnecessary parameters replacement
In newer versions, the assembly reference required is called Microsoft Excel 16.0 Object Library. If you do not have the latest version installed you might have Microsoft Excel 15.0 Object Library, or an older version, but it is the same process to include.
Related Posts:
- What is a singleton in C#?
- ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine
- My C# application is returning 0xE0434352 to Windows Task Scheduler but it is not crashing
- C# Set collection?
- Why is Dictionary preferred over Hashtable in C#?
- Does anyone still use [goto] in C# and if so why?
- How does the “Using” statement translate from C# to VB?
- What is the best way to parse html in C#? [closed]
- Best C# API to create PDF
- C# cannot convert method to non delegate type
- What is the difference between const and readonly in C#?
- Pass Method as Parameter using C#
- ArrayList vs List<> in C#
- What’s the @ in front of a string in C#?
- How to solve ‘…is a ‘type’, which is not valid in the given context’? (C#)
- Calling the base constructor in C#
- Best way to repeat a character in C#
- How to empty a list in C#?
- What is a method group in C#?
- How do I save a stream to a file in C#?
- Print Pdf in C#
- Can a Byte[] Array be written to a file in C#?
- What is the difference between String and string in C#?
- Creating a List of Lists in C#
- C# int to byte[]
- .Net 4.8 Support for Windows 10 ends in 26 days?
- What is a NullReferenceException, and how do I fix it?
- How do I get a random YouTube video with the YouTube API?
- An existing connection was forcibly closed by the remote host
- How can I convert String to Int?
- What is a NullReferenceException, and how do I fix it?
- I am getting Failed to load resource: net::ERR_BLOCKED_BY_CLIENT with Google chrome
- What’s the difference between .NET Core, .NET Framework, and Xamarin?
- Could not load file or assembly or one of its dependencies
- Error : Could not load file or assembly or one of it’s dependencies
- What is WCF? and what can it do?
- Priority queue in .Net
- What is the difference between int, Int16, Int32 and Int64?
- How to open .dll files to see what is written inside?
- Windows .NET API / Windows 7 / Bluetooth communication with Intel Curie Arduino / Genuino 101
- System.web.mvc missing
- Nullable object must have a value?
- Extension methods must be defined in a non-generic static class
- “Error while trying to run project: Unable to start program”. Can run program only once. Then VS needs restart
- How to resolve this System.IO.FileNotFoundException
- Embed a System.String in XAML
- What is clr.dll on .Net framework and what does it do?
- what is this oleaut32.dll?
- Associating enums with strings in C#
- How to resolve this System.IO.FileNotFoundException
- Why does .Net Socket.Disconnect take two minutes?
- Extension methods must be defined in a non-generic static class
- ClickOnce runtime DFSVC.EXE
- How can I get the application’s path in a .NET console application?
- How do I create a Shared Code project (.shproj)
- SQL Connection Error: System.Data.SqlClient.SqlException (0x80131904)
- Multiple file-extensions searchPattern for System.IO.Directory.GetFiles
- Could not establish trust relationship for SSL/TLS secure channel — SOAP
- Unable to read data from the transport connection : An existing connection was forcibly closed by the remote host
- The remote server returned an error: (407) Proxy Authentication Required
- How to open a new form from another form
- Nuget connection attempt failed “Unable to load the service index for source”
- Cannot access a disposed object – How to fix?
- HTML.ActionLink method
- Deep cloning objects
- Regular expression “^[a-zA-Z]” or “[^a-zA-Z]”
- Exception from HRESULT: 0x800A03EC Error
- Could not load file or assembly App_Web_ * with a precompiled ASP.NET website project
- How should I cast in VB.NET?
- .NET graph library around?
- An object reference is required to access a non-static member
- Task vs Thread differences
- XmlSerializer – There was an error reflecting type
- What is The difference between ListBox and ListView
- Substring index and length must refer to a location within the string
- Run Command Prompt Commands
- SQLite equivalent to ISNULL(), NVL(), IFNULL() or COALESCE()
- Could not establish secure channel for SSL/TLS with authority ‘*’
- Visual Studio keeps crashing
- How can I implement static methods on an interface?
- How to delete a file after checking whether it exists
- c# Show Windows Form
- How do I exit a WPF application programmatically?
- How can I delete a file that is in use by another process?
- Entity Framework vs LINQ to SQL
- How to properly make a http web GET request
- Strip double quotes from a string in .NET
- Convert double to float by cast or Convert.ToSingle()?
- How to create a new object instance from a Type
- Using FolderBrowserDialog in WPF application
- Is there an equivalent to the C# “var” keyword in C++/CLI?
- When should I use a List vs a LinkedList
- Could not find any resources appropriate for the specified culture or the neutral culture
- Playing a MP3 file in a WinForm application
- Iif equivalent in C#
- LINQ query on a DataTable
- Best way to randomize an array with .NET
- Encrypt and decrypt a string in C#?
- Unrecognized escape sequence for path string containing backslashes
- INQ: When to use SingleOrDefault vs. FirstOrDefault() with filtering criteria