How to open an Excel file in C#?

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:

  1. What is a singleton in C#?
  2. ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine
  3. My C# application is returning 0xE0434352 to Windows Task Scheduler but it is not crashing
  4. C# Set collection?
  5. Why is Dictionary preferred over Hashtable in C#?
  6. Does anyone still use [goto] in C# and if so why?
  7. How does the “Using” statement translate from C# to VB?
  8. What is the best way to parse html in C#? [closed]
  9. Best C# API to create PDF
  10. C# cannot convert method to non delegate type
  11. What is the difference between const and readonly in C#?
  12. Pass Method as Parameter using C#
  13. ArrayList vs List<> in C#
  14. What’s the @ in front of a string in C#?
  15. How to solve ‘…is a ‘type’, which is not valid in the given context’? (C#)
  16. Calling the base constructor in C#
  17. Best way to repeat a character in C#
  18. How to empty a list in C#?
  19. What is a method group in C#?
  20. How do I save a stream to a file in C#?
  21. Print Pdf in C#
  22. Can a Byte[] Array be written to a file in C#?
  23. What is the difference between String and string in C#?
  24. Creating a List of Lists in C#
  25. C# int to byte[]
  26. .Net 4.8 Support for Windows 10 ends in 26 days?
  27. What is a NullReferenceException, and how do I fix it?
  28. How do I get a random YouTube video with the YouTube API?
  29. An existing connection was forcibly closed by the remote host
  30. How can I convert String to Int?
  31. What is a NullReferenceException, and how do I fix it?
  32. I am getting Failed to load resource: net::ERR_BLOCKED_BY_CLIENT with Google chrome
  33. What’s the difference between .NET Core, .NET Framework, and Xamarin?
  34. Could not load file or assembly or one of its dependencies
  35. Error : Could not load file or assembly or one of it’s dependencies
  36. What is WCF? and what can it do?
  37. Priority queue in .Net
  38. What is the difference between int, Int16, Int32 and Int64?
  39. How to open .dll files to see what is written inside?
  40. Windows .NET API / Windows 7 / Bluetooth communication with Intel Curie Arduino / Genuino 101
  41. System.web.mvc missing
  42. Nullable object must have a value?
  43. Extension methods must be defined in a non-generic static class
  44. “Error while trying to run project: Unable to start program”. Can run program only once. Then VS needs restart
  45. How to resolve this System.IO.FileNotFoundException
  46. Embed a System.String in XAML
  47. What is clr.dll on .Net framework and what does it do?
  48. what is this oleaut32.dll?
  49. Associating enums with strings in C#
  50. How to resolve this System.IO.FileNotFoundException
  51. Why does .Net Socket.Disconnect take two minutes?
  52. Extension methods must be defined in a non-generic static class
  53. ClickOnce runtime DFSVC.EXE
  54. How can I get the application’s path in a .NET console application?
  55. How do I create a Shared Code project (.shproj)
  56. SQL Connection Error: System.Data.SqlClient.SqlException (0x80131904)
  57. Multiple file-extensions searchPattern for System.IO.Directory.GetFiles
  58. Could not establish trust relationship for SSL/TLS secure channel — SOAP
  59. Unable to read data from the transport connection : An existing connection was forcibly closed by the remote host
  60. The remote server returned an error: (407) Proxy Authentication Required
  61. How to open a new form from another form
  62. Nuget connection attempt failed “Unable to load the service index for source”
  63. Cannot access a disposed object – How to fix?
  64. HTML.ActionLink method
  65. Deep cloning objects
  66. Regular expression “^[a-zA-Z]” or “[^a-zA-Z]”
  67. Exception from HRESULT: 0x800A03EC Error
  68. Could not load file or assembly App_Web_ * with a precompiled ASP.NET website project
  69. How should I cast in VB.NET?
  70. .NET graph library around?
  71. An object reference is required to access a non-static member
  72. Task vs Thread differences
  73. XmlSerializer – There was an error reflecting type
  74. What is The difference between ListBox and ListView
  75. Substring index and length must refer to a location within the string
  76. Run Command Prompt Commands
  77. SQLite equivalent to ISNULL(), NVL(), IFNULL() or COALESCE()
  78. Could not establish secure channel for SSL/TLS with authority ‘*’
  79. Visual Studio keeps crashing
  80. How can I implement static methods on an interface?
  81. How to delete a file after checking whether it exists
  82. c# Show Windows Form
  83. How do I exit a WPF application programmatically?
  84. How can I delete a file that is in use by another process?
  85. Entity Framework vs LINQ to SQL
  86. How to properly make a http web GET request
  87. Strip double quotes from a string in .NET
  88. Convert double to float by cast or Convert.ToSingle()?
  89. How to create a new object instance from a Type
  90. Using FolderBrowserDialog in WPF application
  91. Is there an equivalent to the C# “var” keyword in C++/CLI?
  92. When should I use a List vs a LinkedList
  93. Could not find any resources appropriate for the specified culture or the neutral culture
  94. Playing a MP3 file in a WinForm application
  95. Iif equivalent in C#
  96. LINQ query on a DataTable
  97. Best way to randomize an array with .NET
  98. Encrypt and decrypt a string in C#?
  99. Unrecognized escape sequence for path string containing backslashes
  100. INQ: When to use SingleOrDefault vs. FirstOrDefault() with filtering criteria

Leave a Comment

tech