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();
        }
    }
}

操作excel需用到jxl.jar这个jar包。

posted on 2015-10-13 13:35  程序员丁先生  阅读(457)  评论(0编辑  收藏  举报