JAVA将list导出为Excel

工具类部分

import org.apache.poi.hssf.usermodel.*;
import org.apache.poi.hssf.util.HSSFColor;
import org.apache.poi.ss.util.CellRangeAddress;

import javax.servlet.http.HttpServletResponse;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.OutputStream;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.List;

public class listToExcel{
	public static HSSFWorkbook getExcel(String title, List<String> list, int colNums) {
		HSSFWorkbook wb = new HSSFWorkbook();
		HSSFSheet sheet = wb.createSheet(title);
		HSSFRow row;
		HSSFCell cell;
		
		//标题
		HSSFCellStyle styleTitle = wb.createCellStyle();
		styleTitle.setAlignment(HSSFCellStyle.ALIGN_CENTER);
		HSSFFont fontTitle = wb.createFont();
		fontTitle.setFontHeightInPoints((short) 20);
		styleTitle.setFont(fontTitle);

		//表头
		HSSFCellStyle styleHead = wb.createCellStyle();
		HSSFFont fontHead = wb.createFont();
		fontHead.setFontHeightInPoints((short) 11);
		styleHead.setFont(fontHead);

		//表格
		HSSFCellStyle styleBody = wb.createCellStyle();
		HSSFFont fontBody = wb.createFont();
		fontBody.setFontHeightInPoints((short) 10);

		styleBody.setFont(fontBody);

		//尾注
		HSSFCellStyle styleFoot = wb.createCellStyle();
		HSSFFont fontFoot = wb.createFont();
		fontFoot.setFontHeightInPoints((short) 12);
		fontFoot.setColor(HSSFColor.DARK_GREEN.index);
		styleFoot.setFont(fontFoot);
		styleFoot.setFillForegroundColor(HSSFColor.YELLOW.index);
		
		//设置标题行
		row = sheet.createRow(0);
		cell = row.createCell(0);
		//行高
		row.setHeightInPoints((float) (10.75 * 3));
		//内容
		cell.setCellValue(title);
		//样式
		cell.setCellStyle(styleTitle);
		// 合并单元格 (始行，终行，始列，终列)
		sheet.addMergedRegion(new CellRangeAddress(0, 0, 0, colNums - 1));
		
		//设置表头
		row = sheet.createRow(1);
		//行高
		row.setHeightInPoints(15);
		//内容
		String str = list.get(0);
		String[] ary = str.split(",");
		for (int j = 0; j < ary.length; j++) {
			cell = row.createCell(j);
			cell.setCellValue(ary[j]);
			cell.setCellStyle(styleHead);
		}
		
		//设置表格内容
		for (int i = 2; i <= list.size(); i++) {
			//序号列
			row = sheet.createRow(i);
			cell = row.createCell(0);
			cell.setCellValue(i - 1);
			cell.setCellStyle(styleBody);

			//内容列
			str = list.get(i - 1);
			ary = str.split("，");
			for (int j = 1; j <= ary.length; j++) {
				cell = row.createCell(j);
				cell.setCellValue(ary[j - 1]);
				cell.setCellStyle(styleBody);
			}
		}
		
		//设置脚注
		int n = sheet.getLastRowNum();
		row = sheet.createRow(++n);
		row.setHeightInPoints((float) (12.75 * 2));
		cell = row.createCell(0);
		SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
		cell.setCellValue("数据生成时间：" + sdf.format(new Date()));
		cell.setCellStyle(styleFoot);
		sheet.addMergedRegion(new CellRangeAddress(n, n, 0, colNums - 1));

		// 自动调整列宽
		for (int k = 0; k < colNums; k++) {
			sheet.autoSizeColumn((short) k, true);
		}
		//手动设置列宽
		//sheet.setColumnWidth(列号,宽度);
		
		return wb;
	}
	
	//通过浏览器下载
	public static void responseExcel(HSSFWorkbook wb, String fileName, HttpServletResponse response) {
		OutputStream out = null;
		try {
			out = response.getOutputStream();
			response.setContentType("application/x-msdownload");
			response.setHeader("Content-Disposition", "attachment; filename=" + fileName);
			wb.write(out);
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			try {
				out.close();
			} catch (IOException e) {
				e.printStackTrace();
			}
		}
	}
}

调用

	String title = "标题";
	int cols = 列数;
	List<String> list = new ArrayList<>();
	list.add(0, "列1,列2,列3...");
	list.add(要导出的数据);
	
	title = URLDecoder.decode(title, "UTF-8");
	HSSFWorkbook wb = listToExcel.getExcel(title, list, cols);
	SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
	String fileName = sdf.format(new Date()) + ".xls";
	listToExcel.responseExcel(wb, fileName, response);