Java使用POI导出Excel工具类（反射）

pom.xml:

	<dependency>
      <groupId>org.apache.poi</groupId>
      <artifactId>poi</artifactId>
      <version>3.6</version>
    </dependency>

工具类：

import org.apache.poi.hssf.usermodel.*;

import java.lang.reflect.Field;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

/**
 * Excel导出工具类
 * @author Bryan
 * @since 2017/11/23 16:44
 */
public class ExcelUtil {

    private static Map<String,String> exportFields = new HashMap<String, String>();

    //初始化属性Map
    static {
        exportFields.put("name","活动名称");
        exportFields.put("content","活动内容");
        exportFields.put("population","活动人数");
        exportFields.put("provideMeal","提供餐饮");
        exportFields.put("provideHotel","提供住宿");
        exportFields.put("organization","主办单位");
        exportFields.put("tel","电话");
        exportFields.put("qq","负责人qq");
        exportFields.put("time","活动时间");
        exportFields.put("budget","活动经费");
        exportFields.put("certificate","活动证书");
        exportFields.put("status","活动状态");
    }

    /**
     * 获取Excel实体
     * @param sheetName sheet名字
     * @param list 对象集合
     * @return Excel实体
     * @throws IllegalAccessException 安全权限异常
     */
    public static HSSFWorkbook getHSSFWorkbook(String sheetName, List list) throws IllegalAccessException {

        //获取对象所有属性
        Field[] fields = list.get(0).getClass().getDeclaredFields();

        //表头数组
        String[] title = new String[fields.length];

        //设置表头
        for (int i = 0 ; i < fields.length ; i ++) {
            //获取属性
            Field field = fields[i];
            //设置该属性可访问
            field.setAccessible(true);
            //在属性Map中找到该属性对应表头
            title[i] = exportFields.get(field.getName());
        }

        // 第一步，创建一个workbook，对应一个Excel文件
        HSSFWorkbook workbook = new HSSFWorkbook();

        // 第二步，在workbook中添加一个sheet,对应Excel文件中的sheet
        HSSFSheet sheet = workbook.createSheet(sheetName);

        // 第三步，在sheet中添加表头第0行,注意老版本poi对Excel的行数列数有限制short
        HSSFRow row = sheet.createRow(0);

        // 第四步，创建单元格，并设置值表头 设置表头居中
        HSSFCellStyle style = workbook.createCellStyle();
        style.setAlignment(HSSFCellStyle.ALIGN_CENTER); // 创建一个居中格式

        HSSFCell cell = null;

        //创建标题
        for(int i=0;i < title.length;i++){
            cell = row.createCell(i);
            cell.setCellValue(title[i]);
            cell.setCellStyle(style);
        }

        //创建内容
        for(int i = 0 ; i < list.size() ; i ++) {
            row = sheet.createRow(i + 1);
            for(int j = 0 ; j < fields.length ; j ++) {
                Field field = fields[j];
                field.setAccessible(true);
                String value = String.valueOf(field.get(list.get(0)));
                row.createCell(j).setCellValue(value);
            }
        }
        return workbook;
    }
}

测试类：

import com.taiji.jilin.common.entity.Activity;
import com.taiji.jilin.common.util.ExcelUtil;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.junit.Test;

import java.io.*;
import java.io.OutputStream;
import java.util.ArrayList;
import java.util.List;

/**
 * @author Bryan
 * @since 2017/11/23 13:58
*/

public class ExcelTest {

    @Test
    public void test () throws Exception {
        String fileName = "test.xls";
        String sheetName = "sheet1";

        List<Activity> activities = new ArrayList<Activity>();
        for (int i = 0 ; i < 10 ; i ++ ) {
            Activity activity = new Activity();
            activity.setName("名称");
            activity.setContent("内容");
            activity.setCertificate("证书");
            activity.setIsFinish(1);
            activity.setBudget("预算");
            activity.setId(123);
            activity.setOrganization("组织");
            activity.setPopulation(123456);
            activity.setProvideHotel("是");
            activity.setProvideMeal("餐饮");
            activity.setQq("QQ");
            activity.setTel("电话");
            activity.setTime("时间");
            activity.setStatus("啊啊啊");
            activities.add(activity);
        }
        HSSFWorkbook hssfWorkbook = ExcelUtil.getHSSFWorkbook(sheetName,activities);
        File file = new File("F:\\Shanjz" + fileName);
        OutputStream outputStream = null;
        try {
            outputStream = new FileOutputStream(file);
            hssfWorkbook.write(outputStream);
            outputStream.flush();
            outputStream.close();
        } catch (FileNotFoundException e) {
            e.printStackTrace();
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
}