We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

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

grotonman
grotonman asked
on
Medium Priority
310 Views
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.

thx


Comment
Watch Question

Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
I continue to get an error
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.