ExcelUtil.java
来源:互联网 发布:950 600淘宝轮播图 编辑:程序博客网 时间:2024/05/21 02:19
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<<json1990@foxmail.com>> */ 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);; } }
阅读全文
0 0
- ExcelUtil.java
- ExcelUtil.java
- ExcelUtil
- excelUtil
- ExcelUtil
- ExcelUtil
- ExcelUtil
- ExcelUtil
- ExcelUtil
- java 导入导出Excel工具类ExcelUtil
- Java导入导出Excel工具类ExcelUtil
- Java导入导出Excel工具类ExcelUtil
- java 导入导出Excel工具类ExcelUtil
- Java导入导出Excel工具类ExcelUtil
- java 导入导出Excel工具类ExcelUtil
- Java导入导出Excel工具类ExcelUtil
- 导入导出Excel的Java工具类ExcelUtil 之jxl
- ExcelUtil工具类,使用Java代码操作Excel表格
- 线程的实现
- Redis入门
- python 多维数组的排序
- ExcelUtil.java
- [ProtoBuf]ProtoBuf原理
- ExcelUtil.java
- Linux下的rsync命令
- 2.常用控件:CheckBox
- eclipse
- 利用Bmob + ImageLoader 加载网络图片
- nginx: [error] invalid PID number "" in "/run/nginx.pid"
- Android基础_创建自定义xml图片(二)
- Sum Root to Leaf Numbers问题及解法
- qrcode生成二维码