Reading Excel Data in a Matisse Form
By johnc on Feb 27, 2006
Dafe Simonek contributed this great tutorial about how to work with Excel files in Java applications. It creates a simple GUI using matisse and then populates it with data from an Excel file. Here's the highlights of what the tutorial covers:
First, download JExcelApi the Java Excel library. Then create a Java application project, add the JExcelApi JAR to the classpath (Dafe creates a full library with sources and Javadocs) and create the ReadExcelUI form to display the data. See Dafe's turorial for how to create the form. It's basically just got a menu with two items and a JTable. The form should look like the following:
Then you hook up the logic to the form GUI components. See Dafe's tutorial for the business logic. It's pretty easy and a good introduction to hooking up events and working with custom data models in Matisse. Thanks for the contribution, Dafe!!!