DotNetNewsgroup.com  
web access to complete list of Microsoft.NET newsgroups
   home   |   control panel login   |   archive  |  
 
  carried group
academic
adonet
aspnet
aspnet.announcements
aspnet.buildingcontrols
aspnet.caching
aspnet.datagridcontrol
aspnet.mobile
aspnet.security
aspnet.webcontrols
aspnet.webservices
assignment_manager
datatools
dotnet.distributed_apps
dotnet.general
dotnet.myservices
dotnet.nternationalization
dotnet.scripting
dotnet.security
dotnet.vjsharp
dotnet.vsa
dotnet.xml
dotnetfaqs
framework
framework.clr
framework.compactframework
framework.component_services
framework.controls
framework.databinding
framework.drawing
framework.enhancements
framework.interop
framework.odbcnet
framework.performance
framework.remoting
framework.sdk
framework.setup
framework.webservices
framework.windowsforms
framework.wmi
frwk.windowsforms.designtime
lang.csharp
lang.jscript
lang.vb
lang.vb.controls
lang.vb.data
lang.vb.upgrade
lang.vc
lang.vc.libraries
  
 
start date: Wed, 11 Jul 2007 23:54:00 -0700,    posted on: microsoft.public.dotnet.framework.interop        back       

Thread Index
  1    Alexander Kolev


Run console app that runs Excel from ASP.NET   
Hi,

I've implemented a simple console application that runs Excel, attaches a 
macro and then saves the excel file with the applied macro file.

This console application is started/spawned from ASP.NET Web application.

Running Excel is implemented in a single method.

It takes 30 seconds to run the console application with a small xsl file 
(20 KB) and very simple marco.

I added trace before calling the method and in the first line inside the 
method. Then I saw that this delta is 30 seconds.

-----------------------------------------------------------------
void Main()
{
Trace.WriteLine( "Before Run marco");

RunMacro();
}


void RunMacro()
{
Trace.WriteLine( "In Run marco");

// code to run that construct Excel and runs the macro file
}

It seems that it takes a lot of time to the CLR to build/create/JIT compile 
the 
Runtime Callable warpper or something like that?

Hoe can I reduce this time. The performance is very very slow.

Any help is appreciated.

Thanks in advance.
Date:Wed, 11 Jul 2007 23:54:00 -0700   Author:  

Google
 
Web dotnetnewsgroup.com


COPYRIGHT ?2005, EUROFRONT WORLDWIDE LTD., ALL RIGHT RESERVE  |   Contact us