How to use Microsoft.Office.Interop.Excel without installing

Question

Hi all I attached a file with code.It wokrs fine in machine where office package is installed But when I am using this code in client machine where office package is no installed it gives me the following error The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on local machine. Can any one help me out. Thanks in advance

Nilesh Shah · Answer

https://www.microsoft.com/en-us/download/confirmation.aspx?id=23734

Faris Shahin · Answer

If you’re using any of Microsoft Office interop components in your program you must install Office on the deployment computer. If this is not a valid option for you the best alternative is to use a third-party library or toolkit such as LEADTOOLS Document Imaging SDK (Disclaimer: I’m an employee of LEAD) to achieve your requirement: https://www.leadtools.com/sdk/document-imaging

Lisa White · Answer

Hi Manas You could also use Spire.XLS to export data to excel. Reference: https://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Data-Export-/Import-Export-Datatable-to-Excel-from-Database.html

Ramesh Palanivel · Answer

Hi Manas If we want to export the data to excel using code we should need excel object (Microsoft.Office.Interop.Excel) If the machine not having the excel package we cannot create the excel object Just search in google for some libraries which allows to modify xls or xlsx: https://code.google.com/archive/p/excellibrary/ http://simpleooxml.codeplex.com/