Microsoft.Office.Interop.Excel

[wendell_lucas]

Hi,
I have an ASP.NET application that creates reports in Excel. It works
fine in development but not on our production Windows 2003 server
running IIS 6.0 Excel does not show up. I had a DCOM access error
which was fixed by giving Network Service Local Launch and Activation
Permissions. The application runs now but Excel does open up. I don't
see it as a process on the server either. Office 2003 was recently
installed on the server for this application. Has anyone had a problem
like this?

Thanks,
Wendell

[Mark Rae]

<we***********@hotmail.comwrote in message
news:11**********************@k79g2000hse.googlegr oups.com...

Has anyone had a problem like this?

Server-side Office automation does not work, and Microsoft does not support
it:
http://support.microsoft.com/default...US;q257757#kb2

You'll need to come up with a different solution e.g.:
http://www.aspose.com/Products/Aspos...s/Default.aspx
--
http://www.markrae.net

[=?Utf-8?B?QnJhdWxpbyBEaWV6?=]

Maybe is too late for this advise...

Office interop is not recommeded for ASP .net application:

http://support.microsoft.com/default...US;q257757#kb2

Too dangerous to have it on server side applicatons.

You could use XMLSS, or other lite approached.

Good luck
Braulio

/// ------------------------------
/// Braulio DÃ*ez
///
/// http://www.tipsdotnet.com
/// ------------------------------


"we***********@hotmail.com" wrote:

Hi,
I have an ASP.NET application that creates reports in Excel. It works
fine in development but not on our production Windows 2003 server
running IIS 6.0 Excel does not show up. I had a DCOM access error
which was fixed by giving Network Service Local Launch and Activation
Permissions. The application runs now but Excel does open up. I don't
see it as a process on the server either. Office 2003 was recently
installed on the server for this application. Has anyone had a problem
like this?

Thanks,
Wendell

[wendell_lucas]

On Jun 27, 7:10 am, Braulio Diez <[e-mail]:

Maybe is too late for this advise...

Office interop is not recommeded for ASP .net application:

http://support.microsoft.com/default...US;q257757#kb2

Too dangerous to have it on server side applicatons.

You could use XMLSS, or other lite approached.

Good luck
Braulio

/// ------------------------------
/// Braulio Díez
///
///http://www.tipsdotnet.com
/// ------------------------------

"[e-mail]" wrote:

Hi,
I have an ASP.NET application that creates reports in Excel. It works
fine in development but not on our production Windows 2003 server
running IIS 6.0 Excel does not show up. I had a DCOM access error
which was fixed by giving Network Service Local Launch and Activation
Permissions. The application runs now but Excel does open up. I don't
see it as a process on the server either. Office 2003 was recently
installed on the server for this application. Has anyone had a problem
like this?

Thanks,
Wendell- Hide quoted text -

- Show quoted text -

Thanks, for your quick replys. After reading the suggested articles,
it seems clear that we shall have to go to XML or a 3rd party tool
going forward. Unfortunately, it is too late to change directions for
this initial piece of the project. Do you have any idea why Excel is
not availible when running the application from the server?

Thanks,
Wendell

[Mark Rae]

<we***********@hotmail.comwrote in message
news:11**********************@k29g2000hsd.googlegr oups.com...

After reading the suggested articles, it seems clear that we shall
have to go to XML or a 3rd party tool going forward.
Unfortunately, it is too late to change directions for this initial
piece of the project.

Moving from Office Automation to Aspose is simplicity itself - they have
deliberately made their object model resemble the Office object model as
closely as possible precisely for this reason...

Do you have any idea why Excel is not availible when
running the application from the server?

Excel, as with the rest of Office, was simply not designed to be run in this
way.

The main reason is to do with threading, but there are others...
--
http://www.markrae.net

[=?Utf-8?B?QnJhdWxpbyBEaWV6?=]

I think somebody in a previoius thread has pointed the official Ms doc. about
how to configure Excel automation on ASP .net.

Mmmm... anyway take a look at this link, I think it give good tips:

http://www.eggheadcafe.com/articles/20021012.asp

Good luck
Braulio

/// ------------------------------
/// Braulio DÃ*ez
///
/// http://www.tipsdotnet.com
/// ------------------------------


"we***********@hotmail.com" wrote:

On Jun 27, 7:10 am, Braulio Diez <[e-mail]:

Maybe is too late for this advise...

Office interop is not recommeded for ASP .net application:

http://support.microsoft.com/default...US;q257757#kb2

Too dangerous to have it on server side applicatons.

You could use XMLSS, or other lite approached.

