11. srpna 2012 9:46
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?
11. srpna 2012 12:14The 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.
- Označen jako odpověď Leo_GaoModerator 20. srpna 2012 0:48
10. září 2012 6:31
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?
10. září 2012 7:48
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
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.