POI 写入 Excel 时设置样式的例子

import java.io.BufferedInputStream;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.OutputStream;
import java.util.ArrayList;
import java.util.List;

import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hssf.util.HSSFColor;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.CellStyle;
import org.apache.poi.ss.usermodel.CreationHelper;
import org.apache.poi.ss.usermodel.Font;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;

public class ExcelUtils {

	/**
	 * 
	 * @param filePath
	 *            Excel 文件路径
	 * @param titleRow
	 *            标题栏 行号，1=第一行
	 * @param startRow
	 *            从第几行开始读取数据，1=第一行
	 * @return 读取到的数据集
	 */
	public static List<String[]> readExcel2003(String filePath, int titleRow, int startRow) {
		List<String[]> list = null;
		try {
			// System.out.println( "> > > start read..." );
			List<String[]> list_read = new ArrayList<String[]>();
			File excel_file = new File(filePath);// 读取的文件路径
			FileInputStream input = new FileInputStream(excel_file); // 读取的文件路径
			HSSFWorkbook wb = new HSSFWorkbook(new BufferedInputStream(input));
			Sheet sheet = wb.getSheetAt(0); // 读取第一个 sheet

			int maxRowNumber = sheet.getPhysicalNumberOfRows();// 获取总行数，保留空行
			// System.out.println( "总行数（包括空行）:"+maxRowNumber );
			// System.out.println( "标题行:"+startRow );
			// System.out.println( "开始行:"+startRow );
			int maxCellNumber = sheet.getRow(titleRow - 1).getPhysicalNumberOfCells(); // 获取总列数
			// System.out.println( "总列数:"+maxCellNumber );
			for (int r = startRow - 1; r < maxRowNumber; r++) {
				Row row = sheet.getRow(r);
				String[] cellObject = new String[maxCellNumber];
				for (int s = 0; s < maxCellNumber; s++) {
					Cell cell = row.getCell(s);
					if (cell != null) {
						// cellObject[s] = String.valueOf(cell);

						// 把数字当成String来读，避免出现1读成1.0的情况
						if (cell.getCellType() == Cell.CELL_TYPE_NUMERIC) {
							cell.setCellType(Cell.CELL_TYPE_STRING);
						}
						// 判断数据的类型
						switch (ce