java poi导出图片到excel示例代码

/**

  * 导出志愿者/人才数据

  * @param talent_type

  * @return

  */

@requestmapping ( "/exportdata" )

public void exportdata(integer talent_type, httpservletresponse response) {

   string fileid = uuid.randomuuid().tostring().replace( "-" , "" );

   map<string, object> param = new hashmap<>() ;

   param.put( "talent_type" , talent_type) ;

   try {

    list<map<string, object>> volunteermaplist = volunteerservice.getexportdata(param) ;

    string rootpath = sysconfigmanager.getinstance().gettext( "/config/sys/rootpath" );

    string filepath = rootpath + "/" + fileid + ".xlsx" ;

    volunteerservice.exportdata(volunteermaplist, filepath) ;

    // 下载

    fileinputstream inputstream = null ;

    try {

      //设置发送到客户端的响应内容类型

      response.reset();

      response.setcontentlength(( int ) new file(filepath).length());

      response.setcontenttype( "application/octet-stream" );

      response.addheader( "content-disposition" , "attachment; filename=\"" + urlencoder.encode( "文件名.xlsx" , "utf-8" )+ "\"" );

      //读取本地图片输入流

      inputstream = new fileinputstream(filepath);

      // 循环取出流中的数据

      byte [] b = new byte [ 1024 ];

      int len;

      while ((len = inputstream.read(b)) > 0 )

       response.getoutputstream().write(b, 0 , len);

    } finally {

      if (inputstream != null ){

       inputstream.close();

      }

    }

    logger.debug( "导出志愿者/人才数据成功！" );

   } catch (exception e) {

    e.printstacktrace();

    logger.error( "导出志愿者/人才数据异常！" );

   }

}

public void exportdata(list<map<string, object>> volunteermaplist, string filepath) throws exception {

    string[] alias = { "头像" , "名称" , "个人/团体" , "志愿者/人才" , "性别" , "生日" , "手机号" ,

        "身份证" , "省份" , "市" , "区/县" , "详细地址" , "邮箱" , "政治面貌" , "学历" , "民族" ,

        "职业" , "团队人数" , "艺术特长" , "介绍" };

    string[] keys = { "photo" , "name" , "type" , "talent_type" , "sex" , "birth_day" , "mobile" ,

        "idcard" , "province" , "city" , "county" , "address" , "email" , "political" ,

        "education" , "nation" , "profession" , "member_count" , "art_spetiality" , "content" };

    file file = new file(filepath);

    if (!file.exists()) file.createnewfile();

    fileoutputstream fileoutput = new fileoutputstream(file);

    xssfworkbook workbook = new xssfworkbook();

    int sheetsize = volunteermaplist.size() + 50 ;

    double sheetno = math.ceil(volunteermaplist.size() / sheetsize);

    string photoimgpath = sysconfigmanager.getinstance().gettext( "/config/sys/rootpath" ) ;

    for ( int index = 0 ; index <= sheetno; index++) {

      xssfsheet sheet = workbook.createsheet();

      workbook.setsheetname(index, "人才、志愿者" + index);

      xssfrow row = sheet.createrow( 0 );

      sheet.setcolumnwidth( 0 , 2048 );

      xssfcell cell;

      xssfcellstyle cellstyle = workbook.createcellstyle();

      xssffont font = workbook.createfont();

      font.setboldweight(xssffont.boldweight_bold);

      // 居中

      cellstyle.setalignment(xssfcellstyle.align_center);

      // 加粗

      cellstyle.setfont(font);

      //创建标题

      for ( int i = 0 ; i < alias.length; i++) {

        cell = row.createcell(i);

        cell.setcellvalue(alias[i]);

        cell.setcellstyle(cellstyle);

      }

      int startno = index * sheetsize;

      int endno = math.min(startno + sheetsize, volunteermaplist.size());

      cellstyle = workbook.createcellstyle();

      // 居中

      cellstyle.setalignment(xssfcellstyle.align_center);

      cellstyle.setverticalalignment(xssfcellstyle.vertical_center);

      // 写入各条记录,每条记录对应excel表中的一行

      for ( int i = startno; i < endno; i++) {

        int rownum = i + 1 - startno ;

        row = sheet.createrow(rownum);

        map<string, object> map = (map<string, object>) volunteermaplist.get(i);

        for ( int j = 0 ; j < keys.length; j++) {

          cell = row.createcell(j);

          string key = keys[j] ;

          if (key.equals( "photo" )){

            sheet.addmergedregion( new cellrangeaddress(i + 1 ,i + 1 ,i + 1 ,i + 1 )) ;

            // 头像

            file photofile = new file(photoimgpath + map.get(key)) ;

            if (photofile.exists()){

              bufferedimage bufferedimage = imageio.read(photofile) ;

              bytearrayoutputstream bytearrayout = new bytearrayoutputstream();

              imageio.write(bufferedimage, "jpg" , bytearrayout);

              byte [] data = bytearrayout.tobytearray();

              xssfdrawing drawingpatriarch = sheet.createdrawingpatriarch();

              xssfclientanchor anchor = new xssfclientanchor( 480 , 30 , 700 , 250 , ( short ) 0 , i + 1 , ( short ) 1 , i + 2 );

              drawingpatriarch.createpicture(anchor, workbook.addpicture(data, xssfworkbook.picture_type_jpeg));

              sheet.setcolumnwidth(( short ) 500 , ( short ) 500 );

              row.setheight(( short ) 500 );

            } else {

              cell.setcelltype(xssfcell.cell_type_string);

              cell.setcellvalue( "" );

            }

          } else {

            cell.setcelltype(xssfcell.cell_type_string);

            object value = map.get(key);

            cell.setcellvalue(value == null ? "" : value.tostring());

            cell.setcellstyle(cellstyle);

          }

        }

      }

      // 设置列宽

     for ( int i = 1 ; i < alias.length; i++)

        sheet.autosizecolumn(i);

      // 处理中文不能自动调整列宽的问题

this .setsizecolumn(sheet, alias.length);

    }

    fileoutput.flush();

    workbook.write(fileoutput);

    fileoutput.close();

  }

  // 自适应宽度(中文支持)

  private void setsizecolumn(xssfsheet sheet, int size) {

    for ( int columnnum = 0 ; columnnum < size; columnnum++) {

      int columnwidth = sheet.getcolumnwidth(columnnum) / 256 ;

      for ( int rownum = 0 ; rownum <= sheet.getlastrownum(); rownum++) {

        xssfrow currentrow;

        //当前行未被使用过

        if (sheet.getrow(rownum) == null ) {

          currentrow = sheet.createrow(rownum);

        } else {

          currentrow = sheet.getrow(rownum);

        }

        if (currentrow.getcell(columnnum) != null ) {

          xssfcell currentcell = currentrow.getcell(columnnum);

          if (currentcell.getcelltype() == xssfcell.cell_type_string) {

            int length = currentcell.getstringcellvalue().getbytes().length;

            if (columnwidth < length) columnwidth = length;

          }

        }

      }

      columnwidth = columnwidth * 256 ;

      sheet.setcolumnwidth(columnnum, columnwidth >= 65280 ? 6000 : columnwidth);

    }

  }