java生成excel

package test.poi;import java.io.File;import java.io.FileOutputStream;import java.io.OutputStream;import java.util.ArrayList;import java.util.List;import java.util.Map;import jxl.Workbook;import jxl.format.Alignment;import jxl.format.Border;import jxl.format.BorderLineStyle;import jxl.format.Colour;import jxl.format.UnderlineStyle;import jxl.write.Label;import jxl.write.WritableCellFormat;import jxl.write.WritableFont;import jxl.write.WritableSheet;import jxl.write.WritableWorkbook;public class createExcel {    public static void main(String[] args) {        createExcel();    }    public static void createExcel() {        try {            File file = new File("f://text.xls");            OutputStream os = new FileOutputStream(file);            WritableWorkbook wwb = Workbook.createWorkbook(os);            WritableSheet ws = wwb.createSheet("sheet1", 0);            //根据月份获取对象集            List<Map<String,String>> list=new ArrayList<Map<String,String>>();            //设置单元格格式            WritableFont wf = new WritableFont(WritableFont.ARIAL, 11,WritableFont.BOLD, false, UnderlineStyle.NO_UNDERLINE,Colour.WHITE);            WritableCellFormat cellFormat = new WritableCellFormat(wf);            cellFormat.setBorder(Border.ALL, BorderLineStyle.THIN,Colour.BLUE_GREY);            cellFormat.setAlignment(Alignment.CENTRE);            cellFormat.setBackground(Colour.BLUE);            //第一行            Label label = new Label(0, 0, "序号");            label.setCellFormat(cellFormat);            ws.addCell(label);            label = new Label(1, 0, "姓名 ");            label.setCellFormat(cellFormat);            ws.addCell(label);            //合并单元格            ws.mergeCells(2, 0, 3, 0);            label = new Label(2, 0, "合并单元格");            label.setCellFormat(cellFormat);            ws.addCell(label);                                //第二行            label = new Label(0, 1, "1");            ws.addCell(label);            label = new Label(1, 1, "姓名");            ws.addCell(label);            label = new Label(2, 1, "合并1");            ws.addCell(label);            label = new Label(3, 1, "合并2");            ws.addCell(label);            //第三行            label = new Label(0, 2, "2");            ws.addCell(label);            label = new Label(1, 2, "姓名");            ws.addCell(label);            label = new Label(2, 2, "合并1");            ws.addCell(label);            label = new Label(3, 2, "合并2");            ws.addCell(label);            //添加数据            wwb.write();            wwb.close();            System.out.PRintln("生成信息表(Excel格式)成功");        } catch (Exception e) {            System.out.println("生成信息表(Excel格式)时出错：");            e.printStackTrace();        }    }}