Working with Microsoft Excel Spreadsheets and Microsoft Access Databases in a Java Application

Sean Sullivan, Senior Software Engineer, -

Track: Java
Date: Thursday, July 27
Time: 2:35pm - 3:20pm
Location: E143-144

In large corporations, Microsoft Excel and Microsoft Access continue to be popular productivity tools. In these corporate environments, IT developers are often asked to build Java applications that can read data from Excel spreadsheet files and Access databases. This session will examine two open source solutions: Jakarta POI and Jackcess. Jakarta POI is a pure Java library for reading and writing Excel XLS files; the Jackcess project is a pure Java library for reading and writing Access MDB files.

We'll discuss how to use the libraries in both desktop applications and server-side applications. By attending this session, you will learn how to incorporate POI and Jackcess into your applications and how to avoid common pitfalls.