ExcelUtil.java

package com.jtools;   import java.io.FileOutputStream; import java.util.ArrayList; import java.util.HashMap; import java.util.List; import java.util.Map;   import org.apache.poi.hssf.usermodel.HSSFCell; import org.apache.poi.hssf.usermodel.HSSFCellStyle; import org.apache.poi.hssf.usermodel.HSSFRow; import org.apache.poi.hssf.usermodel.HSSFSheet; import org.apache.poi.hssf.usermodel.HSSFWorkbook;   /** * 基于poi导出excel * @author Json<<[e-mail]>> */ public class ExcelUtil { /** * 导出excel * @param fileName * @param sheetName * @param fieldNames * @param list * @return */ public static boolean exportExcel(String fileName,String sheetName,List<String>fieldNames,List<Map<String,Object>>list,StringouputPath){ HSSFWorkbook wb = new HSSFWorkbook(); HSSFSheet sheet = wb.createSheet(sheetName); HSSFRow row = sheet.createRow((int)0);   //样式 HSSFCellStyle style = wb.createCellStyle(); style.setAlignment(HSSFCellStyle.ALIGN_CENTER);   //设置表头 HSSFCell cell = null; int fieldSize = fieldNames.size(); for(int i=0;i<fieldSize;i++){ cell = row.createCell((short) i); cell.setCellValue(fieldNames.get(i)); cell.setCellStyle(style); }   //保存字段值 for (int i= 0; i < list.size(); i++) { row = sheet.createRow((int) i+ 1); for(int j=0;j<fieldSize;j++){ row.createCell((short) j).setCellValue((String) list.get(i).get(fieldNames.get(j))); } }   try { if(!ouputPath.endsWith("/")){ ouputPath += "/"; } FileOutputStream fout = new FileOutputStream(ouputPath+fileName+".xls"); wb.write(fout); fout.close(); return true; } catch (Exception e) { e.printStackTrace(); } return false; }   public static void main(String[] args) { List names = new ArrayList<String>(); names.add("姓名"); names.add("公司"); names.add("联系电话");   List list = new ArrayList<Map<String,Object>>(); Map<String,Object> map= new HashMap<String,Object>(); map.put("姓名","赵亚玲"); map.put("公司","摩拜单车"); map.put("联系电话","13223030418"); list.add(map);   Map<String,Object> map1= new HashMap<String,Object>(); map1.put("姓名","王思聪"); map1.put("公司","熊猫TV"); map1.put("联系电话","18823030418"); list.add(map1);   Map<String,Object> map2= new HashMap<String,Object>(); map2.put("姓名","贾跃亭"); map2.put("公司","乐视"); map2.put("联系电话","15523030418"); list.add(map2);   boolean b = exportExcel("信息表","信息表", names, list,"E:/output/"); System.out.println(b);; } }