关于使用java将集合用poi导出到EXCEL中

最新推荐文章于 2022-06-20 16:06:43 发布
转载 最新推荐文章于 2022-06-20 16:06:43 发布 · 303 阅读 · 0 

<code class="hljs java has-numbering" style="display: block; padding: 0px; background: transparent; box-sizing: border-box; font-family: "Source Code Pro", monospace;font-size:undefined; white-space: pre; border-radius: 0px; word-wrap: normal;"><span style="color:#000088;">//以下代码是常用的EXCEL导出功能的练习代码</span></code><code class="hljs java has-numbering" style="color: inherit; display: block; padding: 0px; background: transparent; box-sizing: border-box; font-family: "Source Code Pro", monospace;font-size:undefined; white-space: pre; border-radius: 0px; word-wrap: normal;"><span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">package</span> test;
<span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">import</span> java.io.FileOutputStream;
<span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">import</span> java.io.OutputStream;
<span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">import</span> java.lang.reflect.Method;
<span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">import</span> java.text.SimpleDateFormat;
<span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">import</span> java.util.Date;
<span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">import</span> java.util.List;
<span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">import</span> java.util.Map;
<span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">import</span> java.util.UUID;
<span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">import</span> org.apache.poi.hssf.usermodel.HSSFCell;
<span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">import</span> org.apache.poi.hssf.usermodel.HSSFRow;
<span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">import</span> org.apache.poi.hssf.usermodel.HSSFSheet;
<span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">import</span> org.apache.poi.hssf.usermodel.HSSFWorkbook;
<span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">import</span> org.apache.poi.ss.util.CellRangeAddress;

<span class="hljs-javadoc" style="color: rgb(136, 0, 0); box-sizing: border-box;">/***
 * 导出List<Object>数据到excel（最多可导出65535行）
 *<span class="hljs-javadoctag" style="color: rgb(102, 0, 102); box-sizing: border-box;"> @author</span> user
 */</span>
<span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">public</span> <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">final</span> <span class="hljs-class" style="box-sizing: border-box;"><span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">class</span> <span class="hljs-title" style="box-sizing: border-box; color: rgb(102, 0, 102);">ExportExcel</span> {</span>

  <span class="hljs-javadoc" style="color: rgb(136, 0, 0); box-sizing: border-box;">/***
   * 构造方法
   */</span>
  <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">private</span> <span class="hljs-title" style="box-sizing: border-box;">ExportExcel</span>() {

  }

  <span class="hljs-javadoc" style="color: rgb(136, 0, 0); box-sizing: border-box;">/***
   * 工作簿
   */</span>
  <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">private</span> <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">static</span> HSSFWorkbook workbook;

  <span class="hljs-javadoc" style="color: rgb(136, 0, 0); box-sizing: border-box;">/***
   * sheet
   */</span>
  <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">private</span> <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">static</span> HSSFSheet sheet;
 <span class="hljs-javadoc" style="color: rgb(136, 0, 0); box-sizing: border-box;">/***
   * 标题行开始位置
   */</span>
  <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">private</span> <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">static</span> <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">final</span> <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">int</span> TITLE_START_POSITION = <span class="hljs-number" style="color: rgb(0, 102, 102); box-sizing: border-box;">0</span>;

  <span class="hljs-javadoc" style="color: rgb(136, 0, 0); box-sizing: border-box;">/***
   * 时间行开始位置
   */</span>
  <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">private</span> <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">static</span> <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">final</span> <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">int</span> DATEHEAD_START_POSITION = <span class="hljs-number" style="color: rgb(0, 102, 102); box-sizing: border-box;">1</span>;

  <span class="hljs-javadoc" style="color: rgb(136, 0, 0); box-sizing: border-box;">/***
   * 表头行开始位置
   */</span>
  <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">private</span> <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">static</span> <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">final</span> <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">int</span> HEAD_START_POSITION = <span class="hljs-number" style="color: rgb(0, 102, 102); box-sizing: border-box;">2</span>;

  <span class="hljs-javadoc" style="color: rgb(136, 0, 0); box-sizing: border-box;">/***
   * 文本行开始位置
   */</span>
  <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">private</span> <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">static</span> <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">final</span> <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">int</span> CONTENT_START_POSITION = <span class="hljs-number" style="color: rgb(0, 102, 102); box-sizing: border-box;">3</span>;


  <span class="hljs-javadoc" style="color: rgb(136, 0, 0); box-sizing: border-box;">/**
   * 
   *<span class="hljs-javadoctag" style="color: rgb(102, 0, 102); box-sizing: border-box;"> @param</span> dataList
   *        对象集合
   *<span class="hljs-javadoctag" style="color: rgb(102, 0, 102); box-sizing: border-box;"> @param</span> titleMap
   *        表头信息（对象属性名称->要显示的标题值)[按顺序添加]
   *<span class="hljs-javadoctag" style="color: rgb(102, 0, 102); box-sizing: border-box;"> @param</span> sheetName
   *        sheet名称和表头值
   */</span>
  <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">public</span> <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">static</span> <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">void</span> <span class="hljs-title" style="box-sizing: border-box;">excelExport</span>(List<?> dataList, Map<String, String> titleMap, String sheetName) {
    <span class="hljs-comment" style="color: rgb(136, 0, 0); box-sizing: border-box;">// 初始化workbook</span>
    initHSSFWorkbook(sheetName);
    <span class="hljs-comment" style="color: rgb(136, 0, 0); box-sizing: border-box;">// 标题行</span>
    createTitleRow(titleMap, sheetName);
    <span class="hljs-comment" style="color: rgb(136, 0, 0); box-sizing: border-box;">// 时间行</span>
    createDateHeadRow(titleMap);
    <span class="hljs-comment" style="color: rgb(136, 0, 0); box-sizing: border-box;">// 表头行</span>
    createHeadRow(titleMap);
    <span class="hljs-comment" style="color: rgb(136, 0, 0); box-sizing: border-box;">// 文本行</span>
    createContentRow(dataList, titleMap);
    <span class="hljs-comment" style="color: rgb(136, 0, 0); box-sizing: border-box;">//设置自动伸缩</span>
    <span class="hljs-comment" style="color: rgb(136, 0, 0); box-sizing: border-box;">//autoSizeColumn(titleMap.size());</span>
    <span class="hljs-comment" style="color: rgb(136, 0, 0); box-sizing: border-box;">// 写入处理结果</span>
    <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">try</span> {
      <span class="hljs-comment" style="color: rgb(136, 0, 0); box-sizing: border-box;">//生成UUID文件名称</span>
      UUID uuid = UUID.randomUUID();
      String filedisplay = uuid + <span class="hljs-string" style="color: rgb(0, 136, 0); box-sizing: border-box;">".xls"</span>;
      <span class="hljs-comment" style="color: rgb(136, 0, 0); box-sizing: border-box;">//如果web项目，1、设置下载框的弹出（设置response相关参数)；2、通过httpservletresponse.getOutputStream()获取</span></code><code class="hljs java has-numbering" style="display: block; padding: 0px; background: transparent; box-sizing: border-box; font-family: "Source Code Pro", monospace;font-size:undefined; white-space: pre; border-radius: 0px; word-wrap: normal;"><span style="white-space:pre">	</span>//这样是直接下载到指定位置
      OutputStream out = <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">new</span><span style="color:rgba(0, 0, 0, 0);"> FileOutputStream(</span><span class="hljs-string" style="color: rgb(0, 136, 0); box-sizing: border-box;">"D:\\"</span><span style="color:rgba(0, 0, 0, 0);"> + filedisplay);
      workbook.write(out);
      out.close();
    }
    </span><span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">catch</span><span style="color:rgba(0, 0, 0, 0);"> (Exception e) {
      e.printStackTrace();
    }
  }</span></code><code class="hljs java has-numbering" style="display: block; padding: 0px; background: transparent; box-sizing: border-box; font-family: "Source Code Pro", monospace;font-size:undefined; white-space: pre; border-radius: 0px; word-wrap: normal;"><span style="color:rgba(0, 0, 0, 0);">
</span></code><code class="hljs java has-numbering" style="display: block; padding: 0px; background: transparent; box-sizing: border-box; font-family: "Source Code Pro", monospace;font-size:undefined; white-space: pre; border-radius: 0px; word-wrap: normal;"><span style="color:rgba(0, 0, 0, 0);"><span style="font-family: "Source Code Pro", monospace; font-size: 14px; white-space: pre; background-color: rgba(128, 128, 128, 0.0470588);"> </span><span class="hljs-comment" style="font-family: "Source Code Pro", monospace; font-size: 14px; white-space: pre; background-color: rgba(128, 128, 128, 0.0470588); color: rgb(136, 0, 0); box-sizing: border-box;">//如果web项目，1、设置下载框的弹出（设置response相关参数)；2、通过httpservletresponse.getOutputStream()获取，型</span>
</span></code><code class="hljs java has-numbering" style="display: block; padding: 0px; background: transparent; box-sizing: border-box; font-family: "Source Code Pro", monospace;font-size:undefined; white-space: pre; border-radius: 0px; word-wrap: normal;"><span style="color:rgba(0, 0, 0, 0);">//3、将上面的try,catch块的内容替换为下面的内容，当然要注意将response以参数的形式传递过来。</span></code><code class="hljs java has-numbering" style="display: block; padding: 0px; background: transparent; box-sizing: border-box; font-family: "Source Code Pro", monospace;font-size:undefined; white-space: pre; border-radius: 0px; word-wrap: normal;"><span style="color:#ba0000;">//4、<span style="color: rgb(51, 51, 51); font-family: "Source Code Pro", monospace; font-size: 14px; white-space: pre; background-color: rgba(128, 128, 128, 0.0470588);">如果弹框功能不能实现，不使用AJAX方式发送求情应该就可以了</span></span></code><code class="hljs java has-numbering" style="display: block; padding: 0px; background: transparent; box-sizing: border-box; font-family: "Source Code Pro", monospace;font-size:undefined; white-space: pre; border-radius: 0px; word-wrap: normal;"><span style="color:rgba(0, 0, 0, 0);"><span style="white-space:pre">	</span>try{<span style="white-space:pre">	</span>
<span style="white-space:pre">		</span>//弹出框选着
<span style="white-space:pre">			</span>String fileName =pathName+".xls";
<span style="white-space:pre">		</span>      ByteArrayOutputStream os = new ByteArrayOutputStream();
<span style="white-space:pre">		</span>      workbook.write(os);
<span style="white-space:pre">		</span>      byte[] content = os.toByteArray();
<span style="white-space:pre">		</span>      InputStream is = new ByteArrayInputStream(content);
      
