@GetMapping("/devices/export")
@Timed
public void exportAllDeviceOut(DeviceCriteria criteria, HttpServletResponse response) throws IOException {
log.debug("REST request to get OrgMembers by criteria: {}", criteria);
List<DeviceDTO> devices = deviceQueryService.findByCriteria(criteria);
Map<String, Object[]> rows = new TreeMap<>();
rows.put("1", new Object[]{"单位名称", "设备号", "绑定时间", "设备地址", "物联网卡号", "类型", "状态"});
for (int i = 0; i < devices.size(); i++) {
DeviceDTO device = devices.get(i);
rows.put(String.valueOf(i + 2), new Object[]{
device.getOrganizationName(),
device.getHardwareId(),
device.getBindDate(),
device.getHardwareAddress(),
device.getNetCard(),
device.getHardwareModel(),
device.isIsDisabled() ? "已禁用" : "已启用"
});
}
Workbook workbook = createWorkbookFromRows(rows);
String safeFileName = URLEncoder.encode("设备", "UTF-8");
response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
response.setHeader("Content-disposition", "attachment; filename=" + safeFileName + ".xlsx");
workbook.write(response.getOutputStream());
}
private XSSFWorkbook createWorkbookFromRows(Map<String, Object[]> rows) {
//Create blank workbook
XSSFWorkbook workbook = new XSSFWorkbook();
//Create a blank sheet
XSSFSheet spreadsheet = workbook.createSheet("设备 ");
//Create row object
XSSFRow row;
//Iterate over data and write to sheet
Set<String> keyid = rows.keySet();
int rowid = 0;
for (String key : keyid) {
row = spreadsheet.createRow(rowid++);
Object[] objectArr = rows.get(key);
int cellid = 0;
for (Object obj : objectArr) {
Cell cell = row.createCell(cellid++);
cell.setCellValue((String) obj);
}
}
return workbook;
}
poi导出实例excel
最新推荐文章于 2020-11-05 17:57:33 发布