Excel Macro with ASP.NET Very Slow

[rchandr3]

Hi, I have an Excel Spreadhseet with some complex calculations which includes drawing a chart and writing to files. Now the Customer has asked us to change the front end to ASP.NET and use the existing Excel Sheet for replicating the logic would be costly. When we tried to do the integration we are stuck with calling the Excel Macro from ASP.NET front end. If the Macro is small, it runs. But when it becomes complex, the ASP.NET screen hangs and we NEVER get a result. We do not know whether Excel is doing some work for we do not know how to debug Excel from ASP .NET.

Please help and thanks in advance,

Cheers,

Ravi





Cheers,

Ravi

 

[ca8msm]

Generally using microsoft excel directly with ASP.NET is not recommended (there are a few articles on MSDN where microsoft say this). You could, however, create a service that does the work for you and then the ASP.NET site, can simply allow you to download the resulting file.


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.