<span style="white-space:pre">		</span>      // 设置response参数，可以打开下载页面
<span style="white-space:pre">		</span>      response.reset();
<span style="white-space:pre">		</span>      response.setContentType("application/vnd.ms-excel;charset=utf-8");
<span style="white-space:pre">		</span>      response.setHeader("Content-Disposition", "attachment;filename="
<span style="white-space:pre">		</span>          + new String((fileName + ".xls").getBytes(), "iso-8859-1"));
<span style="white-space:pre">		</span>      ServletOutputStream out = response.getOutputStream();
<span style="white-space:pre">		</span>      BufferedInputStream bis = null;
<span style="white-space:pre">		</span>      BufferedOutputStream bos = null;<span style="white-space:pre">		</span> 
<span style="white-space:pre">		</span>      try {
<span style="white-space:pre">		</span>        bis = new BufferedInputStream(is);
<span style="white-space:pre">		</span>        bos = new BufferedOutputStream(out);
<span style="white-space:pre">		</span>        byte[] buff = new byte[2048];
<span style="white-space:pre">		</span>        int bytesRead;
<span style="white-space:pre">		</span>        // Simple read/write loop.
<span style="white-space:pre">		</span>        while (-1 != (bytesRead = bis.read(buff, 0, buff.length))) {
<span style="white-space:pre">		</span>          bos.write(buff, 0, bytesRead);
<span style="white-space:pre">		</span>        }
<span style="white-space:pre">		</span>      } catch (Exception e) {
<span style="white-space:pre">		</span>        // TODO: handle exception
<span style="white-space:pre">		</span>        e.printStackTrace();
<span style="white-space:pre">		</span>      } finally {
<span style="white-space:pre">		</span>        if (bis != null)
<span style="white-space:pre">		</span>          bis.close();
<span style="white-space:pre">		</span>        if (bos != null)
<span style="white-space:pre">		</span>          bos.close();
<span style="white-space:pre">	</span>
<span style="white-space:pre">		</span>      }
<span style="white-space:pre">		</span>} catch (Exception e) {
<span style="white-space:pre">			</span>e.printStackTrace();
<span style="white-space:pre">		</span>}<span style="white-space:pre">	</span>
<span style="white-space:pre">	</span>
  </span></code><code class="hljs java has-numbering" style="display: block; padding: 0px; background: transparent; box-sizing: border-box; font-family: "Source Code Pro", monospace;font-size:undefined; white-space: pre; border-radius: 0px; word-wrap: normal;"><span class="hljs-javadoc" style="box-sizing: border-box;">
