利用apache poi来创建excel报表的例子，可供学习

要用到poi创建excel的同志来这里看看，会的给点意见，不会的学习学习，

 

 

注：poi的jar包自己到官网下载

 

package com.poi;

import java.io.File;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.util.ArrayList;
import java.util.List;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.CellStyle;
import org.apache.poi.ss.usermodel.Font;
import org.apache.poi.ss.usermodel.IndexedColors;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;

public class WorkBook {
    public static void main(String[] args) {
    	String outPath = "D:\\输出文档";
    	WorkBook workBook = new WorkBook();
    	List<String> emplist = new ArrayList<String>();
    	StringBuffer sb = new StringBuffer();
    	for (int i = 0; i < 10; i++) {
			sb.append(i+"`");
			sb.append("卢水发"+i+"`");
			sb.append("158706885 -"+i+"`");
			sb.append("男");
			sb.append("java软件工程师");
			emplist.add(sb.toString());
			sb = new StringBuffer();
		}
		String result = workBook.createWorkBook(emplist,outPath);
    	System.out.println("程序创建工作本的结果是："+result);
	}
    
    /**
     * 工作本
     * @param outPath
     * @return
     */
    public String createWorkBook(List emplist,String outPath){
    	try {
    		File file = new File(outPath);
    		if(!file.exists()){
    			file.mkdirs();
    		}
    		//创建工作簿
			Workbook wb = new HSSFWorkbook();
			//创建工作表
			Sheet sheet1 = wb.createSheet("员工表");
			//创建一行
			for (int i = 0; i < emplist.size(); i++) {
				String emp = (String) emplist.get(i);
				String[] emps = emp.split("`");
				Row row = sheet1.createRow(i);
				System.out.println("第 "+i+" 行。"+emp);
				for (int j = 0; j < emps.length; j++) {
					 sheet1.setColumnWidth(j, 20 * 256);
					 sheet1.setDefaultRowHeight((short) (2 * 256));
					 createCell(wb,emps[j], row, (short) j, CellStyle.ALIGN_CENTER, CellStyle.ALIGN_CENTER);
				     System.out.println("第 "+i+" 行。第"+j+"单元格");
				}
			}
		    Sheet sheet2 = wb.createSheet("考勤表");
		    Sheet sheet3 = wb.createSheet("宝宝表");
			FileOutputStream fileOut = new FileOutputStream(file+"\\workbook.xls");
			wb.write(fileOut);
			fileOut.close();
			return "输出"+file+"成功了！";
		} catch (FileNotFoundException e) {
			e.printStackTrace();
		} catch (IOException e) {
			e.printStackTrace();
		}
		return "出错了！";
    }
    
    //设置表格的对齐样式
    private static void createCell(Workbook wb,String cellValue, Row row, short column, short halign, short valign) {
        Cell cell = row.createCell(column);
        cell.setCellValue(cellValue);
        CellStyle cellStyle = wb.createCellStyle();
        cellStyle.setAlignment(halign);
        cellStyle.setVerticalAlignment(valign);
        //设置边框颜色
        cellStyle.setBorderBottom(CellStyle.BORDER_THIN);
        cellStyle.setBottomBorderColor(IndexedColors.GREEN.getIndex());
        cellStyle.setBorderLeft(CellStyle.BORDER_THIN);
        cellStyle.setLeftBorderColor(IndexedColors.GREEN.getIndex());
        cellStyle.setBorderRight(CellStyle.BORDER_THIN);
        cellStyle.setRightBorderColor(IndexedColors.GREEN.getIndex());
        cellStyle.setBorderTop(CellStyle.BORDER_THIN);
        cellStyle.setTopBorderColor(IndexedColors.GREEN.getIndex());
        //设置字体
        Font font = wb.createFont();
        font.setFontHeightInPoints((short)12);
        font.setFontName("Courier New");
        font.setItalic(false);
        font.setBoldweight((short)2);
        cellStyle.setFont(font);
        cell.setCellStyle(cellStyle);
    }
}