Java Excel API

Developer(s)| Andy Khan, Eric H. Jung
Stable release|

2.6.12 / 8 October 2012

Written in| Java
Operating system| Cross-platform
Type| API to access Microsoft Excel format
License| GNU LGPL v2.1+[1]
Website| jexcelapi.sourceforge.net

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.[2]

## Contents

* 1 Microsoft Excel support
* 2 Usage
* 2.1 Example
* 3 See also
* 4 References
* 5 External links

## Microsoft Excel support

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

## 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

private Workbook wbook;
private WritableWorkbook wwbCopy;
private WritableSheet shSheet;

public void readExcel()

try

wbook = Workbook.getWorkbook(new File("path/testSampleData.xls"));
wwbCopy = Workbook.createWorkbook(new File("path/testSampleDataCopy.xls"), wbook);
shSheet = wwbCopy.getSheet(0);

catch (Exception e)

e.printStackTrace();

public void setValueIntoCell(String strSheetName, int iColumnNumber, int iRowNumber, String strData) throws WriteException

WritableSheet wshTemp = wwbCopy.getSheet(strSheetName);
Label labTemp = new Label(iColumnNumber, iRowNumber, strData);

try

wshTemp.addCell(labTemp);

catch (Exception e)

e.printStackTrace();

public void closeFile()

try

// Closing the writable work book
wwbCopy.write();
wwbCopy.close();

// Closing the original work book
wbook.close();

catch (Exception e)

e.printStackTrace();

public static void main(String[] args) throws WriteException

DataSheet ds = new DataSheet();
ds.readExcel();
ds.setValueIntoCell("sheet1", 5, 1, "PASS");
ds.setValueIntoCell("sheet1", 5, 2, "FAIL");
ds.setValueIntoCell("sheet1", 5, 3, "PASS");
ds.closeFile();

[3]

## See also

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

## References

1. ↑ "jxlapi". http://sourceforge.net/projects/jexcelapi/.
2. ↑ 2.0 2.1 Sams, P. (2015). Selenium Essentials. Birmingham: Packt publishing Ltd. pp. 133.
3. ↑ "How to Set Data into Excel sheet using jxl". http://www.seleniumeasy.com/jxl-tutorials/set-data-into-excelsheet-with-jxl.

## External links

* Java Excel API
* MAVEN repository
* Selenium tutorial

0.00

(0 votes)

Original source: https://en.wikipedia.org/wiki/Java Excel API. Read more

|

Retrieved from "https://handwiki.org/wiki/index.php?title=Software:Java_Excel_API&oldid=3469335"