Java Excel API explained

Java Excel API
Developer:	Andy Khan, Eric H. Jung
Latest Release Version:	2.6.12
Latest Release Date:	8 October 2012
Operating System:	Cross-platform
Programming Language:	Java
Genre:	API to access Microsoft Excel format
License:	GNU LGPL v2.1+

Java Excel API (a.k.a. JXL API) allows users to read, write, create, and modify sheets in an Excel (.xls) workbook at runtime. It doesn't support .xlsx format.

Microsoft Excel support

Java Excel API supports Excel documents with versions Excel 95, 97, 2000, XP, and 2003. These documents hold the extension .xls.

Usage

Java Excel API is widely used with Selenium.

Example

Sample code to write to an Excel file might look like as follows:import java.io.File;import jxl.Workbook;import jxl.write.WritableSheet;import jxl.write.WritableWorkbook;import jxl.write.Label;import jxl.write.WriteException;

public class DataSheet

See also

• Apache POI
• Open Packaging Conventions
• Office Open XML software

External links

• Java Excel API
• MAVEN repository
• Selenium tutorial