</span></code><code class="hljs java has-numbering" style="display: block; padding: 0px; background: transparent; box-sizing: border-box; font-family: "Source Code Pro", monospace;font-size:undefined; white-space: pre; border-radius: 0px; word-wrap: normal;"><span class="hljs-javadoc" style="box-sizing: border-box;">/***
   * 
   *<span class="hljs-javadoctag" style="color: rgb(102, 0, 102); box-sizing: border-box;"> @param</span><span style="color:#880000;"> sheetName
   *        sheetName
   */</span></span><span style="color:rgba(0, 0, 0, 0);">
  </span><span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">private</span><span style="color:rgba(0, 0, 0, 0);"> </span><span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">static</span><span style="color:rgba(0, 0, 0, 0);"> </span><span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">void</span><span style="color:rgba(0, 0, 0, 0);"> </span><span class="hljs-title" style="color: inherit; box-sizing: border-box;">initHSSFWorkbook</span><span style="color:rgba(0, 0, 0, 0);">(String sheetName) {
    workbook = </span><span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">new</span><span style="color:rgba(0, 0, 0, 0);"> HSSFWorkbook();
    sheet = workbook.createSheet(sheetName);
  }

  </span><span class="hljs-javadoc" style="color: rgb(136, 0, 0); box-sizing: border-box;">/**
   * 生成标题（第零行创建）
   *<span class="hljs-javadoctag" style="color: rgb(102, 0, 102); box-sizing: border-box;"> @param</span> titleMap 对象属性名称->表头显示名称
   *<span class="hljs-javadoctag" style="color: rgb(102, 0, 102); box-sizing: border-box;"> @param</span> sheetName sheet名称
   */</span><span style="color:rgba(0, 0, 0, 0);">
  </span><span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">private</span><span style="color:rgba(0, 0, 0, 0);"> </span><span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">static</span><span style="color:rgba(0, 0, 0, 0);"> </span><span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">void</span><span style="color:rgba(0, 0, 0, 0);"> </span><span class="hljs-title" style="color: inherit; box-sizing: border-box;">createTitleRow</span><span style="color:rgba(0, 0, 0, 0);">(Map<String, String> titleMap, String sheetName) {
    CellRangeAddress titleRange = </span><span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">new</span><span style="color:rgba(0, 0, 0, 0);"> CellRangeAddress(</span><span class="hljs-number" style="color: rgb(0, 102, 102); box-sizing: border-box;">0</span><span style="color:rgba(0, 0, 0, 0);">, </span><span class="hljs-number" style="color: rgb(0, 102, 102); box-sizing: border-box;">0</span><span style="color:rgba(0, 0, 0, 0);">, </span><span class="hljs-number" style="color: rgb(0, 102, 102); box-sizing: border-box;">0</span><span style="color:rgba(0, 0, 0, 0);">, titleMap.size() - </span><span class="hljs-number" style="color: rgb(0, 102, 102); box-sizing: border-box;">1</span><span style="color:rgba(0, 0, 0, 0);">);
    sheet.addMergedRegion(titleRange);
    HSSFRow titleRow = sheet.createRow(TITLE_START_POSITION);
    HSSFCell titleCell = titleRow.createCell(</span><span class="hljs-number" style="color: rgb(0, 102, 102); box-sizing: border-box;">0</span><span style="color:rgba(0, 0, 0, 0);">);
    titleCell.setCellValue(sheetName);
  }

  </span><span class="hljs-javadoc" style="color: rgb(136, 0, 0); box-sizing: border-box;">/**
   * 创建时间行（第一行创建）
   *<span class="hljs-javadoctag" style="color: rgb(102, 0, 102); box-sizing: border-box;"> @param</span> titleMap 对象属性名称->表头显示名称
   */</span><span style="color:rgba(0, 0, 0, 0);">
  </span><span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">private</span><span style="color:rgba(0, 0, 0, 0);"> </span><span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">static</span><span style="color:rgba(0, 0, 0, 0);"> </span><span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">void</span><span style="color:rgba(0, 0, 0, 0);"> </span><span class="hljs-title" style="color: inherit; box-sizing: border-box;">createDateHeadRow</span><span style="color:rgba(0, 0, 0, 0);">(Map<String, String> titleMap) {
    CellRangeAddress dateRange = </span><span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">new</span><span style="color:rgba(0, 0, 0, 0);"> CellRangeAddress(</span><span class="hljs-number" style="color: rgb(0, 102, 102); box-sizing: border-box;">1</span><span style="color:rgba(0, 0, 0, 0);">, </span><span class="hljs-number" style="color: rgb(0, 102, 102); box-sizing: border-box;">1</span><span style="color:rgba(0, 0, 0, 0);">, </span><span class="hljs-number" style="color: rgb(0, 102, 102); box-sizing: border-box;">0</span><span style="color:rgba(0, 0, 0, 0);">, titleMap.size() - </span><span class="hljs-number" style="color: rgb(0, 102, 102); box-sizing: border-box;">1</span><span style="color:rgba(0, 0, 0, 0);">);
    sheet.addMergedRegion(dateRange);
    HSSFRow dateRow = sheet.createRow(DATEHEAD_START_POSITION);
    HSSFCell dateCell = dateRow.createCell(</span><span class="hljs-number" style="color: rgb(0, 102, 102); box-sizing: border-box;">0</span><span style="color:rgba(0, 0, 0, 0);">);   
    dateCell.setCellValue(</span><span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">new</span><span style="color:rgba(0, 0, 0, 0);"> SimpleDateFormat(</span><span class="hljs-string" style="color: rgb(0, 136, 0); box-sizing: border-box;">"yyyy年MM月dd日"</span><span style="color:rgba(0, 0, 0, 0);">).format(</span><span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">new</span><span style="color:rgba(0, 0, 0, 0);"> Date()));
  }

  </span><span class="hljs-javadoc" style="color: rgb(136, 0, 0); box-sizing: border-box;">/**
   * 创建表头行（第二行创建）
   *<span class="hljs-javadoctag" style="color: rgb(102, 0, 102); box-sizing: border-box;"> @param</span> titleMap 对象属性名称->表头显示名称
   */</span><span style="color:rgba(0, 0, 0, 0);">
  </span><span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">private</span><span style="color:rgba(0, 0, 0, 0);"> </span><span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">static</span><span style="color:rgba(0, 0, 0, 0);"> </span><span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">void</span><span style="color:rgba(0, 0, 0, 0);"> </span><span class="hljs-title" style="color: inherit; box-sizing: border-box;">createHeadRow</span><span style="color:rgba(0, 0, 0, 0);">(Map<String, String> titleMap) {
    </span><span class="hljs-comment" style="color: rgb(136, 0, 0); box-sizing: border-box;">// 第1行创建</span><span style="color:rgba(0, 0, 0, 0);">
    HSSFRow headRow = sheet.createRow(HEAD_START_POSITION);
    </span><span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">int</span><span style="color:rgba(0, 0, 0, 0);"> i = </span><span class="hljs-number" style="color: rgb(0, 102, 102); box-sizing: border-box;">0</span><span style="color:rgba(0, 0, 0, 0);">;
    </span><span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">for</span><span style="color:rgba(0, 0, 0, 0);"> (String entry : titleMap.keySet()) {
      HSSFCell headCell = headRow.createCell(i);
      headCell.setCellValue(titleMap.get(entry));
      i++;
    }
  }

 </span><span class="hljs-javadoc" style="color: rgb(136, 0, 0); box-sizing: border-box;">/**
  * 
  *<span class="hljs-javadoctag" style="color: rgb(102, 0, 102); box-sizing: border-box;"> @param</span> dataList 对象数据集合
  *<span class="hljs-javadoctag" style="color: rgb(102, 0, 102); box-sizing: border-box;"> @param</span> titleMap 表头信息
  */</span><span style="color:rgba(0, 0, 0, 0);">
  </span><span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">private</span><span style="color:rgba(0, 0, 0, 0);"> </span><span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">static</span><span style="color:rgba(0, 0, 0, 0);"> </span><span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">void</span><span style="color:rgba(0, 0, 0, 0);"> </span><span class="hljs-title" style="color: inherit; box-sizing: border-box;">createContentRow</span><span style="color:rgba(0, 0, 0, 0);">(List<?> dataList, Map<String, String> titleMap) {
    </span><span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">try</span><span style="color:rgba(0, 0, 0, 0);"> {
      </span><span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">int</span><span style="color:rgba(0, 0, 0, 0);"> i=</span><span class="hljs-number" style="color: rgb(0, 102, 102); box-sizing: border-box;">0</span><span style="color:rgba(0, 0, 0, 0);">;
      </span><span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">for</span><span style="color:rgba(0, 0, 0, 0);"> (Object obj : dataList) {
        HSSFRow textRow = sheet.createRow(CONTENT_START_POSITION + i);
        </span><span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">int</span><span style="color:rgba(0, 0, 0, 0);"> j = </span><span class="hljs-number" style="color: rgb(0, 102, 102); box-sizing: border-box;">0</span><span style="color:rgba(0, 0, 0, 0);">;
        </span><span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">for</span><span style="color:rgba(0, 0, 0, 0);"> (String entry : titleMap.keySet()) {
          String method = </span><span class="hljs-string" style="color: rgb(0, 136, 0); box-sizing: border-box;">"get"</span><span style="color:rgba(0, 0, 0, 0);"> + entry.substring(</span><span class="hljs-number" style="color: rgb(0, 102, 102); box-sizing: border-box;">0</span><span style="color:rgba(0, 0, 0, 0);">, </span><span class="hljs-number" style="color: rgb(0, 102, 102); box-sizing: border-box;">1</span><span style="color:rgba(0, 0, 0, 0);">).toUpperCase() + entry.substring(</span><span class="hljs-number" style="color: rgb(0, 102, 102); box-sizing: border-box;">1</span><span style="color:rgba(0, 0, 0, 0);">);
          Method m = obj.getClass().getMethod(method, </span><span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">null</span><span style="color:rgba(0, 0, 0, 0);">);
          String value =   m.invoke(obj, </span><span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">null</span><span style="color:rgba(0, 0, 0, 0);">).toString();
          HSSFCell textcell = textRow.createCell(j);
          textcell.setCellValue(value);
          j++;
        }
        i++;
      }

    }
    </span><span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">catch</span><span style="color:rgba(0, 0, 0, 0);"> (Exception e) {
      e.printStackTrace();
    }
  }
  </span><span class="hljs-javadoc" style="color: rgb(136, 0, 0); box-sizing: border-box;">/**
   * 自动伸缩列（如非必要，请勿打开此方法，耗内存）
   *<span class="hljs-javadoctag" style="color: rgb(102, 0, 102); box-sizing: border-box;"> @param</span> size 列数
   */</span><span style="color:rgba(0, 0, 0, 0);">
  </span><span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">private</span><span style="color:rgba(0, 0, 0, 0);"> </span><span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">static</span><span style="color:rgba(0, 0, 0, 0);"> </span><span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">void</span><span style="color:rgba(0, 0, 0, 0);"> </span><span class="hljs-title" style="color: inherit; box-sizing: border-box;">autoSizeColumn</span><span style="color:rgba(0, 0, 0, 0);">(Integer size) { 
    </span><span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">for</span><span style="color:rgba(0, 0, 0, 0);"> (</span><span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">int</span><span style="color:rgba(0, 0, 0, 0);"> j = </span><span class="hljs-number" style="color: rgb(0, 102, 102); box-sizing: border-box;">0</span><span style="color:rgba(0, 0, 0, 0);">; j < size; j++) {
      sheet.autoSizeColumn(j);
    }
  }
}
</span></code><ul class="pre-numbering" style="color: rgb(51, 51, 51); box-sizing: border-box; position: absolute; width: 50px; background-color: rgb(238, 238, 238); top: 0px; left: 0px; margin: 0px; padding: 6px 0px 40px; border-right: 1px solid rgb(221, 221, 221); list-style: none; text-align: right;"><li style="box-sizing: border-box; padding: 0px 5px;">1</li><li style="box-sizing: border-box; padding: 0px 5px;">2</li><li style="box-sizing: border-box; padding: 0px 5px;">3</li><li style="box-sizing: border-box; padding: 0px 5px;">4</li><li style="box-sizing: border-box; padding: 0px 5px;">5</li><li style="box-sizing: border-box; padding: 0px 5px;">6</li><li style="box-sizing: border-box; padding: 0px 5px;">7</li><li style="box-sizing: border-box; padding: 0px 5px;">8</li><li style="box-sizing: border-box; padding: 0px 5px;">9</li><li style="box-sizing: border-box; padding: 0px 5px;">10</li><li style="box-sizing: border-box; padding: 0px 5px;">11</li><li style="box-sizing: border-box; padding: 0px 5px;">12</li><li style="box-sizing: border-box; padding: 0px 5px;">13</li><li style="box-sizing: border-box; padding: 0px 5px;">14</li><li style="box-sizing: border-box; padding: 0px 5px;">15</li><li style="box-sizing: border-box; padding: 0px 5px;">16</li><li style="box-sizing: border-box; padding: 0px 5px;">17</li><li style="box-sizing: border-box; padding: 0px 5px;">18</li><li style="box-sizing: border-box; padding: 0px 5px;">19</li><li style="box-sizing: border-box; padding: 0px 5px;">20</li><li style="box-sizing: border-box; padding: 0px 5px;">21</li><li style="box-sizing: border-box; padding: 0px 5px;">22</li><li style="box-sizing: border-box; padding: 0px 5px;">23</li><li style="box-sizing: border-box; padding: 0px 5px;">24</li><li style="box-sizing: border-box; padding: 0px 5px;">25</li><li style="box-sizing: border-box; padding: 0px 5px;">26</li><li style="box-sizing: border-box; padding: 0px 5px;">27</li><li style="box-sizing: border-box; padding: 0px 5px;">28</li><li style="box-sizing: border-box; padding: 0px 5px;">29</li><li style="box-sizing: border-box; padding: 0px 5px;">30</li><li style="box-sizing: border-box; padding: 0px 5px;">31</li><li style="box-sizing: border-box; padding: 0px 5px;">32</li><li style="box-sizing: border-box; padding: 0px 5px;">33</li><li style="box-sizing: border-box; padding: 0px 5px;">34</li><li style="box-sizing: border-box; padding: 0px 5px;">35</li><li style="box-sizing: border-box; padding: 0px 5px;">36</li><li style="box-sizing: border-box; padding: 0px 5px;">37</li><li style="box-sizing: border-box; padding: 0px 5px;">38</li><li style="box-sizing: border-box; padding: 0px 5px;">39</li><li style="box-sizing: border-box; padding: 0px 5px;">40</li><li style="box-sizing: border-box; padding: 0px 5px;">41</li><li style="box-sizing: border-box; padding: 0px 5px;">42</li><li style="box-sizing: border-box; padding: 0px 5px;">43</li><li style="box-sizing: border-box; padding: 0px 5px;">44</li><li style="box-sizing: border-box; padding: 0px 5px;">45</li><li style="box-sizing: border-box; padding: 0px 5px;">46</li><li style="box-sizing: border-box; padding: 0px 5px;">47</li><li style="box-sizing: border-box; padding: 0px 5px;">48</li><li style="box-sizing: border-box; padding: 0px 5px;">49</li><li style="box-sizing: border-box; padding: 0px 5px;">50</li><li style="box-sizing: border-box; padding: 0px 5px;">51</li><li style="box-sizing: border-box; padding: 0px 5px;">52</li><li style="box-sizing: border-box; padding: 0px 5px;">53</li><li style="box-sizing: border-box; padding: 0px 5px;">54</li><li style="box-sizing: border-box; padding: 0px 5px;">55</li><li style="box-sizing: border-box; padding: 0px 5px;">56</li><li style="box-sizing: border-box; padding: 0px 5px;">57</li><li style="box-sizing: border-box; padding: 0px 5px;">58</li><li style="box-sizing: border-box; padding: 0px 5px;">59</li><li style="box-sizing: border-box; padding: 0px 5px;">60</li><li style="box-sizing: border-box; padding: 0px 5px;">61</li><li style="box-sizing: border-box; padding: 0px 5px;">62</li><li style="box-sizing: border-box; padding: 0px 5px;">63</li><li style="box-sizing: border-box; padding: 0px 5px;">64</li><li style="box-sizing: border-box; padding: 0px 5px;">65</li><li style="box-sizing: border-box; padding: 0px 5px;">66</li><li style="box-sizing: border-box; padding: 0px 5px;">67</li><li style="box-sizing: border-box; padding: 0px 5px;">68</li><li style="box-sizing: border-box; padding: 0px 5px;">69</li><li style="box-sizing: border-box; padding: 0px 5px;">70</li><li style="box-sizing: border-box; padding: 0px 5px;">71</li><li style="box-sizing: border-box; padding: 0px 5px;">72</li><li style="box-sizing: border-box; padding: 0px 5px;">73</li><li style="box-sizing: border-box; padding: 0px 5px;">74</li><li style="box-sizing: border-box; padding: 0px 5px;">75</li><li style="box-sizing: border-box; padding: 0px 5px;">76</li><li style="box-sizing: border-box; padding: 0px 5px;">77</li><li style="box-sizing: border-box; padding: 0px 5px;">78</li><li style="box-sizing: border-box; padding: 0px 5px;">79</li><li style="box-sizing: border-box; padding: 0px 5px;">80</li><li style="box-sizing: border-box; padding: 0px 5px;">81</li><li style="box-sizing: border-box; padding: 0px 5px;">82</li><li style="box-sizing: border-box; padding: 0px 5px;">83</li><li style="box-sizing: border-box; padding: 0px 5px;">84</li><li style="box-sizing: border-box; padding: 0px 5px;">85</li><li style="box-sizing: border-box; padding: 0px 5px;">86</li><li style="box-sizing: border-box; padding: 0px 5px;">87</li><li style="box-sizing: border-box; padding: 0px 5px;">88</li><li style="box-sizing: border-box; padding: 0px 5px;">89</li><li style="box-sizing: border-box; padding: 0px 5px;">90</li><li style="box-sizing: border-box; padding: 0px 5px;">91</li><li style="box-sizing: border-box; padding: 0px 5px;">92</li><li style="box-sizing: border-box; padding: 0px 5px;">93</li><li style="box-sizing: border-box; padding: 0px 5px;">94</li><li style="box-sizing: border-box; padding: 0px 5px;">95</li><li style="box-sizing: border-box; padding: 0px 5px;">96</li><li style="box-sizing: border-box; padding: 0px 5px;">97</li><li style="box-sizing: border-box; padding: 0px 5px;">98</li><li style="box-sizing: border-box; padding: 0px 5px;">99</li><li style="box-sizing: border-box; padding: 0px 5px;">100</li><li style="box-sizing: border-box; padding: 0px 5px;">101</li><li style="box-sizing: border-box; padding: 0px 5px;">102</li><li style="box-sizing: border-box; padding: 0px 5px;">103</li><li style="box-sizing: border-box; padding: 0px 5px;">104</li><li style="box-sizing: border-box; padding: 0px 5px;">105</li><li style="box-sizing: border-box; padding: 0px 5px;">106</li><li style="box-sizing: border-box; padding: 0px 5px;">107</li><li style="box-sizing: border-box; padding: 0px 5px;">108</li><li style="box-sizing: border-box; padding: 0px 5px;">109</li><li style="box-sizing: border-box; padding: 0px 5px;">110</li><li style="box-sizing: border-box; padding: 0px 5px;">111</li><li style="box-sizing: border-box; padding: 0px 5px;">112</li><li style="box-sizing: border-box; padding: 0px 5px;">113</li><li style="box-sizing: border-box; padding: 0px 5px;">114</li><li style="box-sizing: border-box; padding: 0px 5px;">115</li><li style="box-sizing: border-box; padding: 0px 5px;">116</li><li style="box-sizing: border-box; padding: 0px 5px;">117</li><li style="box-sizing: border-box; padding: 0px 5px;">118</li><li style="box-sizing: border-box; padding: 0px 5px;">119</li><li style="box-sizing: border-box; padding: 0px 5px;">120</li><li style="box-sizing: border-box; padding: 0px 5px;">121</li><li style="box-sizing: border-box; padding: 0px 5px;">122</li><li style="box-sizing: border-box; padding: 0px 5px;">123</li><li style="box-sizing: border-box; padding: 0px 5px;">124</li><li style="box-sizing: border-box; padding: 0px 5px;">125</li><li style="box-sizing: border-box; padding: 0px 5px;">126</li><li style="box-sizing: border-box; padding: 0px 5px;">127</li><li style="box-sizing: border-box; padding: 0px 5px;">128</li><li style="box-sizing: border-box; padding: 0px 5px;">129</li><li style="box-sizing: border-box; padding: 0px 5px;">130</li><li style="box-sizing: border-box; padding: 0px 5px;">131</li><li style="box-sizing: border-box; padding: 0px 5px;">132</li><li style="box-sizing: border-box; padding: 0px 5px;">133</li><li style="box-sizing: border-box; padding: 0px 5px;">134</li><li style="box-sizing: border-box; padding: 0px 5px;">135</li><li style="box-sizing: border-box; padding: 0px 5px;">136</li><li style="box-sizing: border-box; padding: 0px 5px;">137</li><li style="box-sizing: border-box; padding: 0px 5px;">138</li><li style="box-sizing: border-box; padding: 0px 5px;">139</li><li style="box-sizing: border-box; padding: 0px 5px;">140</li><li style="box-sizing: border-box; padding: 0px 5px;">141</li><li style="box-sizing: border-box; padding: 0px 5px;">142</li><li style="box-sizing: border-box; padding: 0px 5px;">143</li><li style="box-sizing: border-box; padding: 0px 5px;">144</li><li style="box-sizing: border-box; padding: 0px 5px;">145</li><li style="box-sizing: border-box; padding: 0px 5px;">146</li><li style="box-sizing: border-box; padding: 0px 5px;">147</li><li style="box-sizing: border-box; padding: 0px 5px;">148</li><li style="box-sizing: border-box; padding: 0px 5px;">149</li><li style="box-sizing: border-box; padding: 0px 5px;">150</li><li style="box-sizing: border-box; padding: 0px 5px;">151</li><li style="box-sizing: border-box; padding: 0px 5px;">152</li><li style="box-sizing: border-box; padding: 0px 5px;">153</li><li style="box-sizing: border-box; padding: 0px 5px;">154</li><li style="box-sizing: border-box; padding: 0px 5px;">155</li><li style="box-sizing: border-box; padding: 0px 5px;">156</li><li style="box-sizing: border-box; padding: 0px 5px;">157</li><li style="box-sizing: border-box; padding: 0px 5px;">158</li><li style="box-sizing: border-box; padding: 0px 5px;">159</li><li style="box-sizing: border-box; padding: 0px 5px;">160</li><li style="box-sizing: border-box; padding: 0px 5px;">161</li><li style="box-sizing: border-box; padding: 0px 5px;">162</li><li style="box-sizing: border-box; padding: 0px 5px;">163</li><li style="box-sizing: border-box; padding: 0px 5px;">164</li><li style="box-sizing: border-box; padding: 0px 5px;">165</li><li style="box-sizing: border-box; padding: 0px 5px;">166</li><li style="box-sizing: border-box; padding: 0px 5px;">167</li><li style="box-sizing: border-box; padding: 0px 5px;">168</li><li style="box-sizing: border-box; padding: 0px 5px;">169</li><li style="box-sizing: border-box; padding: 0px 5px;">170</li><li style="box-sizing: border-box; padding: 0px 5px;">171</li><li style="box-sizing: border-box; padding: 0px 5px;">172</li><li style="box-sizing: border-box; padding: 0px 5px;">173</li><li style="box-sizing: border-box; padding: 0px 5px;">174</li><li style="box-sizing: border-box; padding: 0px 5px;">175</li><li style="box-sizing: border-box; padding: 0px 5px;">176</li><li style="box-sizing: border-box; padding: 0px 5px;">177</li><li style="box-sizing: border-box; padding: 0px 5px;">178</li><li style="box-sizing: border-box; padding: 0px 5px;">179</li><li style="box-sizing: border-box; padding: 0px 5px;">180</li><li style="box-sizing: border-box; padding: 0px 5px;">181</li><li style="box-sizing: border-box; padding: 0px 5px;">182</li><li style="box-sizing: border-box; padding: 0px 5px;">183</li><li style="box-sizing: border-box; padding: 0px 5px;">184</li></ul><ul class="pre-numbering" style="color: rgb(51, 51, 51); box-sizing: border-box; position: absolute; width: 50px; background-color: rgb(238, 238, 238); top: 0px; left: 0px; margin: 0px; padding: 6px 0px 40px; border-right: 1px solid rgb(221, 221, 221); list-style: none; text-align: right;"><li style="box-sizing: border-box; padding: 0px 5px;">1</li><li style="box-sizing: border-box; padding: 0px 5px;">2</li><li style="box-sizing: border-box; padding: 0px 5px;">3</li><li style="box-sizing: border-box; padding: 0px 5px;">4</li><li style="box-sizing: border-box; padding: 0px 5px;">5</li><li style="box-sizing: border-box; padding: 0px 5px;">6</li><li style="box-sizing: border-box; padding: 0px 5px;">7</li><li style="box-sizing: border-box; padding: 0px 5px;">8</li><li style="box-sizing: border-box; padding: 0px 5px;">9</li><li style="box-sizing: border-box; padding: 0px 5px;">10</li><li style="box-sizing: border-box; padding: 0px 5px;">11</li><li style="box-sizing: border-box; padding: 0px 5px;">12</li><li style="box-sizing: border-box; padding: 0px 5px;">13</li><li style="box-sizing: border-box; padding: 0px 5px;">14</li><li style="box-sizing: border-box; padding: 0px 5px;">15</li><li style="box-sizing: border-box; padding: 0px 5px;">16</li><li style="box-sizing: border-box; padding: 0px 5px;">17</li><li style="box-sizing: border-box; padding: 0px 5px;">18</li><li style="box-sizing: border-box; padding: 0px 5px;">19</li><li style="box-sizing: border-box; padding: 0px 5px;">20</li><li style="box-sizing: border-box; padding: 0px 5px;">21</li><li style="box-sizing: border-box; padding: 0px 5px;">22</li><li style="box-sizing: border-box; padding: 0px 5px;">23</li><li style="box-sizing: border-box; padding: 0px 5px;">24</li><li style="box-sizing: border-box; padding: 0px 5px;">25</li><li style="box-sizing: border-box; padding: 0px 5px;">26</li><li style="box-sizing: border-box; padding: 0px 5px;">27</li><li style="box-sizing: border-box; padding: 0px 5px;">28</li><li style="box-sizing: border-box; padding: 0px 5px;">29</li><li style="box-sizing: border-box; padding: 0px 5px;">30</li><li style="box-sizing: border-box; padding: 0px 5px;">31</li><li style="box-sizing: border-box; padding: 0px 5px;">32</li><li style="box-sizing: border-box; padding: 0px 5px;">33</li><li style="box-sizing: border-box; padding: 0px 5px;">34</li><li style="box-sizing: border-box; padding: 0px 5px;">35</li><li style="box-sizing: border-box; padding: 0px 5px;">36</li><li style="box-sizing: border-box; padding: 0px 5px;">37</li><li style="box-sizing: border-box; padding: 0px 5px;">38</li><li style="box-sizing: border-box; padding: 0px 5px;">39</li><li style="box-sizing: border-box; padding: 0px 5px;">40</li><li style="box-sizing: border-box; padding: 0px 5px;">41</li><li style="box-sizing: border-box; padding: 0px 5px;">42</li><li style="box-sizing: border-box; padding: 0px 5px;">43</li><li style="box-sizing: border-box; padding: 0px 5px;">44</li><li style="box-sizing: border-box; padding: 0px 5px;">45</li><li style="box-sizing: border-box; padding: 0px 5px;">46</li><li style="box-sizing: border-box; padding: 0px 5px;">47</li><li style="box-sizing: border-box; padding: 0px 5px;">48</li><li style="box-sizing: border-box; padding: 0px 5px;">49</li><li style="box-sizing: border-box; padding: 0px 5px;">50</li><li style="box-sizing: border-box; padding: 0px 5px;">51</li><li style="box-sizing: border-box; padding: 0px 5px;">52</li><li style="box-sizing: border-box; padding: 0px 5px;">53</li><li style="box-sizing: border-box; padding: 0px 5px;">54</li><li style="box-sizing: border-box; padding: 0px 5px;">55</li><li style="box-sizing: border-box; padding: 0px 5px;">56</li><li style="box-sizing: border-box; padding: 0px 5px;">57</li><li style="box-sizing: border-box; padding: 0px 5px;">58</li><li style="box-sizing: border-box; padding: 0px 5px;">59</li><li style="box-sizing: border-box; padding: 0px 5px;">60</li><li style="box-sizing: border-box; padding: 0px 5px;">61</li><li style="box-sizing: border-box; padding: 0px 5px;">62</li><li style="box-sizing: border-box; padding: 0px 5px;">63</li><li style="box-sizing: border-box; padding: 0px 5px;">64</li><li style="box-sizing: border-box; padding: 0px 5px;">65</li><li style="box-sizing: border-box; padding: 0px 5px;">66</li><li style="box-sizing: border-box; padding: 0px 5px;">67</li><li style="box-sizing: border-box; padding: 0px 5px;">68</li><li style="box-sizing: border-box; padding: 0px 5px;">69</li><li style="box-sizing: border-box; padding: 0px 5px;">70</li><li style="box-sizing: border-box; padding: 0px 5px;">71</li><li style="box-sizing: border-box; padding: 0px 5px;">72</li><li style="box-sizing: border-box; padding: 0px 5px;">73</li><li style="box-sizing: border-box; padding: 0px 5px;">74</li><li style="box-sizing: border-box; padding: 0px 5px;">75</li><li style="box-sizing: border-box; padding: 0px 5px;">76</li><li style="box-sizing: border-box; padding: 0px 5px;">77</li><li style="box-sizing: border-box; padding: 0px 5px;">78</li><li style="box-sizing: border-box; padding: 0px 5px;">79</li><li style="box-sizing: border-box; padding: 0px 5px;">80</li><li style="box-sizing: border-box; padding: 0px 5px;">81</li><li style="box-sizing: border-box; padding: 0px 5px;">82</li><li style="box-sizing: border-box; padding: 0px 5px;">83</li><li style="box-sizing: border-box; padding: 0px 5px;">84</li><li style="box-sizing: border-box; padding: 0px 5px;">85</li><li style="box-sizing: border-box; padding: 0px 5px;">86</li><li style="box-sizing: border-box; padding: 0px 5px;">87</li><li style="box-sizing: border-box; padding: 0px 5px;">88</li><li style="box-sizing: border-box; padding: 0px 5px;">89</li><li style="box-sizing: border-box; padding: 0px 5px;">90</li><li style="box-sizing: border-box; padding: 0px 5px;">91</li><li style="box-sizing: border-box; padding: 0px 5px;">92</li><li style="box-sizing: border-box; padding: 0px 5px;">93</li><li style="box-sizing: border-box; padding: 0px 5px;">94</li><li style="box-sizing: border-box; padding: 0px 5px;">95</li><li style="box-sizing: border-box; padding: 0px 5px;">96</li><li style="box-sizing: border-box; padding: 0px 5px;">97</li><li style="box-sizing: border-box; padding: 0px 5px;">98</li><li style="box-sizing: border-box; padding: 0px 5px;">99</li><li style="box-sizing: border-box; padding: 0px 5px;">100</li><li style="box-sizing: border-box; padding: 0px 5px;">101</li><li style="box-sizing: border-box; padding: 0px 5px;">102</li><li style="box-sizing: border-box; padding: 0px 5px;">103</li><li style="box-sizing: border-box; padding: 0px 5px;">104</li><li style="box-sizing: border-box; padding: 0px 5px;">105</li><li style="box-sizing: border-box; padding: 0px 5px;">106</li><li style="box-sizing: border-box; padding: 0px 5px;">107</li><li style="box-sizing: border-box; padding: 0px 5px;">108</li><li style="box-sizing: border-box; padding: 0px 5px;">109</li><li style="box-sizing: border-box; padding: 0px 5px;">110</li><li style="box-sizing: border-box; padding: 0px 5px;">111</li><li style="box-sizing: border-box; padding: 0px 5px;">112</li><li style="box-sizing: border-box; padding: 0px 5px;">113</li><li style="box-sizing: border-box; padding: 0px 5px;">114</li><li style="box-sizing: border-box; padding: 0px 5px;">115</li><li style="box-sizing: border-box; padding: 0px 5px;">116</li><li style="box-sizing: border-box; padding: 0px 5px;">117</li><li style="box-sizing: border-box; padding: 0px 5px;">118</li><li style="box-sizing: border-box; padding: 0px 5px;">119</li><li style="box-sizing: border-box; padding: 0px 5px;">120</li><li style="box-sizing: border-box; padding: 0px 5px;">121</li><li style="box-sizing: border-box; padding: 0px 5px;">122</li><li style="box-sizing: border-box; padding: 0px 5px;">123</li><li style="box-sizing: border-box; padding: 0px 5px;">124</li><li style="box-sizing: border-box; padding: 0px 5px;">125</li><li style="box-sizing: border-box; padding: 0px 5px;">126</li><li style="box-sizing: border-box; padding: 0px 5px;">127</li><li style="box-sizing: border-box; padding: 0px 5px;">128</li><li style="box-sizing: border-box; padding: 0px 5px;">129</li><li style="box-sizing: border-box; padding: 0px 5px;">130</li><li style="box-sizing: border-box; padding: 0px 5px;">131</li><li style="box-sizing: border-box; padding: 0px 5px;">132</li><li style="box-sizing: border-box; padding: 0px 5px;">133</li><li style="box-sizing: border-box; padding: 0px 5px;">134</li><li style="box-sizing: border-box; padding: 0px 5px;">135</li><li style="box-sizing: border-box; padding: 0px 5px;">136</li><li style="box-sizing: border-box; padding: 0px 5px;">137</li><li style="box-sizing: border-box; padding: 0px 5px;">138</li><li style="box-sizing: border-box; padding: 0px 5px;">139</li><li style="box-sizing: border-box; padding: 0px 5px;">140</li><li style="box-sizing: border-box; padding: 0px 5px;">141</li><li style="box-sizing: border-box; padding: 0px 5px;">142</li><li style="box-sizing: border-box; padding: 0px 5px;">143</li><li style="box-sizing: border-box; padding: 0px 5px;">144</li><li style="box-sizing: border-box; padding: 0px 5px;">145</li><li style="box-sizing: border-box; padding: 0px 5px;">146</li><li style="box-sizing: border-box; padding: 0px 5px;">147</li><li style="box-sizing: border-box; padding: 0px 5px;">148</li><li style="box-sizing: border-box; padding: 0px 5px;">149</li><li style="box-sizing: border-box; padding: 0px 5px;">150</li><li style="box-sizing: border-box; padding: 0px 5px;">151</li><li style="box-sizing: border-box; padding: 0px 5px;">152</li><li style="box-sizing: border-box; padding: 0px 5px;">153</li><li style="box-sizing: border-box; padding: 0px 5px;">154</li><li style="box-sizing: border-box; padding: 0px 5px;">155</li><li style="box-sizing: border-box; padding: 0px 5px;">156</li><li style="box-sizing: border-box; padding: 0px 5px;">157</li><li style="box-sizing: border-box; padding: 0px 5px;">158</li><li style="box-sizing: border-box; padding: 0px 5px;">159</li><li style="box-sizing: border-box; padding: 0px 5px;">160</li><li style="box-sizing: border-box; padding: 0px 5px;">161</li><li style="box-sizing: border-box; padding: 0px 5px;">162</li><li style="box-sizing: border-box; padding: 0px 5px;">163</li><li style="box-sizing: border-box; padding: 0px 5px;">164</li><li style="box-sizing: border-box; padding: 0px 5px;">165</li><li style="box-sizing: border-box; padding: 0px 5px;">166</li><li style="box-sizing: border-box; padding: 0px 5px;">167</li><li style="box-sizing: border-box; padding: 0px 5px;">168</li><li style="box-sizing: border-box; padding: 0px 5px;">169</li><li style="box-sizing: border-box; padding: 0px 5px;">170</li><li style="box-sizing: border-box; padding: 0px 5px;">171</li><li style="box-sizing: border-box; padding: 0px 5px;">172</li><li style="box-sizing: border-box; padding: 0px 5px;">173</li><li style="box-sizing: border-box; padding: 0px 5px;">174</li><li style="box-sizing: border-box; padding: 0px 5px;">175</li><li style="box-sizing: border-box; padding: 0px 5px;">176</li><li style="box-sizing: border-box; padding: 0px 5px;">177</li><li style="box-sizing: border-box; padding: 0px 5px;">178</li><li style="box-sizing: border-box; padding: 0px 5px;">179</li><li style="box-sizing: border-box; padding: 0px 5px;">180</li><li style="box-sizing: border-box; padding: 0px 5px;">181</li><li style="box-sizing: border-box; padding: 0px 5px;">182</li><li style="box-sizing: border-box; padding: 0px 5px;">183</li><li style="box-sizing: border-box; padding: 0px 5px;">184</li></ul>

