excel导出多重表头utils_poi导出Excel报表多表头双层表头、合并单元格

效果图：

controller层方法：

/**

*

* 导出Excel报表

* @param request

* @return

*

*/

@RequestMapping("/export")

@ResponseBody

public void export(HttpServletRequest request,

HttpServletResponse response, String yearMonth) {

try {

SimpleDateFormat dateFmt = new SimpleDateFormat("yyyy-MM-dd");

Map params = new HashMap();

params.put("yearMonth", yearMonth + "%");

List list = temperHumidityService

.getList(params);

for (int i = 0; i < list.size(); i++) {

Date date = list.get(i).getRecordDate();

String dateStr = dateFmt.format(date);

dateStr = dateStr.replace(yearMonth + "-", "");

list.get(i).setRecordDay(dateStr);

}

Map map = new HashMap();

map.put(1, "晴");

map.put(2, "多云");

map.put(3, "阴");

map.put(4, "小雨");

map.put(5, "中雨");

map.put(6, "大雨");

map.put(7, "大到暴雨");

map.put(8, "雾");

map.put(9, "霾");

// 构造导出数据

List> dataList = new ArrayList>();

for (int i = 0; i < list.size(); i++) {

TemperHumidityModel model = list.get(i);

Map tmpMap = new HashMap();

tmpMap.put("date", model.getRecordDay());

if(model.getWeather() == 1) {

tmpMap.put("weather", map.get(1));

}else if(model.getWeather() == 2) {

tmpMap.put("weather", map.get(2));

}else if(model.getWeather() == 3) {

tmpMap.put("weather", map.get(3));

}else if(model.getWeather() == 4) {

tmpMap.put("weather", map.get(4));

}else if(model.getWeather() == 5) {

tmpMap.put("weather", map.get(5));

}else if(model.getWeather() == 6) {

tmpMap.put("weather", map.get(6));

}else if(model.getWeather() == 7) {

tmpMap.put("weather", map.get(7));

}else if(model.getWeather() == 8) {