POI导出Excle HSSF

package com.sk.utils;

import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;

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.hssf.util.HSSFColor;

/**
 * 生成导出Excel文件对象
 * 
 * @author chico
 * 
 */
public class ExportExcel {
	private static HSSFFont fontStyle = null;
	private static HSSFCellStyle cellStyle = null;

	public static HSSFFont getTitleFont(HSSFWorkbook wb) {
		fontStyle = wb.createFont();
		fontStyle.setFontName("宋体");
		fontStyle.setFontHeightInPoints((short) 12);
		fontStyle.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);//字体加粗
		return fontStyle;
	}
	
	public static HSSFFont getContentFont(HSSFWorkbook wb) {
		fontStyle = wb.createFont();
//		fontStyle.setFontName("宋体");
//		fontStyle.setFontHeightInPoints((short) 12);
		fontStyle.setBoldweight(HSSFFont.BOLDWEIGHT_NORMAL);
		return fontStyle;
	}
	
	public static HSSFCellStyle getTitleStyle(HSSFWorkbook workbook){
		cellStyle = workbook.createCellStyle(); // 在工作薄的基础上建立一个样式
		cellStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN); // 左边框
		cellStyle.setBorderRight(HSSFCellStyle.BORDER_THIN); // 右边框
		cellStyle.setBorderTop(HSSFCellStyle.BORDER_THIN); // 顶边框
		cellStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN); // 底边框
		cellStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);//垂直居中
		cellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);//水平居中
//		cellStyle.setFillForegroundColor(HSSFColor.LIGHT_ORANGE.index); // 填充的背景颜色
		cellStyle.setFont(getTitleFont(workbook));
		return cellStyle;
	}
	
	public static HSSFCellStyle getContentStyle(HSSFWorkbook workbook){
		cellStyle = workbook.createCellStyle(); // 在工作薄的基础上建立一个样式
		cellStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN); // 左边框
		cellStyle.setBorderRight(HSSFCellStyle.BORDER_THIN); // 右边框
		cellStyle.setBorderTop(HSSFCellStyle.BORDER_THIN); // 顶边框
		cellStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN); // 底边框
		cellStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);//垂直居中
		cellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);//水平居中
//		cellStyle.setFillForegroundColor(HSSFColor.LIGHT_ORANGE.index); // 填充的背景颜色
//		cellStyle.setFont(getContentFont(workbook));
		return cellStyle;
	}
	
	public static HSSFCellStyle getLeftContentStyle(HSSFWorkbook workbook){
		cellStyle = workbook.createCellStyle(); // 在工作薄的基础上建立一个样式
		cellStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN); // 左边框
		cellStyle.setBorderRight(HSSFCellStyle.BORDER_THIN); // 右边框
		cellStyle.setBorderTop(HSSFCellStyle.BORDER_THIN); // 顶边框
		cellStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN); // 底边框
		cellStyle.setVerticalAlignment(HSSFCellStyle.ALIGN_FILL);//垂直居中
//		cellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);//水平居中
//		cellStyle.setFillForegroundColor(HSSFColor.LIGHT_ORANGE.index); // 填充的背景颜色
//		cellStyle.setFont(getContentFont(workbook));
		return cellStyle;
	}
	
	public static void createTitleRow(HSSFRow curRow,HSSFWorkbook workbook){
		HSSFCell curCell = curRow.createCell(0);
		curCell.setCellStyle(getTitleStyle(workbook));
		curCell.setCellValue("姓名");
		HSSFCell curCell2 = curRow.createCell(1);
		curCell2.setCellStyle(getTitleStyle(workbook));
		curCell2.setCellValue("项目");
	}
	
	public static void createContentRow(HSSFCell curCell,HSSFWorkbook workbook,String value){
		curCell.setCellStyle(ExportExcel.getContentStyle(workbook));
		curCell.setCellValue(value);
	}
	
	public static void createLeftContentRow(HSSFCell curCell,HSSFWorkbook workbook,String value){
		curCell.setCellStyle(ExportExcel.getLeftContentStyle(workbook));
		curCell.setCellValue(value);
	}

	public static void main(String[] args) {
		HSSFWorkbook workbook = new HSSFWorkbook(); // 建立一个工作薄
		
		HSSFSheet sheet = workbook.createSheet();
		sheet.setDefaultRowHeightInPoints(15);
		sheet.setDefaultColumnWidth(50);
		
		HSSFRow curRow = sheet.createRow(0);
		HSSFCell curCell = curRow.createCell(0);
		curCell.setCellStyle(getTitleStyle(workbook));
		curCell.setCellValue("姓名");
		HSSFCell curCell2 = curRow.createCell(1);
		curCell2.setCellStyle(getTitleStyle(workbook));
		curCell2.setCellValue("项目");
		FileOutputStream fos;
		try {
			fos = new FileOutputStream("D:\\test.xls");
			workbook.write(fos);
			fos.close();
		} catch (FileNotFoundException e) {
			e.printStackTrace();
		} catch (IOException e) {
			e.printStackTrace();
		}

		// titleStyle.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND); // 填充图案
		// 假设什么定义了一个样式，想在填充第一个单元格的时候填充红，第二格单元格填充蓝色。
		// 如果:
		// HSSFCellStyle cellStyle = workbook.createCellStyle(); // 创建一个样式
		// cellStyle.setFillForegroundColor(HSSFColor.RED.index); // 设置颜色为红色
		// cellStyle.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);
		// HSSFCell cell1 = row.createCell((short) 1); // 给单元格cell1填充红色
		// cell1.setCellStyle(cellStyle);
		// 若:
		// cellStyle.setFillForegroundColor(HSSFColor.BLUE.index); // 设置颜色为蓝色
		// HSSFCell cell2 = row.createCell((short) 2); // 给单元格cell2填充蓝色
		// cell2.setCellStyle(cellStyle);
	}

}