O'Reilly logo

JDBC 4.0 and Oracle JDeveloper for J2EE Development by Deepak Vohra

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 13. Creating a Spreadsheet with Apache POI

Database table data is often required to be presented as an Excel spreadsheet. The Apache POI project provides Java APIs for processing Microsoft OLE 2 Compound Document Format Files, which include XLS and DOC files. The Apache POI HSSF component of the Apache POI project is a Java API to access and generate Excel Workbooks and Excel spreadsheets. Apache POI HSSF does not support the new Excel 2007 .xlsx OOXML file format, which is not OLE2 based. An Excel workbook consists of spreadsheets and an Excel spreadsheet consists of rows and cells. The layout and fonts of a spreadsheet are also set with the Apache POI HSSF Java API.

The Apache POI HSSF project is a Java API to create an Excel workbook ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required