How to develop a website using .NET Programmability Support?

r p

15y2.6k.NET

Hi,
I am developing a website to manipulate excel document.
I was using office Interop to manipulate the files.
In my hosting server my provider does not allow me install office.
So, I am getting the following error:-
"Could not load file or assembly 'Microsoft.Vbe.Interop, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified."
I have office 2010 installed on my development machine.
I was told that if I use ".NET Programmability Support", in my development server, I can overcome this problem. I think ".NET Programmability Support" is installed on my machine.
How can I develop my website using .NET Programmablility Support and will it solve the above error?
Thanks,

2 Replies

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

Sam Hobbs15y ago
First understand that there is a difference between server-side and client-side. I think Microsoft does not suggest use of Office server-side and that is probably why your hosting server does not allow installation of Office. As far as I understand, there are solutions for using Office in a server but you must pay for them.

Alternatively, if you can use Offrice in the client's system then that could work. Or you could process the data somehow without using Excel.
Javeed M Shaikh15y ago
.NET Programmability Support is an advance feature which needs to be set while installing MS Office or update Office, I am not sure that applies in your case as the production server itself does not have any MS Office installed. I am not sure about this.

Other way to achieve this:

use ADO to read and write to Excel, using Microsoft.Jet.OLEDB driver. The drivers for Jet are available in most installations of Windows, just check the version with your provider to start testing.