Re: excel 2003 cannot read asp.net page output

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Just to clarify, Alvin, are you actually advising somebody (in your
capacity as MVP) to follow a procedure which Microsoft themselves will not
support...?


Wow, strong words. Yes I am. You tell kids not to play with fire because
fire can hurt them pretty bad right? Turns out, fire can be extremely
helpfull if you know how to use it. Sure, MS does not support server side
automation of Excel. I'm not arguing that, I'm saying there are ways to
automate Excel on the server if you operate between the limits - I spell out
those limits and let the developer decide after they understand that MS will
not provide support. That hasn't stopped people from automating Excel on the
server because there is a need that MS is yet to provide leadership on. Sure
there are products from MS that avoid the pitfalls but each is mired in
licensing that put those solutions out of the reach of common developer
shops. That's why you'll see a thread every week about excel automation in
here.

FWIW, you should not automate Excel on the server, it's single threaded and
ASP.NET runs on an MTS threadpool that, in essense, is the crux of the
matter. Ok, i've said enough and I'm certain to get into hot water for it...

--
Regards,
Alvin Bruney
------------------------------------------------------
Shameless author plug
Excel Services for .NET is coming...
https://www.microsoft.com/MSPress/books/10933.aspx
OWC Black Book www.lulu.com/owc
Professional VSTO 2005 - Wrox/Wiley


"Mark Rae" <mark@xxxxxxxxxxxxxxxxx> wrote in message
news:u4MWpmYmHHA.1244@xxxxxxxxxxxxxxxxxxxxxxx
"Alvin Bruney [MVP]" <some guy without an email address> wrote in message
news:%23WKYcQYmHHA.4960@xxxxxxxxxxxxxxxxxxxxxxx

That's a good point you've made. In the cases that I run across, there is
no better way than to automate Excel on the server. It can be done in a
way that provides efficient throughput bearing in mind that is swimming
with the aligators.

Just to clarify, Alvin, are you actually advising somebody (in your
capacity as MVP) to follow a procedure which Microsoft themselves will not
support...?


--
http://www.markrae.net


.

Relevant Pages

  • Collax Open-Xchange Server für industrie
    ... und weitaus Leistungsfähiger als der Microsoft Exchange Server 2007 ... zusammen mit der einer Racklösung von Zarafa bietet er eine Spitzen Leistung ... Sun Fire X4200 Server Family Operating Systems ...
    (microsoft.public.de.security.netzwerk.sicherheit)
  • Collax Open-Xchange Server für industrie
    ... und weitaus Leistungsfähiger als der Microsoft Exchange Server 2007 ... zusammen mit der einer Racklösung von Zarafa bietet er eine Spitzen Leistung ... Sun Fire X4200 Server Family Operating Systems ...
    (microsoft.public.de.security.heimanwender)
  • RE: Is it possible to automate COM objects embeded iin Excell document
    ... to automate Excel from C# or VB.NET project with step-by-step examples. ... How to automate Microsoft Excel from Visual Basic .NET ... Microsoft Online Community Support ... You can send feedback directly to my manager at: ...
    (microsoft.public.dotnet.general)
  • Re: Editing Excel
    ... Or you could automate excel on the server to do the dirty work for you. ... be able to access it with SQL statements. ... However, the files first ...
    (microsoft.public.dotnet.framework.aspnet)
  • Excel 2003 Automation using .NET
    ... I am trying to automate excel 2003 using asp.net programming. ... trying to use windows 2003 server as the webserver, ... client is showing "This page can not be displayed error". ...
    (microsoft.public.dotnet.general)