Visual Studio .NET - How to Automate excel in ASP.net using vb

I would like Create Dynamic ASP.NET Excel Workbooks using VB or javascript
 
 
I tried using vb in asp.net page
 createObject("Excel.Application") 
server.createObject("Excel.Application") 
 
I got an exception error message Cannot create ActiveX component.

I used the following code in ASP.net page using javascript, still I get the same error.
 
var Excel, Book; 
// Create the Excel application object.
 Excel = new ActiveXObject("Excel.Application");
 
 
However, this code works in ASP pages.
 
Could you please suggest where I am going wrong.
 
Any help is much appreciated 
 
Regards
Nalina

you need to first set a COM Reference to the Excel TypeLibrary and let VS.NET Generate a .NET COM Interop wrapper for this.
.NET can only talk to COM through Interop.

Hi! peter
I wrote a com wrapper for excel and I am getting the following error: 

The application attempted to perform an operation not allowed by the security policy. To grant this application the required permission please contact your system administrator or change the application's trust level in the configuration file.

Hi,

How did you resolve this problem?
I have the same situation.

Did you add some security policy?

I appreciate your help.

Regards,
Marco.