JXL
1 Overview
1 Overview
Home page: http://jexcelapi.sourceforge.net/
JXL 是一个开源的 Excel 开发库,支持 Excel 95, 97, 2000, XP 和 2003
下面是一个示例
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(); } }