Excel.Application

[Gorgo]

Hello

I'm sorry if this is not the right group to post this post, but
unfortunetly this one is one of the best i know.

I'm doing and asp.net application with need to create excel file thru
DCOM Excel.application object. For that I created special user and make
it as a default user on which Excel.Application is created (I did this
thru dcomcnf). Also I give full control to my application folder in
inetpub.
And now the issue:

If my user is added to Admin group then everything works fine. If he is
not added to admin group then during execution I get error that
"PrintArea can not be set" and application stops.

Does anyone enconter simillar probelm ?
Any suggestion are welcome.

thanks in advance
regards
Gorgo

 

[Steve C. Orr [MVP, MCSD]]

Are you trying to use Excel on the server or the client?
I wouldn't recommend doing it on the server, and even on the client there
are security issues, as you're discovering.
Perhaps you should consider an alternate technique to generate Excel
spreadsheets, such as one of the techniques outlined in these links:

Do it yourself:
http://SteveOrr.net/articles/ExcelExport.aspx
http://www.dotnetspider.com/technology/kbpages/1080.aspx
http://SteveOrr.net/articles/ExportPanel.aspx

Good 3rd party products:
http://SteveOrr.net/reviews/AsposeExcel.aspx
http://SteveOrr.net/reviews/OfficeWriter.aspx

You should also consider the new VSTO:
http://msdn.microsoft.com/vstudio/products/vsto/default.aspx