用Java生成exel文件并写入内容

package org.yxp.hrm.base.exel; import java.io.FileNotFoundException; import java.io.FileOutputStream; import java.io.IOException; import org.apache.commons.lang3.StringUtils; import org.apache.poi.hssf.usermodel.HSSFCell; import org.apache.poi.hssf.usermodel.HSSFRow; import org.apache.poi.hssf.usermodel.HSSFSheet; import org.apache.poi.hssf.usermodel.HSSFWorkbook; /** *author YXP *@date 2012-9-5 *package_name org.yxp.hrm.base.exel *project_name hrm */ public final class ExelTool { // sheetName, String[] headerTitle, List<T> bean, filename, response public static void main(String[] args) { //把一个字符串的首字母大写 System.out.println(StringUtils.capitalize("name")); // 创建一个工作簿 HSSFWorkbook book = new HSSFWorkbook(); // 通过工作簿创建一个工作单 HSSFSheet sheet = book.createSheet("J1203"); // 创建工作单中的一个行(作为标题) HSSFRow row = sheet.createRow(0); String[] headTile = new String[]{"编号" , "姓名"}; for(int i = 0 ; i < headTile.length ; i ++){ HSSFCell cell = row.createCell(i); cell.setCellValue(headTile[i]); } // 创建内容行 for(int i = 0 ; i < 3 ; i ++){ row = sheet.createRow(i + 1); for(int j = 0 ; j < headTile.length ; j ++){ HSSFCell cell = row.createCell(j); cell.setCellValue("姚想平" + i + j); } } try { book.write(new FileOutputStream("E:\\hrm.xls")); } catch (FileNotFoundException e) { e.printStackTrace(); } catch (IOException e) { e.printStackTrace(); } } }