Good luck
Braulio

/// ------------------------------
/// Braulio Dmez
///
///http://www.tipsdotnet.com
/// ------------------------------

"[e-mail]" wrote:

Hi,
I have an ASP.NET application that creates reports in Excel. It works
fine in development but not on our production Windows 2003 server
running IIS 6.0 Excel does not show up. I had a DCOM access error
which was fixed by giving Network Service Local Launch and Activation
Permissions. The application runs now but Excel does open up. I don't
see it as a process on the server either. Office 2003 was recently
installed on the server for this application. Has anyone had a problem
like this?

Thanks,
Wendell- Hide quoted text -

- Show quoted text -

Thanks, for your quick replys. After reading the suggested articles,
it seems clear that we shall have to go to XML or a 3rd party tool
going forward. Unfortunately, it is too late to change directions for
this initial piece of the project. Do you have any idea why Excel is
not availible when running the application from the server?

Thanks,
Wendell

[Mark Rae]

"Braulio Diez" <br**************@yahoo.eswrote in message
news:A4**********************************@microsof t.com...

I think somebody in a previoius thread has pointed the official Ms doc.
about
how to configure Excel automation on ASP .net.

Which also include, in bold, a warning that Microsoft will not support any
solution which tries to use server-side automation because it doesn't
work...

Mmmm... anyway take a look at this link, I think it give good tips:

http://www.eggheadcafe.com/articles/20021012.asp

On the contrary - it demonstrates server-side automation, so should be
ignored...
--
http://www.markrae.net

[wendell_lucas]

On Jun 28, 2:06 am, Braulio Diez <[e-mail]:

I think somebody in a previoius thread has pointed the official Ms doc. about
how to configure Excel automation on ASP .net.

Mmmm... anyway take a look at this link, I think it give good tips:

http://www.eggheadcafe.com/articles/20021012.asp

Good luck
Braulio

/// ------------------------------
/// Braulio Díez
///
///http://www.tipsdotnet.com
/// ------------------------------

"[e-mail]" wrote:

On Jun 27, 7:10 am, Braulio Diez <[e-mail]:

Maybe is too late for this advise...

Office interop is not recommeded for ASP .net application:

>http://support.microsoft.com/default...US;q257757#kb2

Too dangerous to have it on server side applicatons.

You could use XMLSS, or other lite approached.

Good luck
Braulio

/// ------------------------------
/// Braulio Dmez
///
///http://www.tipsdotnet.com
/// ------------------------------

"[e-mail]" wrote:
Hi,
I have an ASP.NET application that creates reports in Excel. It works
fine in development but not on our production Windows 2003 server
running IIS 6.0 Excel does not show up. I had a DCOM access error
which was fixed by giving Network Service Local Launch and Activation
Permissions. The application runs now but Excel does open up. I don't
see it as a process on the server either. Office 2003 was recently
installed on the server for this application. Has anyone had a problem
like this?

Thanks,
Wendell- Hide quoted text -

- Show quoted text -

Thanks, for your quick replys. After reading the suggested articles,
it seems clear that we shall have to go to XML or a 3rd party tool
going forward. Unfortunately, it is too late to change directions for
this initial piece of the project. Do you have any idea why Excel is
not availible when running the application from the server?

Thanks,
Wendell- Hide quoted text -

- Show quoted text -

Braulio, that is a good article. It sould get us over.
Thanks all for your help.
Wendell

[Mark Rae]

<we***********@hotmail.comwrote in message
news:11*********************@k29g2000hsd.googlegro ups.com...

Braulio, that is a good article. It sould get us over.

Sigh...

The code in that article uses server-side automation.

THERE IS A VERY STRONG POSSIBILITY THAT IT WILL NOT WORK!!!!!
--
http://www.markrae.net

[Juan T. Llibre]

re:
!THERE IS A VERY STRONG POSSIBILITY THAT IT WILL NOT WORK!!!!!

Or worse, that it *will* work...screwing up the server in any of a zillion ways.

<g, d & r...>

Juan T. Llibre, asp.net MVP
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en español : http://asp.net.do/foros/
======================================
"Mark Rae" <ma**@markNOSPAMrae.netwrote in message news:eK**************@TK2MSFTNGP02.phx.gbl...

<we***********@hotmail.comwrote in message news:11*********************@k29g2000hsd.googlegro ups.com...

>Braulio, that is a good article. It sould get us over.

Sigh...

The code in that article uses server-side automation.
THERE IS A VERY STRONG POSSIBILITY THAT IT WILL NOT WORK!!!!!