JXL (API)


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

Microsoft Excel support

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

Usage

JXL 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