Microsoft.Office.Interop.Excel.Application when i debug its not given error when i Releas its given error are you missing assembly

Question

hello everyone,
i am trying to Release my Windows base application for automatic update get my application users but its given me an error for
Severity Code Description Project File Line Suppression State
Error CS0234 The type or namespace name 'Excel' does not exist in the namespace 'Microsoft.Office.Interop' (are you missing an assembly reference?) ERPs

when i select Debug mode its not given any error

Answer 1

Generally when Excel code works in debug mode or release mode on a developer's box then fails on a client's box means either the client does not have Excel installed or does not have the correct version of Excel.

The best solution is not to use Excel automation, instead use an Excel library which is not dependent on Excel being installed. Two of many free libraries

https://github.com/ClosedXML/ClosedXML

https://spreadsheetlight.com/

And there are plenty of paid for libraries such as

https://www.gemboxsoftware.com/

And there is always the option to skip libraries and code what those libraries do yourself

https://social.technet.microsoft.com/wiki/contents/articles/51328.excel-operations-with-open-xml-automation-and-oledb.aspx