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

Manas Sahoo

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

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Faris Shahin9y ago
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 White9y ago
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
Nilesh Shah9y ago
https://www.microsoft.com/en-us/download/confirmation.aspx?id=23734
Ramesh Palanivel9y ago
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/