Excel export with formulas does not work on web server but does using Web Developer Express

Posted on 2011-04-27
Last Modified: 2012-05-11
We are using Excel.Interop and it works fine when launching the application using Debug or Launch in Browser in my Web Develop Express.

We have a simple html table with values that work with both scenarios but the creation of cell objects with formulas does not when using a stand alone browser.

But when accessing the same page in the same directory on the same web server, the Excel.Interop is not used if we are accessing using a standalone browser.
The Interop is found, because we have no error message like we used to have.  

Seems like we have two different clients with different permissions trying to access Interop.

If that sounds like it could be the problem, how could I find out which account is being used to excute the page in each scenario?

We are using Launching User in Dcom.

Tried using a specific user in Dcom but that didn't work either.

Tried using <identity impersonate user="XXX" password="XXX" />
but that didn't work.


Question by:grotonman
    LVL 9

    Accepted Solution

    Did you check the worker process on the server? In IIS, under Application Pools, view the Properties of the app pool for the site and check the Identity tab. The default identity is usually Network Service if "Predefined" is selected, but can be changed by selecting "Configurable" and supplying the appropriate credentials.

    Note however that if you supply the credentials, you just need to make sure to register it to ensure it has the appropriate permissions. See for more info.

    Author Closing Comment

    I continue to get an error

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    A quick way to get a menu to work on our website, is using the Menu control and assign it to a web.sitemap using SiteMapDataSource. Example of web.sitemap file: (CODE) Sample code to add to the page menu: (CODE) Running the application, we wi…
    It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now