org.jeecgframework.poi.excel.entity.params.ExcelExportEntity Java Examples

/**
 * 对导出序列进行排序和塞选
 * 
 * @param excelParams
 * @param titlemap
 * @return
 */
private void sortAndFilterExportField(List<ExcelExportEntity> excelParams, Map<String, Integer> titlemap) {
	for (int i = excelParams.size() - 1; i >= 0; i--) {
		if (excelParams.get(i).getList() != null && excelParams.get(i).getList().size() > 0) {
			sortAndFilterExportField(excelParams.get(i).getList(), titlemap);
			if (excelParams.get(i).getList().size() == 0) {
				excelParams.remove(i);
			} else {
				excelParams.get(i).setOrderNum(i);
			}
		} else {
			if (titlemap.containsKey(excelParams.get(i).getName())) {
				excelParams.get(i).setOrderNum(i);
			} else {
				excelParams.remove(i);
			}
		}
	}
	sortAllParams(excelParams);
}
 

private Map<Integer, int[]> getMergeDataMap(List<ExcelExportEntity> excelParams) {
	Map<Integer, int[]> mergeMap = new HashMap<Integer, int[]>();
	// 设置参数顺序,为之后合并单元格做准备
	int i = 0;
	for (ExcelExportEntity entity : excelParams) {
		if (entity.isMergeVertical()) {
			mergeMap.put(i, entity.getMergeRely());
		}
		if (entity.getList() != null) {
			for (ExcelExportEntity inner : entity.getList()) {
				if (inner.isMergeVertical()) {
					mergeMap.put(i, inner.getMergeRely());
				}
				i++;
			}
		} else {
			i++;
		}
	}
	return mergeMap;
}
 

private Map<Integer, int[]> getMergeDataMap(List<ExcelExportEntity> excelParams) {
	Map<Integer, int[]> mergeMap = new HashMap<Integer, int[]>();
	// 设置参数顺序,为之后合并单元格做准备
	int i = 0;
	for (ExcelExportEntity entity : excelParams) {
		if (entity.isMergeVertical()) {
			mergeMap.put(i, entity.getMergeRely());
		}
		if (entity.getList() != null) {
			for (ExcelExportEntity inner : entity.getList()) {
				if (inner.isMergeVertical()) {
					mergeMap.put(i, inner.getMergeRely());
				}
				i++;
			}
		} else {
			i++;
		}
	}
	return mergeMap;
}
 

/**
 * 创建List之后的各个Cells
 * 
 * @param styles
 */
public void createListCells(int index, int cellNum, Object obj,
                            List<ExcelExportEntity> excelParams, XWPFTable table)
                                                                                 throws Exception {
    ExcelExportEntity entity;
    XWPFTableRow row;
    if (table.getRow(index) == null) {
        row = table.createRow();
        row.setHeight(getRowHeight(excelParams));
    } else {
        row = table.getRow(index);
    }
    for (int k = 0, paramSize = excelParams.size(); k < paramSize; k++) {
        entity = excelParams.get(k);
        Object value = getCellValue(entity, obj);
        if (entity.getType() == 1) {
            setCellValue(row, value, cellNum++);
        }
    }
}
 

/**
 * 创建导出实体对象
 * 
 * @param field
 * @param targetId
 * @param pojoClass
 * @param getMethods
 * @return
 * @throws Exception
 */
private ExcelExportEntity createExcelExportEntity(Field field, String targetId,
                                                  Class<?> pojoClass, List<Method> getMethods)
                                                                                              throws Exception {
    Excel excel = field.getAnnotation(Excel.class);
    ExcelExportEntity excelEntity = new ExcelExportEntity();
    excelEntity.setType(excel.type());
    getExcelField(targetId, field, excelEntity, excel, pojoClass);
    if (getMethods != null) {
        List<Method> newMethods = new ArrayList<Method>();
        newMethods.addAll(getMethods);
        newMethods.add(excelEntity.getMethod());
        excelEntity.setMethods(newMethods);
    }
    return excelEntity;
}
 

/**
 * 获取填如这个cell的值,提供一些附加功能
 * 
 * @param entity
 * @param obj
 * @return
 * @throws Exception
 */
