Access Excel Tables without having Excel installed ?

Question

Hello I recently wrote a program that reads values out of a Excel Table and that computer had Excel installed. Now I'm working on a computer where Excel is not installed and I got this error when I try to debug the program. Die COM-Klassenfactory für die Komponente mit CLSID {00024500-0000-0000-C000-000000000046} konnte aufgrund des folgenden Fehlers nicht abgerufen werden: 80040154 Klasse nicht registriert (Ausnahme von HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)). It's in German but I hope you can help me. Info: I added 3 .dll files -Microsoft.Vbe.Interop.dll -Microsoft.Office.Interop.Excel.dll -Office.dll Have I to add an additional .dll file? Or is it impossible to work without Excel installed?

Sascha B · Answer

Sounds good but don't solve the problem... With the new .dll can I also create a Excel Attribute like this:? xlApp = new Excel.ApplicationClass(); Or is it now an other declaration? P.S. It says Xml writer so it uses xml Spreadsheet right? but I'm using the normal xls files. Edit: I found this: http://code.google.com/p/excellibrary/ 'Ill try it next week

Felipe Ramos · Answer

I believe you can I started a project trying to use the Microsoft libs and look online and found a free .net class at http://www.carlosag.net/Tools/ExcelXmlWriter/ and I do believe you are correct about not needing Excel installed.

Sascha B · Answer

The .dll files are in the Debug folder. So it seems that a installed Excel version has a additional library file(s)... But where they and how are they called? I read that it is possible to write an own Excel interpreter with the open source code of OpenOffice ?

Felipe Ramos · Answer

I would start by making sure all your references get moved to your debug or release folder. Sometimes when dll are in the system GAC (C:\WINDOWS\assembly) the reference of the project will assume it will be found there.