CODEWITHSUNDEEP
c#excel
Anirudh Agarwal
Anirudh Agarwal

Reputation: 697

Is MS office required on server to use Microsoft.Excel.interop

I have created a merge excel program in my application using Microsoft.Office.Interop.Excel. But when deployed on IIS server I am getting error. Regarding that error I searched many articles and tried but got no successfs. So please can you verify this?

Upvotes: 1

Views: 2246

Answers (1)

Nick
Nick

Reputation: 5042

It is required.

But, you should not use Office interop on a server. The problem is that Office apps require a graphical user session to work properly. On the other hand, Windows service apps and IIS run without one. This is officially not supported and not recommended. If you do, you will encounter random crashes and resource leaks.

If you want to generate or modify Excel files, use OpenXML SDK.

EDIT: You may want to use Spreadsheet Gear. I can recommend it from personal experience in a web-app that manipulated existing Excel sheets with complex formulas.

Upvotes: 3

Related Questions