public Object getCellValue(ExcelExportEntity entity, Object obj) throws Exception {
    Object value;
    if (obj instanceof Map) {
        value = ((Map<?, ?>) obj).get(entity.getKey());
    } else {
        value = entity.getMethods() != null ? getFieldBySomeMethod(entity.getMethods(), obj)
            : entity.getMethod().invoke(obj, new Object[] {});
    }
    if (StringUtils.isNotEmpty(entity.getFormat())) {
        value = formatValue(value, entity);
    }
    if (entity.getReplace() != null && entity.getReplace().length > 0) {
        value = replaceValue(entity.getReplace(), String.valueOf(value));
    }
    if (needHanlderList != null && needHanlderList.contains(entity.getName())) {
        value = dataHanlder.exportHandler(obj, entity.getName(), value);
    }
    if (StringUtils.isNotEmpty(entity.getSuffix()) && value != null) {
        value = value + entity.getSuffix();
    }
    return value == null ? "" : value.toString();
}
 

/**
 * 创建List之后的各个Cells
 * 
 * @param styles
 */
public void createListCells(Drawing patriarch, int index, int cellNum, Object obj, List<ExcelExportEntity> excelParams, Sheet sheet, Workbook workbook) throws Exception {
	ExcelExportEntity entity;
	Row row;
	if (sheet.getRow(index) == null) {
		row = sheet.createRow(index);
		row.setHeight(getRowHeight(excelParams));
	} else {
		row = sheet.getRow(index);
	}
	for (int k = 0, paramSize = excelParams.size(); k < paramSize; k++) {
		entity = excelParams.get(k);
		Object value = getCellValue(entity, obj);
		//update-begin--Author:xuelin  Date:20171018 for：TASK #2372 【excel】easypoi 导出类型，type增加数字类型--------------------
		if (entity.getType() == 1) {
			createStringCell(row, cellNum++, value == null ? "" : value.toString(), row.getRowNum() % 2 == 0 ? getStyles(false, entity) : getStyles(true, entity), entity);
		} else if (entity.getType() == 4){
			createNumericCell(row, cellNum++, value == null ? "" : value.toString(), index % 2 == 0 ? getStyles(false, entity) : getStyles(true, entity), entity);
		}  else{
			createImageCell(patriarch, entity, row, cellNum++, value == null ? "" : value.toString(), obj);
		}
		//update-end--Author:xuelin  Date:20171018 for：TASK #2372 【excel】easypoi 导出类型，type增加数字类型--------------------
	}
}
 

/**
 * 获取填如这个cell的值,提供一些附加功能
 * 
 * @param entity
 * @param obj
 * @return
 * @throws Exception
 */
public Object getCellValue(ExcelExportEntity entity, Object obj) throws Exception {
	Object value;
	if (obj instanceof Map) {
		value = ((Map<?, ?>) obj).get(entity.getKey());
	} else {
		value = entity.getMethods() != null ? getFieldBySomeMethod(entity.getMethods(), obj) : entity.getMethod().invoke(obj, new Object[] {});
	}
	if (StringUtils.isNotEmpty(entity.getFormat())) {
		value = formatValue(value, entity);
	}
	if (entity.getReplace() != null && entity.getReplace().length > 0) {
		value = replaceValue(entity.getReplace(), String.valueOf(value));
	}
	if (needHanlderList != null && needHanlderList.contains(entity.getName())) {
		value = dataHanlder.exportHandler(obj, entity.getName(), value);
	}
	if (StringUtils.isNotEmpty(entity.getSuffix()) && value != null) {
		value = value + entity.getSuffix();
	}
	return value == null ? "" : value.toString();
}
 

/**
 * 注解到导出对象的转换
 * 
 * @param targetId
 * @param field
 * @param excelEntity
 * @param excel
 * @param pojoClass
 * @throws Exception
 */
private void getExcelField(String targetId, Field field, ExcelExportEntity excelEntity,
                           Excel excel, Class<?> pojoClass) throws Exception {
    excelEntity.setName(getExcelName(excel.name(), targetId));
    excelEntity.setWidth(excel.width());
    excelEntity.setHeight(excel.height());
    excelEntity.setNeedMerge(excel.needMerge());
    excelEntity.setMergeVertical(excel.mergeVertical());
    excelEntity.setMergeRely(excel.mergeRely());
    excelEntity.setReplace(excel.replace());
    excelEntity.setOrderNum(getCellOrder(excel.orderNum(), targetId));
    excelEntity.setWrap(excel.isWrap());
    excelEntity.setExportImageType(excel.imageType());
    excelEntity.setSuffix(excel.suffix());
    excelEntity.setDatabaseFormat(excel.databaseFormat());
    excelEntity.setFormat(StringUtils.isNotEmpty(excel.exportFormat()) ? excel.exportFormat()
        : excel.format());
    excelEntity.setStatistics(excel.isStatistics());
    String fieldname = field.getName();
    excelEntity.setMethod(PoiPublicUtil.getMethod(fieldname, pojoClass));
}
 

