package com.ruoyi.common.utils.poi;
import com.ruoyi.common.annotation.Excel;
import com.ruoyi.common.annotation.Excel.ColumnType;
import com.ruoyi.common.annotation.Excel.Type;
import com.ruoyi.common.annotation.Excels;
import com.ruoyi.common.config.RuoYiConfig;
import com.ruoyi.common.core.domain.AjaxResult;
import com.ruoyi.common.core.text.Convert;
import com.ruoyi.common.exception.CustomException;
import com.ruoyi.common.utils.DateUtils;
import com.ruoyi.common.utils.DictUtils;
import com.ruoyi.common.utils.StringUtils;
import com.ruoyi.common.utils.reflect.ReflectUtils;
import org.apache.poi.hssf.usermodel.HSSFDateUtil;
import org.apache.poi.ss.usermodel.*;
import org.apache.poi.ss.util.CellRangeAddressList;
import org.apache.poi.xssf.streaming.SXSSFWorkbook;
import org.apache.poi.xssf.usermodel.XSSFDataValidation;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import java.io.*;
import java.lang.reflect.Field;
import java.lang.reflect.Method;
import java.math.BigDecimal;
import java.util.*;
import java.util.stream.Collectors;
/**
* Excel相关处理
*
* @author ruoyi
*/
public class ExcelUtil<T>
{
private static final Logger log = LoggerFactory.getLogger(ExcelUtil.class);
/**
* Excel sheet最大行数，默认65536
*/
public static final int sheetSize = 65536;
/**
* 工作表名称
*/
private String sheetName;
/**
* 导出类型（EXPORT:导出数据；IMPORT：导入模板）
*/
private Type type;
/**
* 工作薄对象
*/
private Workbook wb;
/**
* 工作表对象
*/
private Sheet sheet;
/**
* 样式列表
*/
private Map<String, CellStyle> styles;
/**
* 导入导出数据列表
*/
private List<T> list;
/**
* 注解列表
*/
private List<Object[]> fields;
/**
* 实体对象
*/
public Class<T> clazz;
public ExcelUtil(Class<T> clazz)
{
this.clazz = clazz;
}
public void init(List<T> list, String sheetName, Type type)
{
if (list == null)
{
list = new ArrayList<T>();
}
this.list = list;
this.sheetName = sheetName;
this.type = type;
createExcelField();
createWorkbook();
}
/**
* 对excel表单默认第一个索引名转换成list
*
* @param is 输入流
* @return 转换后集合
*/
public List<T> importExcel(InputStream is) throws Exception
{
return importExcel(StringUtils.EMPTY, is);
}
/**
* 对excel表单指定表格索引名转换成list
*
* @param sheetName 表格索引名
* @param is 输入流
* @return 转换后集合
*/
public List<T> importExcel(String sheetName, InputStream is) throws Exception
{
this.type = Type.IMPORT;
this.wb = WorkbookFactory.create(is);
List<T> list = new ArrayList<T>();
Sheet sheet = null;
if (StringUtils.isNotEmpty(sheetName))
{
// 如果指定sheet名,则取指定sheet中的内容.
sheet = wb.getSheet(sheetName);
}
else
{
// 如果传入的sheet名不存在则默认指向第1个sheet.
sheet = wb.getSheetAt(0);
}
if (sheet == null)
{
throw new IOException("文件sheet不存在");
}
int rows = sheet.getPhysicalNumberOfRows();
if (rows > 0)
{
// 定义一个map用于存放excel列的序号和field.
Map<String, Integer> cellMap = new HashMap<String, Integer>();
// 获取表头
Row heard = sheet.getRow(0);
for (int i = 0; i < heard.getPhysicalNumberOfCells(); i++)
{
Cell cell = heard.getCell(i);
if (StringUtils.isNotNull(cell))
{
String value = this.getCellValue(heard, i).toString();
cellMap.put(value, i);
}
else
{
cellMap.put(null, i);
}
}
// 有数据时才处理 得到类的所有field.
Field[] allFields = clazz.getDeclaredFields();
// 定义一个map用于存放列的序号和field.
Map<Integer, Field> fieldsMap = new HashMap<Integer, Field>();
for (int col = 0; col < allFields.length; col++)
{
Field field = allFields[col];
Excel attr = field.getAnnotation(Excel.class);
if (attr != null && (attr.type() == Type.ALL || attr.type() == type))
{
// 设置类的私有字段属性可访问.
field.setAccessible(true);
Integer column = cellMap.get(attr.name());
if (column != null)
{
fieldsMap.put(column, field);
}
}
}
for (int i = 1; i < rows; i++)
{
// 从第2行开始取数据,默认第一行是表头.
Row row = sheet.getRow(i);
T entity = null;
for (Map.Entry<Integer, Field> entry : fieldsMap.entrySet())
{
Object val = this.getCellValue(row, entry.getKey());
// 如果不存在实例则新建.
entity = (entity == null ? clazz.newInstance() : entity);
// 从map中得到对应列的field.
Field field = fieldsMap.get(entry.getKey());
// 取得类型,并根据对象类型设置值.
Class<?> fieldType = field.getType();
if (String.class == fieldType)
{
String s = Convert.toStr(val);
if (StringUtils.endsWith(s, ".0"))
{
val = StringUtils.substringBefore(s, ".0");
}
else
{
val = Convert.toStr(val);
}
}
else if ((Integer.TYPE == fieldType) || (Integer.class == fieldType))
{
val = Convert.toInt(val);
}
else if ((Long.TYPE == fieldType) || (Long.class == fieldType))
{
val = Convert.toLong(val);
}
else if ((Double.TYPE == fieldType) || (Double.class == fieldType))
{
val = Convert.toDouble(val);
}
else if ((Float.TYPE == fieldType) || (Float.class == fieldType))
{
val = Convert.toFloat(val);
}
else if (BigDecimal.class == fieldType)
{
val = Convert.toBigDecimal(val);
}
else if (Date.class == fieldType)
{
if (val instanceof String)
{
val = DateUtils.parseDate(val);
}
else if (val instanceof Double)
{
val = DateUtil.getJavaDate((Double) val);
}
}
if (StringUtils.isNotNull(fieldType))
{
Excel attr = field.getAnnotation(Excel.class);
String propertyName = field.getName();
if (StringUtils.isNotEmpty(attr.targetAttr()))
{
propertyName = field.getName() + "." + attr
基于Java开发的云诊所Hncc平台设计源码 （700个子文件） 
$PROJECT_FILE$ 6KB ExcelUtil.class 26KB Convert.class 14KB HTMLFilter.class 13KB ReflectUtils.class 11KB BmsOperatorSettleRecord.class 9KB HttpUtils.class 8KB SysUser.class 8KB DmsCaseHistory.class 8KB RedisCache.class 7KB DmsNonDrugItemRecord.class 7KB StringUtils.class 7KB UUID.class 6KB VerifyCodeUtils.class 6KB SmsWorkloadRecord.class 6KB SysMenu.class 5KB FileUploadUtils.class 5KB SysRole.class 5KB SysDept.class 5KB SwaggerConfig.class 5KB SysDictData.class 5KB DmsDrug.class 5KB DmsHerbalPrescriptionRecord.class 5KB DmsMedicineItemRecord.class 5KB SmsDept.class 5KB DmsDrugModel.class 5KB DmsMedicinePrescriptionRecordController.class 4KB BmsBillsRecordController.class 4KB Base64.class 4KB DmsHerbalPrescriptionRecordController.class 4KB SmsRolePermissionRelationController.class 4KB SmsFrequentUsed.class 4KB BmsOperatorSettleRecordController.class 4KB DmsDrugRefundItemRecordController.class 4KB DictUtils.class 4KB DmsMedicineItemRecordController.class 4KB DmsNonDrugItemRecordController.class 4KB DmsMedicineModelItemController.class 4KB DmsRegistrationController.class 4KB DmsCaseModelCatalogController.class 4KB DmsHerbalItemRecordController.class 4KB SmsRegistrationRankController.class 4KB DmsHerbalModelItemController.class 4KB DmsNonDrug.class 4KB DmsMedicineModelItem.class 4KB SmsFrequentUsedController.class 4KB BmsInvoiceRecordController.class 4KB SmsWorkloadRecordController.class 4KB DmsNonDrugModelController.class 4KB BmsInvoiceRecord.class 4KB DmsDiseCatalogController.class 4KB DmsCaseModel.class 4KB SmsDescriptionController.class 4KB SmsSkdRuleItemController.class 4KB DmsCaseHistoryController.class 4KB BmsSettlementCatController.class 4KB SmsPermissionController.class 4KB BmsInvoiceExpController.class 4KB DmsCaseModelController.class 4KB DmsDrugModelController.class 4KB SmsLoginLogController.class 4KB SmsStaff.class 4KB DmsNonDrugController.class 4KB PmsPatientController.class 4KB SmsSkdRuleController.class 4KB DmsDosageController.class 4KB LoginUser.class 4KB DmsDrugController.class 4KB SmsStaffController.class 4KB DmsDiseController.class 4KB SmsRoleController.class 4KB SmsSkdController.class 4KB SmsDeptController.class 4KB DmsDrugRefundItemRecord.class 4KB DmsRegistration.class 4KB DateUtils.class 4KB DmsHerbalItemRecord.class 4KB IpUtils.class 4KB XssFilter.class 4KB DmsCaseModelCatalog.class 4KB ServletUtils.class 4KB DmsNonDrugModel.class 3KB TreeSelect.class 3KB DmsMedicinePrescriptionRecord.class 3KB PmsPatient.class 3KB SpringUtils.class 3KB BaseController.class 3KB SmsSkd.class 3KB SmsPermission.class 3KB SysDictType.class 3KB FileUtils.class 3KB BmsBillsRecord.class 3KB BaseEntity.class 3KB SmsSkdRule.class 3KB DmsHerbalModelItem.class 3KB EscapeUtil.class 3KB SmsDescription.class 3KB BeanUtils.class 3KB SmsRegistrationRank.class 3KB SmsSkdRuleItem.class 3KB共 700 条
- 1
- 2
- 3
- 4
- 5
- 6
- 7
资源评论
