Mar 24, 2009
Using Java to Import and Manipulate Microsoft Excel
JExcel is an API that allows manipulation of Excel spreadsheets from Java applications. JExcel API is a stable open source product that has been around since 2003. The API is very simple to use and yet very powerful.
Key Features
- Reads data from Excel 95, 97, 2000, XP, and 2003 workbooks
- Reads and writes formulas (Excel 97 and later only)
- Generates spreadsheets in Excel 2000 format
- Supports font, number and date formatting
- Supports shading, bordering, and coloring of cells
- Modifies existing worksheets
- Is internationalized, enabling processing in almost any locale, country, language, or character encoding (formulas are currently only supported in English, French, Spanish, and German, but more can be added if translated)
- Supports copying of charts
- Supports insertion and copying of images into spreadsheets
- Supports logging with Jakarta Commons Logging, log4j, JDK 1.4
Here’s how to Use the API
Leave a Reply