@Override
protected void renderMergedOutputModel(Map<String, Object> model, HttpServletRequest request, HttpServletResponse response) throws Exception {
	String codedFileName = "临时文件";
	Workbook workbook = ExcelExportUtil.exportExcel((ExportParams) model.get(MapExcelConstants.PARAMS), (List<ExcelExportEntity>) model.get(MapExcelConstants.ENTITY_LIST), (Collection<? extends Map<?, ?>>) model.get(MapExcelConstants.MAP_LIST));
	if (model.containsKey(MapExcelConstants.FILE_NAME)) {
		codedFileName = (String) model.get(MapExcelConstants.FILE_NAME);
	}
	if (workbook instanceof HSSFWorkbook) {
		codedFileName += HSSF;
	} else {
		codedFileName += XSSF;
	}
	if (isIE(request)) {
		codedFileName = java.net.URLEncoder.encode(codedFileName, "UTF8");
	} else {
		codedFileName = new String(codedFileName.getBytes("UTF-8"), "ISO-8859-1");
	}
	response.setHeader("content-disposition", "attachment;filename=" + codedFileName);
	ServletOutputStream out = response.getOutputStream();
	workbook.write(out);
	out.flush();
}
 

private Map<Integer, int[]> getMergeDataMap(List<ExcelExportEntity> excelParams) {
    Map<Integer, int[]> mergeMap = new HashMap<Integer, int[]>();
    // 设置参数顺序,为之后合并单元格做准备
    int i = 0;
    for (ExcelExportEntity entity : excelParams) {
        if (entity.isMergeVertical()) {
            mergeMap.put(i, entity.getMergeRely());
        }
        if (entity.getList() != null) {
            for (ExcelExportEntity inner : entity.getList()) {
                if (inner.isMergeVertical()) {
                    mergeMap.put(i, inner.getMergeRely());
                }
                i++;
            }
        } else {
            i++;
        }
    }
    return mergeMap;
}
 

@Override
protected void renderMergedOutputModel(Map<String, Object> model, HttpServletRequest request,
                                       HttpServletResponse response) throws Exception {
    String codedFileName = "临时文件";
    Workbook workbook = ExcelExportUtil.exportExcel(
        (ExportParams) model.get(MapExcelConstants.PARAMS),
        (List<ExcelExportEntity>) model.get(MapExcelConstants.ENTITY_LIST),
        (Collection<? extends Map<?, ?>>) model.get(MapExcelConstants.MAP_LIST));
    if (model.containsKey(MapExcelConstants.FILE_NAME)) {
        codedFileName = (String) model.get(MapExcelConstants.FILE_NAME);
    }
    if (workbook instanceof HSSFWorkbook) {
        codedFileName += HSSF;
    } else {
        codedFileName += XSSF;
    }
    if (isIE(request)) {
        codedFileName = java.net.URLEncoder.encode(codedFileName, "UTF8");
    } else {
        codedFileName = new String(codedFileName.getBytes("UTF-8"), "ISO-8859-1");
    }
    response.setHeader("content-disposition", "attachment;filename=" + codedFileName);
    ServletOutputStream out = response.getOutputStream();
    workbook.write(out);
    out.flush();
}
 

/**
 * 创建List之后的各个Cells
 * 
 * @param styles
 */
public void createListCells(Drawing patriarch, int index, int cellNum, Object obj, List<ExcelExportEntity> excelParams, Sheet sheet, Workbook workbook) throws Exception {
	ExcelExportEntity entity;
	Row row;
	if (sheet.getRow(index) == null) {
		row = sheet.createRow(index);
		row.setHeight(getRowHeight(excelParams));
	} else {
		row = sheet.getRow(index);
	}
	for (int k = 0, paramSize = excelParams.size(); k < paramSize; k++) {
		entity = excelParams.get(k);
		Object value = getCellValue(entity, obj);
		if (entity.getType() == 1) {
			createStringCell(row, cellNum++, value == null ? "" : value.toString(), row.getRowNum() % 2 == 0 ? getStyles(false, entity) : getStyles(true, entity), entity);
		} else if (entity.getType() == 4){
			createNumericCell(row, cellNum++, value == null ? "" : value.toString(), index % 2 == 0 ? getStyles(false, entity) : getStyles(true, entity), entity);
		}  else{
			createImageCell(patriarch, entity, row, cellNum++, value == null ? "" : value.toString(), obj);
		}
	}
}
 

