Skip to content

Excel Sheet Generation Using Marvin Beans

The following example is a JSP page that generates an Excel Sheet with Marvin generated structure images and structure data.
To run the examples, follow the steps below.

  1. Install MS Excel 2000 or higher version.
  2. Install Tomcat. (of course, the examples also run under other servlet servers.)
  3. Copy all JAR files (files with .jar extension) of the Marvin Beans or JChem package under Tomcat's lib directory.
  4. Create the marvin directory under Tomcat's webapps/examples/jsp/marvin
  5. Copy the generate_image.jsp file from the examples/image-generation directory and the molsheet.jsp file from the examples/excelsheet-generation directory of Marvin Beans to Tomcat's webapps/examples/jsp/marvin/ directory.
  6. Start Tomcat
  7. Open:
    1. Start MS Excel and open the following link: http://localhost:8080/examples/jsp/marvin/molsheet.jsp
    2. If you have cocoon or other XML publishing framework installed under your servlet server you can open the http://localhost:8080/examples/jsp/marvin/molsheet.jsp link from your browser.