Java Excel API

Last updated

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

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:

importjava.io.File;importjxl.Workbook;importjxl.write.WritableSheet;importjxl.write.WritableWorkbook;importjxl.write.Label;importjxl.write.WriteException;publicclassDataSheet{privateWorkbookwbook;privateWritableWorkbookwwbCopy;privateWritableSheetshSheet;publicvoidreadExcel(){try{wbook=Workbook.getWorkbook(newFile("path/testSampleData.xls"));wwbCopy=Workbook.createWorkbook(newFile("path/testSampleDataCopy.xls"),wbook);shSheet=wwbCopy.getSheet(0);}catch(Exceptione){e.printStackTrace();}}publicvoidsetValueIntoCell(StringstrSheetName,intiColumnNumber,intiRowNumber,StringstrData)throwsWriteException{WritableSheetwshTemp=wwbCopy.getSheet(strSheetName);LabellabTemp=newLabel(iColumnNumber,iRowNumber,strData);try{wshTemp.addCell(labTemp);}catch(Exceptione){e.printStackTrace();}}publicvoidcloseFile(){try{// Closing the writable work bookwwbCopy.write();wwbCopy.close();// Closing the original work bookwbook.close();}catch(Exceptione){e.printStackTrace();}}publicstaticvoidmain(String[]args)throwsWriteException{DataSheetds=newDataSheet();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

References

  1. ↑ "jxlapi". Sourceforge. Retrieved 16 August 2023.
  2. 1 2 Sams, P. (2015). Selenium Essentials. Birmingham: Packt publishing Ltd. p. 133.
  3. ↑ "How to Set Data into Excel sheet using jxl". Selenium Easy. Retrieved 1 February 2016.
This page is based on this Wikipedia article
Text is available under the CC BY-SA 4.0 license; additional terms may apply.
Images, videos and audio are available under their respective licenses.