/**
 * 创建List之后的各个Cells
 * 
 * @param styles
 */
public void createListCells(Drawing patriarch, int index, int cellNum, Object obj,
                            List<ExcelExportEntity> excelParams, Sheet sheet, Workbook workbook)
                                                                                                throws Exception {
    ExcelExportEntity entity;
    Row row;
    if (sheet.getRow(index) == null) {
        row = sheet.createRow(index);
        row.setHeight(getRowHeight(excelParams));
    } else {
        row = sheet.getRow(index);
    }
    for (int k = 0, paramSize = excelParams.size(); k < paramSize; k++) {
        entity = excelParams.get(k);
        Object value = getCellValue(entity, obj);
        if (entity.getType() == 1) {
            createStringCell(row, cellNum++, value == null ? "" : value.toString(),
                row.getRowNum() % 2 == 0 ? getStyles(false, entity) : getStyles(true, entity),
                entity);
        } else {
            createImageCell(patriarch, entity, row, cellNum++,
                value == null ? "" : value.toString(), obj);
        }
    }
}
 

/**
 * 创建List之后的各个Cells
 * 
 * @param styles
 */
public void createListCells(int index, int cellNum, Object obj, List<ExcelExportEntity> excelParams, XWPFTable table) throws Exception {
	ExcelExportEntity entity;
	XWPFTableRow row;
	if (table.getRow(index) == null) {
		row = table.createRow();
		row.setHeight(getRowHeight(excelParams));
	} else {
		row = table.getRow(index);
	}
	for (int k = 0, paramSize = excelParams.size(); k < paramSize; k++) {
		entity = excelParams.get(k);
		Object value = getCellValue(entity, obj);
		if (entity.getType() == 1) {
			setCellValue(row, value, cellNum++);
		}
	}
}
 

/**
 * 对导出序列进行排序和塞选
 * 
 * @param excelParams
 * @param titlemap
 * @return
 */
private void sortAndFilterExportField(List<ExcelExportEntity> excelParams,
                                      Map<String, Integer> titlemap) {
    for (int i = excelParams.size() - 1; i >= 0; i--) {
        if (excelParams.get(i).getList() != null && excelParams.get(i).getList().size() > 0) {
            sortAndFilterExportField(excelParams.get(i).getList(), titlemap);
            if (excelParams.get(i).getList().size() == 0) {
                excelParams.remove(i);
            } else {
                excelParams.get(i).setOrderNum(i);
            }
        } else {
            if (titlemap.containsKey(excelParams.get(i).getName())) {
                excelParams.get(i).setOrderNum(i);
            } else {
                excelParams.remove(i);
            }
        }
    }
    sortAllParams(excelParams);
}
 

/**
 * 获取单个对象的高度,主要是处理一堆多的情况
 * 
 * @param styles
 * @param rowHeight
 * @throws Exception
 */
public int getOneObjectSize(Object t, List<ExcelExportEntity> excelParams) throws Exception {
    ExcelExportEntity entity;
    int maxHeight = 1;
    for (int k = 0, paramSize = excelParams.size(); k < paramSize; k++) {
        entity = excelParams.get(k);
        if (entity.getList() != null) {
            Collection<?> list = (Collection<?>) entity.getMethod().invoke(t, new Object[] {});
            if (list != null && list.size() > maxHeight) {
                maxHeight = list.size();
            }
        }
    }
    return maxHeight;

}
 

/**
 * 把基础数据转换成Excel导出的数据
 *
 * @param lists
 * @return
 */
