一个用java来操纵excel的open source

一个用java来操纵excel的open source JExcelApi(jxl.jar)

import jxl.*;

import jxl.write.*;

import jxl.format.*;



jxl.write.WritableWorkbook wwb = Workbook.createWorkbook(os);

　　jxl.write.WritableSheet ws = wwb.createSheet("TestSheet1", 0);

　　jxl.write.Label labelC = new jxl.write.Label(0, 0, "我爱中国");

　　ws.addCell(labelC);

　　jxl.write.WritableFont wfc = new jxl.write.WritableFont(WritableFont.ARIAL,20, WritableFont.BOLD, false,

　　UnderlineStyle.NO_UNDERLINE, jxl.format.Colour.GREEN);

　　jxl.write.WritableCellFormat wcfFC = new jxl.write.WritableCellFormat(wfc);

　　wcfFC.setBackground(jxl.format.Colour.RED);

　　labelC = new jxl.write.Label(6, 0, "中国爱我",wcfFC);

　　ws.addCell(labelC);

　　//写入Exel工作表

　　wwb.write();

　　//关闭Excel工作薄对象

　　wwb.close();