How to work with Excel in C#?

Question

excel

On the Internet they write that it is necessary to connect the library using Excel = Microsoft.Office.Interop.Excel, but where can I find it? Office 2016 is installed, but this library is not there.

Answer 1

In general, there are 3 options for working with MS Office documents.

1. Through Interop - requires pre-installed components in the system. Very inconvenient, ancient version.
   
2. Through OpenXML - no software is needed, custom implementations are available in almost all languages. You will only deal with the OpenXML format itself. Plus, it's free.
   
3. Use third party libraries such as Aspose or Spire.Office. My favorite option, no troubles, ready-made APIs are already made. Connected, working. One downside is it's free. But for personal needs, you can, and the free versions can suddenly come up too.
   

Answer 2

There is another option to use OLEDB and work with Excel as a database if the office itself is not installed on the PC ... To do this, you need to install AccessDatabaseEngine from Microsoft