private List<ExcelExportEntity> convertToExportEntity(List<CgFormFieldEntity> lists) {
	// 对字段列按顺序排序
	Collections.sort(lists, new FieldNumComparator());
	List<ExcelExportEntity> entityList = new ArrayList<ExcelExportEntity>();
	for (int i = 0; i < lists.size(); i++) {
		if (lists.get(i).getIsShow().equals("Y")) {
			ExcelExportEntity entity = new ExcelExportEntity(lists.get(i).getContent(), lists.get(i).getFieldName());
			int columnWidth = lists.get(i).getLength() == 0 ? 12 : lists.get(i).getLength() > 30 ? 30 : lists.get(i).getLength();
			if (lists.get(i).getShowType().equals("date")) {
				entity.setFormat("yyyy-MM-dd");
			} else if (lists.get(i).getShowType().equals("datetime")) {
				entity.setFormat("yyyy-MM-dd HH:mm:ss");
			}
			entity.setWidth(columnWidth);
			entityList.add(entity);
		}
	}
	return entityList;
}
 

/**
 * 对导出序列进行排序和塞选
 * 
 * @param excelParams
 * @param titlemap
 * @return
 */
private void sortAndFilterExportField(List<ExcelExportEntity> excelParams, Map<String, Integer> titlemap) {
	for (int i = excelParams.size() - 1; i >= 0; i--) {
		if (excelParams.get(i).getList() != null && excelParams.get(i).getList().size() > 0) {
			sortAndFilterExportField(excelParams.get(i).getList(), titlemap);
			if (excelParams.get(i).getList().size() == 0) {
				excelParams.remove(i);
			} else {
				excelParams.get(i).setOrderNum(i);
			}
		} else {
			if (titlemap.containsKey(excelParams.get(i).getName())) {
				excelParams.get(i).setOrderNum(i);
			} else {
				excelParams.remove(i);
			}
		}
	}
	sortAllParams(excelParams);
}
 

/**
 * 创建List之后的各个Cells
 * 
 * @param styles
 */
public void createListCells(int index, int cellNum, Object obj, List<ExcelExportEntity> excelParams, XWPFTable table) throws Exception {
	ExcelExportEntity entity;
	XWPFTableRow row;
	if (table.getRow(index) == null) {
		row = table.createRow();
		row.setHeight(getRowHeight(excelParams));
	} else {
		row = table.getRow(index);
	}
	for (int k = 0, paramSize = excelParams.size(); k < paramSize; k++) {
		entity = excelParams.get(k);
		Object value = getCellValue(entity, obj);
		if (entity.getType() == 1) {
			setCellValue(row, value, cellNum++);
		}
	}
}
 

/**
 * 对导出序列进行排序和塞选
 * 
 * @param excelParams
 * @param titlemap
 * @return
 */
private void sortAndFilterExportField(List<ExcelExportEntity> excelParams, Map<String, Integer> titlemap) {
	for (int i = excelParams.size() - 1; i >= 0; i--) {
		if (excelParams.get(i).getList() != null && excelParams.get(i).getList().size() > 0) {
			sortAndFilterExportField(excelParams.get(i).getList(), titlemap);
			if (excelParams.get(i).getList().size() == 0) {
				excelParams.remove(i);
			} else {
				excelParams.get(i).setOrderNum(i);
			}
		} else {
			if (titlemap.containsKey(excelParams.get(i).getName())) {
				excelParams.get(i).setOrderNum(i);
			} else {
				excelParams.remove(i);
			}
		}
	}
	sortAllParams(excelParams);
}
 

@Override
protected void renderMergedOutputModel(Map<String, Object> model, HttpServletRequest request, HttpServletResponse response) throws Exception {
	String codedFileName = "临时文件";
	Workbook workbook = ExcelExportUtil.exportExcel((ExportParams) model.get(MapExcelConstants.PARAMS), (List<ExcelExportEntity>) model.get(MapExcelConstants.ENTITY_LIST), (Collection<? extends Map<?, ?>>) model.get(MapExcelConstants.MAP_LIST));
	if (model.containsKey(MapExcelConstants.FILE_NAME)) {
		codedFileName = (String) model.get(MapExcelConstants.FILE_NAME);
	}
	if (workbook instanceof HSSFWorkbook) {
		codedFileName += HSSF;
	} else {
		codedFileName += XSSF;
	}
	if (isIE(request)) {
		codedFileName = java.net.URLEncoder.encode(codedFileName, "UTF8");
	} else {
		codedFileName = new String(codedFileName.getBytes("UTF-8"), "ISO-8859-1");
	}
	response.setHeader("content-disposition", "attachment;filename=" + codedFileName);
	ServletOutputStream out = response.getOutputStream();
	workbook.write(out);
	out.flush();
}
 

/**
 * 把从表数据加到主表中
 *
 * @param subTable
 * @param configs
 * @param result
 * @param entityList
 */
