Can I generate Microsoft Excel documents using JSP or servlets?

Jorge Jordão

Apart from using C++ and JNI directly, there are (at least) two ways to read/write an MS Excel file in Java.

  1. Using a Java-COM bridge (Please view my previous answer to How can I get email addresses out of an MS Outlook database, and add new ones?).
  2. Using Formula One, which is a Reporting Engine API for Java that allows you to manipulate MS Excel 95/97/2000 files (including charts, formulas and functions).