Java Excel API (a.k.a. JXL API) allows users to read, write, create, and modify sheets in an
Excel
ExCeL London (an abbreviation for Exhibition Centre London) is an exhibition centre, international convention centre and former hospital in the Custom House area of Newham, East London. It is situated on a site on the northern quay of the Ro ...
(.xls) workbook at runtime. It doesn't support .xlsx format.
Microsoft Excel support
Java Excel API supports
Excel
ExCeL London (an abbreviation for Exhibition Centre London) is an exhibition centre, international convention centre and former hospital in the Custom House area of Newham, East London. It is situated on a site on the northern quay of the Ro ...
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
Selenium is a chemical element with the symbol Se and atomic number 34. It is a nonmetal (more rarely considered a metalloid) with properties that are intermediate between the elements above and below in the periodic table, sulfur and telluriu ...
.
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
The Apache () are a group of culturally related Native American tribes in the Southwestern United States, which include the Chiricahua, Jicarilla, Lipan, Mescalero, MimbreƱo, Ndendahe (Bedonkohe or Mogollon and Nednhi or CarrizaleƱo an ...
*
Open Packaging Conventions
The Open Packaging Conventions (OPC) is a container-file technology initially created by Microsoft to store a combination of XML and non-XML files that together form a single entity such as an Open XML Paper Specification (OpenXPS) document. OPC-b ...
*
Office Open XML software
This is an overview of software support for the Office Open XML format, a document file format for saving and exchanging editable office documents.
The list here is not exhaustive.
ECMA-376 1st edition implementations
The ECMA-376 1st edition ...
References
External links
*
*
* {{Citation , url = http://mvnrepository.com/artifact/net.sourceforge.jexcelapi/jxl, title = Jxl - MAVEN repository
Microsoft Office-related software
Java platform
Java (programming language) libraries
Cross-platform free software