Using a Java Servlet to Generate Up-To-Date Microsoft Excel Spreadsheets

ind out how to create simple Excel spreadsheets dynamically using a Java servlet.

Spreadsheets play a vital role in the enterprise. Business analysts and management typically use the data in spreadsheets to make critical business decisions. The DevX article "Learn to Read and Write Microsoft Excel Documents with Jakarta's POI" shows you how to read and write Microsoft Excel documents using Apache Jakarta's POI. In this article, I'll show you how you can create simple Microsoft Excel spreadsheets dynamically on a J2EE Web application server. Accordingly, Web site visitors will be able to visit a URL and have the most up-to-date spreadsheet data available to them via their Web browsers. I'll show you how to create your spreadsheets in a Java servlet engine such as that of IBM WebSphere Application Server Version 6 without having to use a facility such as POI.