Excel file doesnot open when I host my Dot Net Application in IIS

Question

I Have my Dot Net application where I am opening Excel file by fetching path from DB on the click of Button, It works fine, but when I host my application in IIS then i am getting following exception-

 System.Runtime.InteropServices.COMException (0x800A03EC): Exception from HRESULT: 0x800A03EC 
 at Excel.Workbooks.Open(String Filename, Object UpdateLinks, Object ReadOnly, 
                          Object Format, Object Password, Object WriteResPassword, 
                          Object IgnoreReadOnlyRecommended, Object Origin, 
                          Object Delimiter, Object Editable, Object Notify, 
                          Object Converter, Object AddToMru, Object Local, 
                          Object CorruptLoad)

Please Help...

sgeddes · Accepted Answer · 2013-01-12 06:43:33Z

1

I generally find these to be permissions issues with the user associated with the website in IIS. Make sure the IIS user has access to the file.

Incidentally, I might would consider using 3rd party DLLs which don't require the use of Excel Automation. I have had good success with NPOI if you don't need XLSX support. Just a suggestion.

Good luck.

answered Jan 12, 2013 at 6:43

sgeddes

62.9k7 gold badges68 silver badges85 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Pramod Sawant Over a year ago

Yes, I have gone through first way mentioned as we need to give some permissions for ASPNET user, I solved it...Thanks a lot

vikas · Accepted Answer · 2013-01-12 06:48:45Z

0

Have you impersonate uSer refer http://support.microsoft.com/kb/306158

answered Jan 12, 2013 at 6:48

vikas

2,8224 gold badges29 silver badges37 bronze badges

Collectives™ on Stack Overflow

Excel file doesnot open when I host my Dot Net Application in IIS

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related