POI导出Excel:

---

自己整理的POI导出Excel:

-

pox.xml 配置文件里面添加 poi:

这里使用的是POI3.16版本——POI

        <!-- POI -->    
        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi</artifactId>
            <version>3.16</version>
        </dependency>
        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi-ooxml</artifactId>
            <version>3.16</version>
        </dependency>
        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi-ooxml-schemas</artifactId>
            <version>3.16</version>
        </dependency>
        <!-- POI end -->

ExportExcel工具:

import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.lang.reflect.Field;
import java.math.BigDecimal;
import java.sql.Timestamp;
import java.text.DecimalFormat;
import java.text.NumberFormat;
import java.text.SimpleDateFormat;
import java.util.Collection;
import java.util.Date;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Map;

import javax.swing.JOptionPane;

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFDataFormat;
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.ss.usermodel.HorizontalAlignment;

public class ExportExcel<T> {
    /**
     * 这一段为测试代码;
     * 测试实体类:(直接封装即可)
     * public class Student {
     *   private Integer id;
     *   private String name;
     *   private String sex;
     */
     public static void main(String[] args) {
            // 声明一个工作薄
        HSSFWorkbook wb = new HSSFWorkbook();
        // 声明一个单子并命名
        HSSFSheet sheet = wb.createSheet("学生表");
        // 给单子名称一个长度
        sheet.setDefaultColumnWidth((short) 15);
        // 生成一个样式
        HSSFCellStyle style = wb.createCellStyle();
        // 创建第一行（也可以称为表头）
        HSSFRow row = sheet.createRow(0);
        // 样式字体居中
        style.setAlignment(HorizontalAlignment.CENTER);
        // 给表头第一行一次创建单元格
        HSSFCell cell = row.createCell((short) 0);
        cell.setCellValue("学生编号");
        cell.setCellStyle(style);
        cell = row.createCell((short) 1);
        cell.setCellValue("学生姓名");
        cell.setCellStyle(style);
        cell = row.createCell((short) 2);
        cell.setCellValue("学生性别");
        cell.setCellStyle(style);

        // 添加一些数据，这里先写死，大家可以换成自己的集合数据
        List<Student> list = new ArrayList<Student>();

        list.add(new Student(123, "123", "465"));
        list.add(new Student(111, "李四", "男"));
        list.add(new Student(111, "王五", "女"));

        // 向单元格里填充数据
        for (short i = 0; i < list.size(); i++) {
            row = sheet.createRow(i + 1);
            row.createCell(0).setCellValue(list.get(i).getId());
            row.createCell(1).setCellValue(list.get(i).getName());
            row.createCell(2).setCellValue(list.get(i).getSex());
        }

        try {
            // 默认导出到E盘下
            FileOutputStream out = new FileOutputStream("E://学生表.xls");
            wb.write(out);
            out.close();
            JOptionPane.showMessageDialog(null, "导出成功!");
        } catch (FileNotFoundException e) {
            JOptionPane.showMessageDialog(null, "导出失败!");
            e.printStackTrace();
        } catch (IOException e) {
            JOptionPane.showMessageDialog(null, "导出失败!");
            e.printStackTrace();
        }
    }
//测试结束;
//************************

    /**
     * 
     * @param title
     *            表格标题名
     * @param headersName
     *            表格属性列名数组
     * @param headersId
     *            表格属性列名对应的字段
     * @param dataset
     *            需要显示的数据集合,集合中一定要放置符合javabean风格的类的对象
     * @param out
     *            与输出设备关联的流对象，可以将EXCEL文档导出到本地文件或者网络中
     */