private void addAllSubTableDate(String subTable, Map<String, Object> configs, List<Map<String, Object>> result, List<ExcelExportEntity> entityList) {
	String jversion = cgFormFieldService.getCgFormVersionByTableName(subTable);
	Map<String, Object> subConfigs = configService.queryConfigs(subTable, jversion);
	ExcelExportEntity tableEntity = new ExcelExportEntity(subConfigs.get(CgAutoListConstant.CONFIG_NAME).toString(), subTable);
	List<CgFormFieldEntity> beans = (List<CgFormFieldEntity>) subConfigs.get(CgAutoListConstant.FILEDS);
	tableEntity.setList(convertToExportEntity(beans));
	entityList.add(tableEntity);
	// 对字段列按顺序排序
	for (int i = 0; i < result.size(); i++) {
		List<Map<String, Object>> subResult = cgFormFieldService.getSubTableData(configs.get(CgAutoListConstant.CONFIG_ID).toString(), subTable, result.get(i).get("id"));
		handlePageDic(beans, subResult);
		dealDic(subResult, beans);
		result.get(i).put(subTable,subResult);
	}
}
 

/**
 * 获取集合的值
 * 
 * @param entity
 * @param obj
 * @return
 * @throws Exception
 */
public Collection<?> getListCellValue(ExcelExportEntity entity, Object obj) throws Exception {
	Object value;
	if (obj instanceof Map) {
		value = ((Map<?, ?>) obj).get(entity.getKey());
	} else {
		value = (Collection<?>) entity.getMethod().invoke(obj, new Object[] {});
	}
	return (Collection<?>) value;
}
 

/**
 * 对字段根据用户设置排序
 */
public void sortAllParams(List<ExcelExportEntity> excelParams) {
	Collections.sort(excelParams);
	for (ExcelExportEntity entity : excelParams) {
		if (entity.getList() != null) {
			Collections.sort(entity.getList());
		}
	}
}
 

/**
 * 对字段根据用户设置排序
 */
public void sortAllParams(List<ExcelExportEntity> excelParams) {
    Collections.sort(excelParams);
    for (ExcelExportEntity entity : excelParams) {
        if (entity.getList() != null) {
            Collections.sort(entity.getList());
        }
    }
}
 

/**
 * 判断表头是只有一行还是两行
 * 
 * @param excelParams
 * @return
 */
private int getRowNums(List<ExcelExportEntity> excelParams) {
	for (int i = 0; i < excelParams.size(); i++) {
		if (excelParams.get(i).getList() != null && StringUtils.isNotBlank(excelParams.get(i).getName())) {
			return 2;
		}
	}
	return 1;
}
 

/**
 * 下移数据
 * @param its
 * @param excelParams
 * @return
 */
private int getShiftRows(Collection<?> dataSet, List<ExcelExportEntity> excelParams)
                                                                                    throws Exception {
    int size = 0;
    Iterator<?> its = dataSet.iterator();
    while (its.hasNext()) {
        Object t = its.next();
        size += getOneObjectSize(t, excelParams);
    }
    return size;
}
 

private int createHeaderAndTitle(ExportParams entity, Sheet sheet, Workbook workbook, List<ExcelExportEntity> excelParams) {
	int rows = 0, feildWidth = getFieldWidth(excelParams);
	if (entity.getTitle() != null) {
		rows += createHeaderRow(entity, sheet, workbook, feildWidth);
	}
	rows += createTitleRow(entity, sheet, workbook, rows, excelParams);
	sheet.createFreezePane(0, rows, 0, rows);
	return rows;
}
 

/**
 * 创建导出实体对象
 * 
 * @param field
 * @param targetId
 * @param pojoClass
 * @param getMethods
 * @return
 * @throws Exception
 */
private ExcelExportEntity createExcelExportEntity(Field field, String targetId, Class<?> pojoClass, List<Method> getMethods) throws Exception {
	Excel excel = field.getAnnotation(Excel.class);
	ExcelExportEntity excelEntity = new ExcelExportEntity();
	excelEntity.setType(excel.type());
	getExcelField(targetId, field, excelEntity, excel, pojoClass);
	if (getMethods != null) {
		List<Method> newMethods = new ArrayList<Method>();
		newMethods.addAll(getMethods);
		newMethods.add(excelEntity.getMethod());
		excelEntity.setMethods(newMethods);
	}
	return excelEntity;
}