JAVA操作Excel及其ExcelJAR包

只要记住Excel的组成结构就很好做了，Excel-->Sheet--->Cell

package excel;

import jxl.*;
import jxl.write.WritableWorkbook;
import jxl.write.*;

public class TestExcel {

/**
* @param args
*/
public static void main(String[] args) {

new TestExcel().getExcel();
new TestExcel().writeExcel();
}

//获取Excel
public void getExcel(){
Workbook b=null;
try {
b=Workbook.getWorkbook(new java.io.File("d:\\aa.xls"));
Sheet sheet=b.getSheet(0);
Cell[] cells=sheet.getRow(0);
String temp=cells[0].getContents();

System.out.println(temp);
} catch (Exception e) {
}
}

//生成Excel
public void writeExcel(){
WritableWorkbook wwb=null;
try {
wwb=Workbook.createWorkbook(new java.io.File("d:\\test.xls"));
WritableSheet sheet=wwb.createSheet("测试", 0);
Label l=new Label(0,0,"领用日期");
sheet.addCell(l);

wwb.write();
wwb.close();
} catch (Exception e) {
}
}


}

评论

2 楼 ayxyzlg 2009-10-30  

1 楼 lxh2002 2009-09-25  

谢谢,我前段时间也因为这个花费了一些时间.不过Apache下面的POI也非常不错,
对Excel的读写支持很好.