ExcelDatareader Dependencies

Question

Hi all,

I am developping an application that connects to a Sharepoint site and try to read the Excel files which are uploaded onto it.

Therefore, I use the ExcelDatareader assembly, but I get the error:

Could not load file or assembly 'Excel v2.0.x' or one of its dependencies. The system cannot find the file specified.

Obviously, the problem lies in the dependencies, because the Excel dll is saved in the bin directory.

Does anybody knows how to detect the dependencies that I should add to my project?

Answer 1

The sharepoint probably doesn't have a license to run Office. When you connect to the website you are running applications from the sharepoint instead of running applications from your host pc. Instead you either need to download the file or map a drive to the sharepoint so you are running your host pc excel application.

---

jdweng

Answer 2

Thanks Joel for your answer.

Nevertheless, my Sharepoint is a Foundation release that was installed on the host PC, where I have also a licensed Office.

Any other idea?

Bye

Answer 3

Open a Window explorer (not IE) on the sharepoint and double click on any excel file and see what happens.  It should open the excel file.  Make sure you use the same account that you  are using in your software.  I suspect the path to the excel.exe file is wrong for the account you are using.  Possibly excel was updated from one version to another version.  when an update is performed of any office product the a new folder is creating in Program files and the registry entry is changed for the excel.exe.  It may be wrong.  Normall I fix this by using a window explorer and going to the following menu.

View - folder Options - File Types

Then going to the file type like XLS (repeat for each excel extension).

Advance - Set Default

or

Open - edit - Application used to perform action

Also if you have Office 2003 installed and you want to view a newer version of excel you would need to download the excel viewer.

---

jdweng