讀Excel:
Workbook workbook = null;
try
{
workbook = Workbook.getWorkbook(new File(path));
}
catch(Exception e)
{
System.out.println(e);
}
Sheet sheet = workbook.getSheet(0);
Cell cell=sheet.getCell(i,j);//讀第i列，第j行表格的值
System.out.println(cell.getContents());
對于循環讀出可以使用
sheet.getRows();方法得到行數
sheet.getColumns();方法得到列數
寫Excel:
Workbook wb = Workbook.getWorkbook(new File(path));
WritableCellFormat wcf = new WritableCellFormat();
book = Workbook.createWorkbook(new File(path, wb);
sheet = book.getSheet(0);
jxl.write.Label name = new jxl.write.Label(i,j,"abc",wcf);//在第i列，第j行寫入"abc"值，風格為wcf，如果寫入的是數字則使用jxl.write.Number
sheet.addCell(name);
try
{
book.write();
book.close();
}
catch(WriteException e){}
catch(IOException e){}
單元格風格:
設置邊框—
WritableCellFormat wcf = new WritableCellFormat();
wcf.setVerticalAlignment(VerticalAlignment.CENTRE);
wcf.setBorder(Border.RIGHT,BorderLineStyle.THIN);
wcf.setBorder(Border.LEFT,BorderLineStyle.THIN);
wcf.setBorder(Border.BOTTOM,BorderLineStyle.THIN);
合并單元格-
sheet.mergeCells(0,1,0,2)
合并(0,1)、(0,2)兩個單元格
設置字體-
WritableFont wf = new WritableFont(WritableFont.ARIAL,12, WritableFont.BOLD, false);
WritableCellFormat wcf = new WritableCellFormat(wf);
以及其它各種單元格樣式，如設置背景顏色
都可以通過設置WritableCellFormat來設置
還有一點需要說明一下，JXL組件對于公式的支持似乎比Apache的poi好
posted on 2008-02-01 16:16
Dong 閱讀(4979)
評論(2) 編輯 收藏