    public void exportExcel(String title, String[] headersName,
            String[] headersId, List<T> dtoList) {
        // 表头
        Map<Integer, String> map = new HashMap<Integer, String>();
        int key = 0;
        for (int i = 0; i < headersName.length; i++) {
            if (!headersName[i].equals(null)) {
                map.put(key, headersName[i]);
                key++;
            }
        }
        // 字段
        Map<Integer, String> zdMap = new HashMap<Integer, String>();
        int value = 0;
        for (int i = 0; i < headersId.length; i++) {
            if (!headersId[i].equals(null)) {
                zdMap.put(value, headersId[i]);
                value++;
            }
        }
        // 声明一个工作薄
        HSSFWorkbook wb = new HSSFWorkbook();
        HSSFSheet sheet = wb.createSheet(title);
        sheet.setDefaultColumnWidth((short) 15);
        // 生成一个样式
        HSSFCellStyle style = wb.createCellStyle();
        HSSFRow row = sheet.createRow(0);
        style.setAlignment(HorizontalAlignment.CENTER);
        HSSFCell cell;
        Collection c = map.values();
        Iterator<String> it = c.iterator();
        // 根据选择的字段生成表头
        short size = 0;
        while (it.hasNext()) {
            cell = row.createCell(size);
            cell.setCellValue(it.next().toString());
            cell.setCellStyle(style);
            size++;
        }
        // 字段
        Collection zdC = zdMap.values();
        Iterator<T> labIt = dtoList.iterator();
        int zdRow = 0;
        while (labIt.hasNext()) {
            // int zdCell = 0;
            zdRow++;
            row = sheet.createRow(zdRow);
            T l = (T) labIt.next();
            // 利用反射，根据javabean属性的先后顺序，动态调用getXxx()方法得到属性值
            Field[] fields = l.getClass().getDeclaredFields();
            for (short i = 0; i < fields.length; i++) {
                Field field = fields[i];
                field.setAccessible(true);
                // String fieldName = field.getName();
                Object val;
                try {
                    val = field.get(l);
                    // System.out.println(val);
                    String type = field.getType().toString();// 得到此属性的类型
                    // System.out.println(type);

                    if (type.endsWith("String")) {
                        row.createCell(i).setCellValue((String) val);
                    } else if (type.endsWith("int") || type.endsWith("Integer")) {
                        row.createCell(i).setCellValue((double) val);
                    } else if (type.endsWith("Boolean")) {
                        row.createCell(i).setCellValue((boolean) val);
                    } else if (type.endsWith("Date")) {
                        // 如果是日期格式,设置单元格格式;
                        HSSFCell cella = row.createCell(i);
                        cella.setCellValue((Date) val);
                        HSSFCellStyle cellStyle = wb.createCellStyle();
                        HSSFDataFormat format = wb.createDataFormat();
                        cellStyle.setDataFormat(format.getFormat("yyyy-MM-dd"));
                        cella.setCellStyle(cellStyle);
                    } else if (type.endsWith("Timestamp")) {
                        // 如果是日期格式,设置单元格格式;
                        HSSFCell cella = row.createCell(i);
                        cella.setCellValue((Date) val);
                        HSSFCellStyle cellStyle = wb.createCellStyle();
                        HSSFDataFormat format = wb.createDataFormat();
                        cellStyle.setDataFormat(format
                                .getFormat("yyyy-MM-dd HH:mm"));
                        cella.setCellStyle(cellStyle);
                    } else if (type.endsWith("BigDecimal")) {
                        row.createCell(i).setCellValue((double) val);
                    }

                } catch (IllegalArgumentException e) {
                    // TODO Auto-generated catch block
                    e.printStackTrace();
                } catch (IllegalAccessException e) {
                    // TODO Auto-generated catch block
                    e.printStackTrace();
                }
            }
        }

        try {
            FileOutputStream xls = new FileOutputStream("E://学生表AB.xls");
            wb.write(xls);
            xls.close();
            // JOptionPane.showMessageDialog(null, "导出成功!");
        } catch (FileNotFoundException e) {
            // JOptionPane.showMessageDialog(null, "导出失败!");
            e.printStackTrace();
        } catch (IOException e) {
            // JOptionPane.showMessageDialog(null, "导出失败!");
            e.printStackTrace();
        }

    }
}

---

控制器Controller:

    /**
     * 
     * @return
     */
    @RequestMapping("/outexcel")
    public String outall() {
        String title = "表名称";
        //列名称:
        String[] headersName = { "一", "二", "三", "四", "五", "六", "七", "八", "九",
                "十", "十一", "十二" };
        //对应实体名(顺序一致);      
        String[] headersId = { "StoreLevelId", "SingleStoresLevel", "isShow",
                "SlState", "StoreLevelItemId", "LevelItemName", "FieldType",
                "OrderValue", "BusinessExplain", "SliState" };
        //数据集合
        List<StoreLevelResult> dtoList = sLevelServices.getLevelResults();

        excel.exportExcel(title, headersName, headersId, dtoList);
        //重定向
        return "redirect:***";
    }

---

测试效果

*
*
*

笔记;
我是一个新手;正在慢慢充实自己;
文章内容转载自:
Java利用POI实现数据的Excel导出