Poi 导出excel 官网

http://poi.apache.org/spreadsheet/quick-guide.html#DataFormats

Paste_Image.png

其中

//行高
rowAll.setHeightInPoints((5*sheet.getDefaultRowHeightInPoints()));
//合并cell
   sheet.addMergedRegion(new CellRangeAddress(0,0,0,headers.length));

导出文件名乱码

response.addHeader("Content-Disposition", "attachment;filename="
     + new String(name.getBytes("gb2312"), "iso8859-1"));

列长度适应

sheet.autoSizeColumn(y);