测试代码

<code class="hljs java has-numbering" style="display: block; padding: 0px; background: transparent; color: inherit; box-sizing: border-box; font-family: "Source Code Pro", monospace;font-size:undefined; white-space: pre; border-radius: 0px; word-wrap: normal;"><span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">package</span> test;

<span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">import</span> java.util.ArrayList;
<span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">import</span> java.util.HashMap;
<span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">import</span> java.util.LinkedHashMap;
<span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">import</span> java.util.List;
<span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">import</span> java.util.Map;


<span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">public</span> <span class="hljs-class" style="box-sizing: border-box;"><span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">class</span> <span class="hljs-title" style="box-sizing: border-box; color: rgb(102, 0, 102);">CustomerExportTest</span> {</span>

  <span class="hljs-javadoc" style="color: rgb(136, 0, 0); box-sizing: border-box;">/**
   *<span class="hljs-javadoctag" style="color: rgb(102, 0, 102); box-sizing: border-box;"> @param</span> args
   */</span>
  <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">public</span> <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">static</span> <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">void</span> <span class="hljs-title" style="box-sizing: border-box;">main</span>(String[] args) {

    <span class="hljs-javadoc" style="color: rgb(136, 0, 0); box-sizing: border-box;">/**模拟数据开始*/</span>
    List<Employee> staffs = <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">new</span> ArrayList<Employee>();
    <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">for</span> (<span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">int</span> i = <span class="hljs-number" style="color: rgb(0, 102, 102); box-sizing: border-box;">0</span>; i < <span class="hljs-number" style="color: rgb(0, 102, 102); box-sizing: border-box;">65532</span>; i++) {
      Employee staff = <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">new</span> Employee(i, i+<span class="hljs-string" style="color: rgb(0, 136, 0); box-sizing: border-box;">"group"</span>, <span class="hljs-number" style="color: rgb(0, 102, 102); box-sizing: border-box;">1900</span>+i, <span class="hljs-number" style="color: rgb(0, 102, 102); box-sizing: border-box;">12</span>, <span class="hljs-number" style="color: rgb(0, 102, 102); box-sizing: border-box;">25</span>, <span class="hljs-number" style="color: rgb(0, 102, 102); box-sizing: border-box;">2500</span>+i);
      staffs.add(staff);
    }
    Map<String,String> titleMap = <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">new</span> LinkedHashMap<String,String>();
    titleMap.put(<span class="hljs-string" style="color: rgb(0, 136, 0); box-sizing: border-box;">"name"</span>, <span class="hljs-string" style="color: rgb(0, 136, 0); box-sizing: border-box;">"姓名"</span>);
    titleMap.put(<span class="hljs-string" style="color: rgb(0, 136, 0); box-sizing: border-box;">"clazz"</span>, <span class="hljs-string" style="color: rgb(0, 136, 0); box-sizing: border-box;">"组号"</span>);
    titleMap.put(<span class="hljs-string" style="color: rgb(0, 136, 0); box-sizing: border-box;">"year"</span>, <span class="hljs-string" style="color: rgb(0, 136, 0); box-sizing: border-box;">"年份"</span>);
    titleMap.put(<span class="hljs-string" style="color: rgb(0, 136, 0); box-sizing: border-box;">"month"</span>, <span class="hljs-string" style="color: rgb(0, 136, 0); box-sizing: border-box;">"月份"</span>);
    titleMap.put(<span class="hljs-string" style="color: rgb(0, 136, 0); box-sizing: border-box;">"day"</span>, <span class="hljs-string" style="color: rgb(0, 136, 0); box-sizing: border-box;">"天"</span>);
    titleMap.put(<span class="hljs-string" style="color: rgb(0, 136, 0); box-sizing: border-box;">"salary"</span>, <span class="hljs-string" style="color: rgb(0, 136, 0); box-sizing: border-box;">"薪资"</span>);
    String sheetName = <span class="hljs-string" style="color: rgb(0, 136, 0); box-sizing: border-box;">"信息导出"</span>;
    <span class="hljs-javadoc" style="color: rgb(136, 0, 0); box-sizing: border-box;">/**模拟数据结束*/</span>

    System.out.println(<span class="hljs-string" style="color: rgb(0, 136, 0); box-sizing: border-box;">"start导出"</span>);
    <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">long</span> start = System.currentTimeMillis();
    ExportExcel.excelExport(staffs, titleMap, sheetName);
    <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">long</span> end = System.currentTimeMillis();
    System.out.println(<span class="hljs-string" style="color: rgb(0, 136, 0); box-sizing: border-box;">"end导出"</span>);
    System.out.println(<span class="hljs-string" style="color: rgb(0, 136, 0); box-sizing: border-box;">"耗时："</span>+(end-start)+<span class="hljs-string" style="color: rgb(0, 136, 0); box-sizing: border-box;">"ms"</span>);
  }

}</code><ul class="pre-numbering" style="box-sizing: border-box; position: absolute; width: 50px; background-color: rgb(238, 238, 238); top: 0px; left: 0px; margin: 0px; padding: 6px 0px 40px; border-right: 1px solid rgb(221, 221, 221); list-style: none; text-align: right;"><li style="box-sizing: border-box; padding: 0px 5px;">1</li><li style="box-sizing: border-box; padding: 0px 5px;">2</li><li style="box-sizing: border-box; padding: 0px 5px;">3</li><li style="box-sizing: border-box; padding: 0px 5px;">4</li><li style="box-sizing: border-box; padding: 0px 5px;">5</li><li style="box-sizing: border-box; padding: 0px 5px;">6</li><li style="box-sizing: border-box; padding: 0px 5px;">7</li><li style="box-sizing: border-box; padding: 0px 5px;">8</li><li style="box-sizing: border-box; padding: 0px 5px;">9</li><li style="box-sizing: border-box; padding: 0px 5px;">10</li><li style="box-sizing: border-box; padding: 0px 5px;">11</li><li style="box-sizing: border-box; padding: 0px 5px;">12</li><li style="box-sizing: border-box; padding: 0px 5px;">13</li><li style="box-sizing: border-box; padding: 0px 5px;">14</li><li style="box-sizing: border-box; padding: 0px 5px;">15</li><li style="box-sizing: border-box; padding: 0px 5px;">16</li><li style="box-sizing: border-box; padding: 0px 5px;">17</li><li style="box-sizing: border-box; padding: 0px 5px;">18</li><li style="box-sizing: border-box; padding: 0px 5px;">19</li><li style="box-sizing: border-box; padding: 0px 5px;">20</li><li style="box-sizing: border-box; padding: 0px 5px;">21</li><li style="box-sizing: border-box; padding: 0px 5px;">22</li><li style="box-sizing: border-box; padding: 0px 5px;">23</li><li style="box-sizing: border-box; padding: 0px 5px;">24</li><li style="box-sizing: border-box; padding: 0px 5px;">25</li><li style="box-sizing: border-box; padding: 0px 5px;">26</li><li style="box-sizing: border-box; padding: 0px 5px;">27</li><li style="box-sizing: border-box; padding: 0px 5px;">28</li><li style="box-sizing: border-box; padding: 0px 5px;">29</li><li style="box-sizing: border-box; padding: 0px 5px;">30</li><li style="box-sizing: border-box; padding: 0px 5px;">31</li><li style="box-sizing: border-box; padding: 0px 5px;">32</li><li style="box-sizing: border-box; padding: 0px 5px;">33</li><li style="box-sizing: border-box; padding: 0px 5px;">34</li><li style="box-sizing: border-box; padding: 0px 5px;">35</li><li style="box-sizing: border-box; padding: 0px 5px;">36</li><li style="box-sizing: border-box; padding: 0px 5px;">37</li><li style="box-sizing: border-box; padding: 0px 5px;">38</li><li style="box-sizing: border-box; padding: 0px 5px;">39</li><li style="box-sizing: border-box; padding: 0px 5px;">40</li><li style="box-sizing: border-box; padding: 0px 5px;">41</li></ul><ul class="pre-numbering" style="box-sizing: border-box; position: absolute; width: 50px; background-color: rgb(238, 238, 238); top: 0px; left: 0px; margin: 0px; padding: 6px 0px 40px; border-right: 1px solid rgb(221, 221, 221); list-style: none; text-align: right;"><li style="box-sizing: border-box; padding: 0px 5px;">1</li><li style="box-sizing: border-box; padding: 0px 5px;">2</li><li style="box-sizing: border-box; padding: 0px 5px;">3</li><li style="box-sizing: border-box; padding: 0px 5px;">4</li><li style="box-sizing: border-box; padding: 0px 5px;">5</li><li style="box-sizing: border-box; padding: 0px 5px;">6</li><li style="box-sizing: border-box; padding: 0px 5px;">7</li><li style="box-sizing: border-box; padding: 0px 5px;">8</li><li style="box-sizing: border-box; padding: 0px 5px;">9</li><li style="box-sizing: border-box; padding: 0px 5px;">10</li><li style="box-sizing: border-box; padding: 0px 5px;">11</li><li style="box-sizing: border-box; padding: 0px 5px;">12</li><li style="box-sizing: border-box; padding: 0px 5px;">13</li><li style="box-sizing: border-box; padding: 0px 5px;">14</li><li style="box-sizing: border-box; padding: 0px 5px;">15</li><li style="box-sizing: border-box; padding: 0px 5px;">16</li><li style="box-sizing: border-box; padding: 0px 5px;">17</li><li style="box-sizing: border-box; padding: 0px 5px;">18</li><li style="box-sizing: border-box; padding: 0px 5px;">19</li><li style="box-sizing: border-box; padding: 0px 5px;">20</li><li style="box-sizing: border-box; padding: 0px 5px;">21</li><li style="box-sizing: border-box; padding: 0px 5px;">22</li><li style="box-sizing: border-box; padding: 0px 5px;">23</li><li style="box-sizing: border-box; padding: 0px 5px;">24</li><li style="box-sizing: border-box; padding: 0px 5px;">25</li><li style="box-sizing: border-box; padding: 0px 5px;">26</li><li style="box-sizing: border-box; padding: 0px 5px;">27</li><li style="box-sizing: border-box; padding: 0px 5px;">28</li><li style="box-sizing: border-box; padding: 0px 5px;">29</li><li style="box-sizing: border-box; padding: 0px 5px;">30</li><li style="box-sizing: border-box; padding: 0px 5px;">31</li><li style="box-sizing: border-box; padding: 0px 5px;">32</li><li style="box-sizing: border-box; padding: 0px 5px;">33</li><li style="box-sizing: border-box; padding: 0px 5px;">34</li><li style="box-sizing: border-box; padding: 0px 5px;">35</li><li style="box-sizing: border-box; padding: 0px 5px;">36</li><li style="box-sizing: border-box; padding: 0px 5px;">37</li><li style="box-sizing: border-box; padding: 0px 5px;">38</li><li style="box-sizing: border-box; padding: 0px 5px;">39</li><li style="box-sizing: border-box; padding: 0px 5px;">40</li><li style="box-sizing: border-box; padding: 0px 5px;">41</li></ul>

