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

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

本文实例为大家分享了java使用poi导出图片到Excel的具体代码，供大家参考，具体内容如下

代码实现

Controller

/**

* 导出志愿者/人才数据

* @param talent_type

* @return

*/

@RequestMapping("/exportData")

public void exportData(Integer talent_type, HttpServletResponse response) {

String fileId = UUID.randomUUID().toString().replace("-", "");

Map param = new HashMap<>() ;

param.put("talent_type", talent_type) ;

try {

List

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("导出志愿者/人才数据异常！");

}

}

Service

public void exportData(List

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 map = (Map) 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 CellRangeAdmTOkDiZTkYdress(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) columnWidthmTOkDiZTkY = length;

}

}

}

columnWidth = columnWidth * 256 ;

sheet.setColumnWidth(columnNum, columnWidth >= 65280 ? 6000 : columnWidth);

}

}

以上所述是给大家介绍java poi导出图片到excel示例代码解整合，希望对大家有所帮助，如果大家有任何疑问请给我留言，会及时回复大家的。在此也非常感谢大家对我们网站的支持！

版权声明：本文内容由网络用户投稿，版权归原作者所有，本站不拥有其著作权，亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容，请联系我们jiasou666@gmail.com 处理，核实后本网站将在24小时内删除侵权内容。