POI

下载地址：demo

package poi;

import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.io.PrintStream;

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFFont;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.BorderStyle;
import org.apache.poi.ss.usermodel.FillPatternType;
import org.apache.poi.ss.usermodel.HorizontalAlignment;
import org.apache.poi.ss.usermodel.IndexedColors;
import org.apache.poi.ss.usermodel.VerticalAlignment;
import org.apache.poi.ss.util.CellRangeAddress;

/**
 * 
 * @author bxh
 * 
 * HSSFWorkbook  工作薄
 * HSSFSheet     sheet 
 * HSSFRow       单元行
 * HSSFCell      单元格
 * 
 * 
 * HSSFDataFormat  日期格式
 * BorderStyle     边框风格
 * IndexedColors   颜色枚举
 */
public class MyExcel {
    private final String fileName="c://debug.xls";
    private HSSFWorkbook wb;
    private HSSFSheet    sheet;
    private HSSFCellStyle style;
    public MyExcel() {
        File file = new File(fileName);
        if(file.exists()){
            FileInputStream io;
            try {
                io    = new FileInputStream(file);
                wb    = new HSSFWorkbook(io);
                sheet = wb.getSheetAt(0);
            } catch (FileNotFoundException e) {
                e.printStackTrace();
            } catch (IOException e) {
                e.printStackTrace();
            }
        }else{
            wb    =   new HSSFWorkbook();
            sheet = wb.createSheet("sheet1");

            initTitle();

        }
    }
    /**
     * excle标题
     */
    private void initTitle() {
        HSSFRow  titleRow      = sheet.createRow(0);
        HSSFCell cellName = titleRow.createCell(0);
        HSSFCell cellSex  = titleRow.createCell(1);
        HSSFCell cellAge  = titleRow.createCell(2);

        cellName.setCellValue("姓名");
        cellSex.setCellValue("性别");
        cellAge.setCellValue("年龄");

        initStyle();

        cellName.setCellStyle(style);
        cellSex.setCellStyle(style);
        cellAge.setCellStyle(style);
    }
    /**
     * 写出excel文件
     */
    public void writeToExcel(){
        PrintStream bookOut;
        try {
            bookOut = new PrintStream(fileName);
            wb.write(bookOut);
            wb.close();
        } catch (IOException e) {
            e.printStackTrace();
        }

    }
    /**
     * 写入单元格数据
     * @param s       单元夹
     * @param datas   数据  前面数组是  行  后面是数据列  
     *
     * {{cell,cell,cell},{cell,cell,cell}} 该记录有两个row 一个row 有3 个cell 
     */
    public void createRow(HSSFSheet s ,String datas [][] ){
        if(s==null){
            s=sheet;
        }
        //单元格总行数
        int rowNo= s.getLastRowNum()+1;
        for (int i = 0; i < datas.length; i++) {
            HSSFRow row = s.createRow(i+rowNo);
            for (int j = 0; j < datas[i].length; j++) {
                HSSFCell cell = row.createCell(j);
                cell.setCellValue(datas[i][j]);
            }
        }
    }

    /**
     * 合并单元格
     * @param sheet    合并的单元夹
     * @param firstRow 首个单元格开始位置
     * @param lastRow  最后单元格开始位置
     * @param firstCol 首个单元格结束始位置
     * @param lastCol  最后单元格结束位置
     */
    public void MergeExcel(HSSFSheet sheet,int firstRow,int lastRow, int firstCol,int lastCol){
        sheet.addMergedRegion( new CellRangeAddress(firstRow, lastRow, firstCol, lastCol));
    }
    public void initStyle(){
        style = wb.createCellStyle();

        // 设置这些样式
        style.setAlignment(HorizontalAlignment.CENTER);//水平居中 
        style.setVerticalAlignment(VerticalAlignment.CENTER);//垂直居中

         //背景色
        style.setFillPattern(FillPatternType.BIG_SPOTS); 
        style.setFillForegroundColor(IndexedColors.YELLOW.getIndex());
        style.setFillBackgroundColor(IndexedColors.YELLOW.getIndex()); 

        //设置边框
        style.setBorderBottom(BorderStyle.THIN);
        style.setBorderLeft(BorderStyle.THIN);
        style.setBorderRight(BorderStyle.THIN);
        style.setBorderTop(BorderStyle.THIN);  


        // 生成一个字体
        HSSFFont font = wb.createFont();
        font.setColor(IndexedColors.RED.getIndex());
        font.setFontHeightInPoints((short) 10);
        font.setFontName("微软雅黑");
        font.setBold(true);

        // 把字体 应用到当前样式
        style.setFont(font);

        //自动换行  
        style.setWrapText(true);

    }
}

package poi;

import java.util.Arrays;
import java.util.Collection;

import org.junit.Test;
import org.junit.runner.RunWith;
import org.junit.runners.Parameterized;
import org.junit.runners.Parameterized.Parameters;

@RunWith(value=Parameterized.class)
public class TestMyExcel {

    private String name ;
    private String sex;
    private String age ;

    public TestMyExcel(String name , String sex, String age) {
        this.age=age;
        this.name=name;
        this.sex=sex;
    }
    @Parameters
    public static Collection testDate(){
        return  Arrays.asList(new Object[][]{
                {"赵6","男","33"},
                {"张三","女","21"},
                {"李四","女","22"},
                {"王五","男","33"}

        });
    }

    /**
     * junit 测试入口  
     */
    @Test
    public void TestWookBook(){
        MyExcel myExcel = new MyExcel();
        myExcel.createRow(null, new String[][]{{name,sex,age}});
        myExcel.writeToExcel();

    }
}