Chapter 12. Converting XML to MS Excel
As explained in the previous chapter, while XML is the standard format for data exchange, Adobe PDF and Microsoft Excel are better suited for data presentation. Using the Java API for XML Processing or the XPath API, data may be retrieved from an XML document and then presented in an Excel spreadsheet using a Java API for Excel spreadsheet. Various Java APIs are available for processing an Excel spreadsheet. Some of the more commonly used are discussed in the following table:
|
Java API |
Description |
|---|---|
|
Apache POI-HSSF |
Apache POI Project's HSSF API is an open source Java API to create, modify, read, and write XLS spreadsheets. It supports graphics and images. |
|
JExcel |
JExcel is an open source Java API to read, write, and modify Microsoft Excel spreadsheets. It supports charts and images. JExcel may be downloaded from http://sourceforge.net/project/showfiles.php?group_id=79926. |
|
Java e.Spreadsheet Engine and Excel API |
e.Spreadsheet Engine and Excel API... |