Employee类

<code class="hljs java has-numbering" style="display: block; padding: 0px; background: transparent; color: inherit; box-sizing: border-box; font-family: "Source Code Pro", monospace;font-size:undefined; white-space: pre; border-radius: 0px; word-wrap: normal;"><span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">package</span> test;


<span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">public</span> <span class="hljs-class" style="box-sizing: border-box;"><span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">class</span> <span class="hljs-title" style="box-sizing: border-box; color: rgb(102, 0, 102);">Employee</span> {</span>

  <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">private</span> Integer name;

  <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">private</span> String clazz;

  <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">private</span> Integer year;

  <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">private</span> Integer month;

  <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">private</span> Integer day;

  <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">private</span> <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">double</span> salary;

  <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">public</span> <span class="hljs-title" style="box-sizing: border-box;">Employee</span>() {
  };

  <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">public</span> <span class="hljs-title" style="box-sizing: border-box;">Employee</span>(Integer name, String clazz, Integer year, Integer month, Integer day,
      <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">double</span> salary) {
    <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">super</span>();
    <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">this</span>.name = name;
    <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">this</span>.clazz = clazz;
    <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">this</span>.year = year;
    <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">this</span>.month = month;
    <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">this</span>.day = day;
    <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">this</span>.salary = salary;
  }

  <span class="hljs-javadoc" style="color: rgb(136, 0, 0); box-sizing: border-box;">/**
   *<span class="hljs-javadoctag" style="color: rgb(102, 0, 102); box-sizing: border-box;"> @return</span> name
   */</span>
  <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">public</span> Integer <span class="hljs-title" style="box-sizing: border-box;">getName</span>() {
    <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">return</span> name;
  }

  <span class="hljs-javadoc" style="color: rgb(136, 0, 0); box-sizing: border-box;">/**
   *<span class="hljs-javadoctag" style="color: rgb(102, 0, 102); box-sizing: border-box;"> @return</span> year
   */</span>
  <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">public</span> Integer <span class="hljs-title" style="box-sizing: border-box;">getYear</span>() {
    <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">return</span> year;
  }

  <span class="hljs-javadoc" style="color: rgb(136, 0, 0); box-sizing: border-box;">/**
   *<span class="hljs-javadoctag" style="color: rgb(102, 0, 102); box-sizing: border-box;"> @return</span> month
   */</span>
  <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">public</span> Integer <span class="hljs-title" style="box-sizing: border-box;">getMonth</span>() {
    <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">return</span> month;
  }

  <span class="hljs-javadoc" style="color: rgb(136, 0, 0); box-sizing: border-box;">/**
   *<span class="hljs-javadoctag" style="color: rgb(102, 0, 102); box-sizing: border-box;"> @return</span> day
   */</span>
  <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">public</span> Integer <span class="hljs-title" style="box-sizing: border-box;">getDay</span>() {
    <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">return</span> day;
  }

  <span class="hljs-javadoc" style="color: rgb(136, 0, 0); box-sizing: border-box;">/**
   *<span class="hljs-javadoctag" style="color: rgb(102, 0, 102); box-sizing: border-box;"> @return</span> salary
   */</span>
  <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">public</span> <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">double</span> <span class="hljs-title" style="box-sizing: border-box;">getSalary</span>() {
    <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">return</span> salary;
  }

  <span class="hljs-javadoc" style="color: rgb(136, 0, 0); box-sizing: border-box;">/**
   *<span class="hljs-javadoctag" style="color: rgb(102, 0, 102); box-sizing: border-box;"> @param</span> name
   *        set name
   */</span>
  <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">public</span> <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">void</span> <span class="hljs-title" style="box-sizing: border-box;">setName</span>(Integer name) {
    <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">this</span>.name = name;
  }

  <span class="hljs-javadoc" style="color: rgb(136, 0, 0); box-sizing: border-box;">/**
   *<span class="hljs-javadoctag" style="color: rgb(102, 0, 102); box-sizing: border-box;"> @param</span> year
   *        set year
   */</span>
  <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">public</span> <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">void</span> <span class="hljs-title" style="box-sizing: border-box;">setYear</span>(Integer year) {
    <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">this</span>.year = year;
  }

  <span class="hljs-javadoc" style="color: rgb(136, 0, 0); box-sizing: border-box;">/**
   *<span class="hljs-javadoctag" style="color: rgb(102, 0, 102); box-sizing: border-box;"> @param</span> month
   *        set month
   */</span>
  <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">public</span> <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">void</span> <span class="hljs-title" style="box-sizing: border-box;">setMonth</span>(Integer month) {
    <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">this</span>.month = month;
  }

  <span class="hljs-javadoc" style="color: rgb(136, 0, 0); box-sizing: border-box;">/**
   *<span class="hljs-javadoctag" style="color: rgb(102, 0, 102); box-sizing: border-box;"> @param</span> day
   *        set day
   */</span>
  <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">public</span> <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">void</span> <span class="hljs-title" style="box-sizing: border-box;">setDay</span>(Integer day) {
    <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">this</span>.day = day;
  }

  <span class="hljs-javadoc" style="color: rgb(136, 0, 0); box-sizing: border-box;">/**
   *<span class="hljs-javadoctag" style="color: rgb(102, 0, 102); box-sizing: border-box;"> @param</span> salary
   *        set salary
   */</span>
  <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">public</span> <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">void</span> <span class="hljs-title" style="box-sizing: border-box;">setSalary</span>(<span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">double</span> salary) {
    <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">this</span>.salary = salary;
  }

  <span class="hljs-javadoc" style="color: rgb(136, 0, 0); box-sizing: border-box;">/**
   *<span class="hljs-javadoctag" style="color: rgb(102, 0, 102); box-sizing: border-box;"> @return</span> clazz
   */</span>
  <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">public</span> String <span class="hljs-title" style="box-sizing: border-box;">getClazz</span>() {
    <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">return</span> clazz;
  }

  <span class="hljs-javadoc" style="color: rgb(136, 0, 0); box-sizing: border-box;">/**
   *<span class="hljs-javadoctag" style="color: rgb(102, 0, 102); box-sizing: border-box;"> @param</span> clazz
   *        set clazz
   */</span>
  <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">public</span> <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">void</span> <span class="hljs-title" style="box-sizing: border-box;">setClazz</span>(String clazz) {
    <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">this</span>.clazz = clazz;
  }

  <span class="hljs-annotation" style="color: rgb(155, 133, 157); box-sizing: border-box;">@Override</span>
  <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">public</span> String <span class="hljs-title" style="box-sizing: border-box;">toString</span>() {
    <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">return</span> <span class="hljs-string" style="color: rgb(0, 136, 0); box-sizing: border-box;">"Employee [name="</span> + name + <span class="hljs-string" style="color: rgb(0, 136, 0); box-sizing: border-box;">", clazz="</span> + clazz + <span class="hljs-string" style="color: rgb(0, 136, 0); box-sizing: border-box;">", year="</span> + year + <span class="hljs-string" style="color: rgb(0, 136, 0); box-sizing: border-box;">", month="</span> + month
        + <span class="hljs-string" style="color: rgb(0, 136, 0); box-sizing: border-box;">", day="</span> + day + <span class="hljs-string" style="color: rgb(0, 136, 0); box-sizing: border-box;">", salary="</span> + salary + <span class="hljs-string" style="color: rgb(0, 136, 0); box-sizing: border-box;">"]"</span>;
  }

}</code><code class="hljs java has-numbering" style="display: block; padding: 0px; background: transparent; color: inherit; box-sizing: border-box; font-family: "Source Code Pro", monospace;font-size:undefined; white-space: pre; border-radius: 0px; word-wrap: normal;">
</code><code class="hljs java has-numbering" style="display: block; padding: 0px; background: transparent; color: inherit; box-sizing: border-box; font-family: "Source Code Pro", monospace;font-size:undefined; white-space: pre; border-radius: 0px; word-wrap: normal;">
</code>
Rookie_csdn
关注
使用Java反射机制和POI将对象集合导出到Excel
GodHang的博客
07-20 2891
首先：搭载一个maven项目，添加POI的引用。 &lt;dependency&gt; &lt;groupId&gt;org.apache.poi&lt;/groupId&gt; &lt;artifactId&gt;poi-ooxml&lt;/artifactId&gt; &lt;version&gt;3.9&lt;/version&gt; &lt;/depe
JAVA使用POI导出图片到Excel
讓之的博客
07-15 5816
功能：java使用poi导出excel表格时添加图片 本程序的基础是：图片为BLOB格式的base64编码、XX.xls文件的模板 其他的先看代码，简要注释，大概意思 package com.runge.util; import java.awt.image.BufferedImage; import java.io.ByteArrayInputStream; import java.io.ByteArrayOutputStream; import java.io.File; import java.io
java中，list集合数据导出到excel表格通用工具类
07-27
本实例可以把多个不同对象集合或者一个对象集合的数据导出到Excel表格中，能实现最大通用化。
java集合导出excel_java导出excel
weixin_30821291的博客
02-28 256
importjava.io.OutputStream;importjava.util.Date;importjava.util.List;importjava.util.Map;importjavax.servlet.http.HttpServletResponse;importjxl.Workbook;importjxl.format.UnderlineStyle;importjxl.write...
poi导出
shuai的博客
12-02 239
版权声明：本文为博主原创文章，未经博主允许不得转载。 https://blog.youkuaiyun.com/l1028386804/article/details/79659605 转载请注明出处：https://blog.youkuaiyun.com/l1028386804/artic...
Java中利用POI通过List导出到Excle，将Excle中的数据导入到数据库
yangzhenzhou1的博客
07-13 788
Java中利用POI通过List导出到Excle，将Excle中的数据导入到数据库 没接触这个小白可以直接复制代码到方法中只要导了POI这个jar包 修改一下数据库方法和实体类就可以了，实体类的位置和数据库方法的位置我已经标明了，这也是我借鉴别人的方法学习的，我只能帮你们这么多了。。加油 页面部分代码就不写了，就直接一个按钮点击调用controler层中的方法就可以. 下面开始就是java代码了 ...
Java中利用POI优雅的导出Excel文件详解
08-19
本文介绍了如何使用 POI 库在 Java 中优雅的导出 Excel 文件，并提供了一个简单的示例代码，演示了如何使用 POI 库将数据写入到 Excel 文件中。POI 库提供了一个灵活的 API，允许开发者自定义 Excel 文件的格式和...
使用poi将list集合中的数据导入excel表格并且导出到浏览器页面或者从excel中导出数据。
m0_51491702的博客
05-09 1678
java实现对excle的操作，将数据导入excel或者从excel中导出数据。还可以直接将excle文件下载到浏览器。
Java使用POI导出Excel文件
wildcat的博客
06-20 6893
Java使用POI导出Excel文件，设置边框、字体、单元格背景、行距、单元格合并、单元格宽度自适应、文本水平居中、垂直居中、标题跟内容样式分离
【POI】第一个POI例子将数据写入到Excel文档中
Evan_QB的博客
12-20 503
首先我们可以去官网下载相关的POI的jar包 https://poi.apache.org/download.html 然后将需要的jar包引入到项目中去 这样我们的准备工作就好了，然后我们就准备数据到集合中，并将数据写入到WriteSheet.xlsx package cn.qblank.poi; import java.io.File; import ja
java poi导出list数据到excel
米汤汤的专栏
10-24 8619
import java.io.FileInputStream; import java.io.IOException; import java.io.InputStream; import java.io.OutputStream; import java.util.ArrayList; import java.util.Date; import java.util.HashMap;
List集合导出成Excel表格
热门推荐
BIGBEAR的博客
10-09 1万+
需要的jar包:poi-3.14.jar , dom4j-1.6.1.jar , xmlpull_1_0_5.jar , xstream-1.4.8.jar List集合导出成Excel表格 实体类package job.util;/** * * @className Employee * @deprecated 导出的实体 * @author pengfei.xiong * @da
Java poi 集合转存Excel ExcelUtil工具类案例
SilenceKiio的博客
11-18 1387
话不多说，先上工具类。里面的逻辑是将读到的数据转存list再进行插入excel、如果是读数据库 也可以将里面的逻辑改成遍历实体，道理是一样的。excel工具类有俩种方法，java excel 和apache poi；本文是利用apache poi 进行编写，另一种方法在另一篇文章中。 package utils; import org.apache.poi.hssf.usermodel.*; import org.apache.poi.ss.usermodel.BorderStyle; impor..
POI导出Excel，并合并单元格
SNIPERの博客
06-22 7190
最近根据公司需求，写一个导出Excel的功能，我使用的是POI，没有选择easyPOI，这里根据POI的基本功能，自己写了一个工具类，可以大大减少工作量，分享到这里，希望能帮到有需要的小伙伴。 先上结果 1.使用的是postman 说明：这里是根据时间段来查询数据的。 2.controller层的代码就不贴了，直接上service层的 @Override public void Settlement(Map<String, Object> map, H...
JAVA将List集合用POI导出Excal
小虾米的成长之路
11-30 1344
前几天碰到个问题，就是将List集合导出成标准的Excal 在这里我就整理一下思路，也许能帮得上各位。 1、获取dataList集合 dataList = XXXDAO.getName(param); 2、创建表头，副表 String title[] = { "序号", "ID", "记录时间"} String title_[] = { "", "",...
Java io操作,poi导出excel,集合自带排序,日志报告
zhuyu714997369的博客
07-08 8115
java io操作，poi导出到excel表格，sl4j日志打印,集合自带排序Comparator 要求: 取出txt文件中其中第50000行到60000行的数据，进行数据的解析，然后对数据的某一项进行排序，从小到大输出到excel表格中.每一步的错误进行日志打印，不要直接e.printStackTrace()抛到java堆栈中.打印时间，观察执行的时间差. import java.
List<Map>写入Excel，poi操作
李文_广的博客
06-21 5521
List<Map>导出Excel。 poi操作 poi3.8 java操作Excel2007
POI：数据批量导出、按模板导出
熊诗言的博客
12-21 1548
Action或者Servlet中 Workbook wb=new HSSFWorkbook();  String headers[]={"编号","姓名","电话","Email","QQ"}; ResultSet rs=userDao.userList(con, null); ExcelUtil.fillExcelData(rs, wb, headers); ResponseU
POI数据导出
guofeng6869的博客
12-20 461
java导出excel 轻松导出百万条记录 置顶 2017年09月30日 03:51:24 wllllllllllllllll 阅读数：2075 网上查了很多博客，发现很多导出excel 都是 存一个集合 然后利用poi 的api 导出 ，这样在数据量比较小的时候没什么问题，但是在数据量稍微大一点就会造成堆栈溢出了。所以写了一个每次导出一条记录的工具类，分享给大家！完美导出超大数据集合。不多说 ，...
Java POI导出Excel教程：数据库查询与数据集合导出
通过以上分析，您可以发现，POI导出Excel详细教程不仅涵盖了对POI库基础使用的介绍，还结合了数据库操作，展示了如何将查询结果输出到Excel文件中。在实际开发过程中，熟练掌握POI库的使用以及数据库操作是非常重要...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值