ASP.NET: Office Automation on Web Server (IIS)
Often in web application, we require to automate office application. One common such requirement is Export To Excel. Here in this article, we will discuss different approaches for automating office application on web server and will try to conclude which is recommended approach with respect to technical & licensing feasibility along with reference link and available open source library from community. However for simplicity we will discuss around Export To Excel functionality as it is most common and required feature in any web application but approaches discussed here and external references given here apply to other office application as well including Word and Power Point.
