Hi

I am working on ASP.NET.We installed excel 2000 on my server.
We are doing windows authentication(checked Integrated windows authentication in IIS) for our web site.
In our application using excel object for exporting data to excel.
When i try to access that perticular page from client machine its exporting data without any problem because i am having admin previliges in server machine.
But any other valid Windows user(who is not having admin prevliges in server) try to access that page giving excel object permissions denied error.

if i remove windows authentication in IIS then all users can do the excel export.
But i have to use windows authentication in my web application.

I want to use both windows authentication and exporting to excel in my application.
how to slove this problem.
Your help is appriciated.

thanks sr

when using windows authentication you need to give each user rights on the machine. I think the other option is to use impersionation..

That said, if your creating a basic sheet- there is no need to use the excel object- you can change the header and send a table over, and the browser will open it in excel (which the user can then save).


Hal Levy
Web Developer, PDI Inc.

NOT a Wiley/Wrox Employee