package com.zhaoxinms.common.utils.poi;
import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;
import java.lang.reflect.Field;
import java.lang.reflect.Method;
import java.math.BigDecimal;
import java.text.DecimalFormat;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.Comparator;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.Set;
import java.util.UUID;
import java.util.stream.Collectors;
import javax.servlet.http.HttpServletResponse;
import org.apache.poi.hssf.usermodel.HSSFClientAnchor;
import org.apache.poi.hssf.usermodel.HSSFPicture;
import org.apache.poi.hssf.usermodel.HSSFPictureData;
import org.apache.poi.hssf.usermodel.HSSFShape;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ooxml.POIXMLDocumentPart;
import org.apache.poi.ss.usermodel.BorderStyle;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.CellStyle;
import org.apache.poi.ss.usermodel.CellType;
import org.apache.poi.ss.usermodel.ClientAnchor;
import org.apache.poi.ss.usermodel.DataValidation;
import org.apache.poi.ss.usermodel.DataValidationConstraint;
import org.apache.poi.ss.usermodel.DataValidationHelper;
import org.apache.poi.ss.usermodel.DateUtil;
import org.apache.poi.ss.usermodel.Drawing;
import org.apache.poi.ss.usermodel.FillPatternType;
import org.apache.poi.ss.usermodel.Font;
import org.apache.poi.ss.usermodel.HorizontalAlignment;
import org.apache.poi.ss.usermodel.IndexedColors;
import org.apache.poi.ss.usermodel.PictureData;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.VerticalAlignment;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.ss.usermodel.WorkbookFactory;
import org.apache.poi.ss.util.CellRangeAddress;
import org.apache.poi.ss.util.CellRangeAddressList;
import org.apache.poi.util.IOUtils;
import org.apache.poi.xssf.streaming.SXSSFWorkbook;
import org.apache.poi.xssf.usermodel.XSSFClientAnchor;
import org.apache.poi.xssf.usermodel.XSSFDataValidation;
import org.apache.poi.xssf.usermodel.XSSFDrawing;
import org.apache.poi.xssf.usermodel.XSSFPicture;
import org.apache.poi.xssf.usermodel.XSSFShape;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.openxmlformats.schemas.drawingml.x2006.spreadsheetDrawing.CTMarker;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import com.zhaoxinms.common.annotation.Excel;
import com.zhaoxinms.common.annotation.Excels;
import com.zhaoxinms.common.annotation.Excel.ColumnType;
import com.zhaoxinms.common.annotation.Excel.Type;
import com.zhaoxinms.common.config.RuoYiConfig;
import com.zhaoxinms.common.core.domain.AjaxResult;
import com.zhaoxinms.common.core.text.Convert;
import com.zhaoxinms.common.exception.UtilException;
import com.zhaoxinms.common.utils.DateUtils;
import com.zhaoxinms.common.utils.DictUtils;
import com.zhaoxinms.common.utils.StringUtils;
import com.zhaoxinms.common.utils.file.FileTypeUtils;
import com.zhaoxinms.common.utils.file.FileUtils;
import com.zhaoxinms.common.utils.file.ImageUtils;
import com.zhaoxinms.common.utils.reflect.ReflectUtils;
/**
* 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;
/**
* 当前行号
*/
private int rownum;
/**
* 标题
*/
private String title;
/**
* 最大高度
*/
private short maxHeight;
/**
* 统计列表
*/
private Map<Integer, Double> statistics = new HashMap<Integer, Double>();
/**
* 数字格式
*/
private static final DecimalFormat DOUBLE_FORMAT = new DecimalFormat("######0.00");
/**
* 实体对象
*/
public Class<T> clazz;
public ExcelUtil(Class<T> clazz)
{
this.clazz = clazz;
}
public void init(List<T> list, String sheetName, String title, Type type)
{
if (list == null)
{
list = new ArrayList<T>();
}
this.list = list;
this.sheetName = sheetName;
this.type = type;
this.title = title;
createExcelField();
createWorkbook();
createTitle();
}
/**
* 创建excel第一行标题
*/
public void createTitle()
{
if (StringUtils.isNotEmpty(title))
{
Row titleRow = sheet.createRow(rownum == 0 ? rownum++ : 0);
titleRow.setHeightInPoints(30);
Cell titleCell = titleRow.createCell(0);
titleCell.setCellStyle(styles.get("title"));
titleCell.setCellValue(title);
sheet.addMergedRegion(new CellRangeAddress(titleRow.getRowNum(), titleRow.getRowNum(), titleRow.getRowNum(),
this.fields.size() - 1));
}
}
/**
* 对excel表单默认第一个索引名转换成list
*
* @param is 输入流
* @return 转换后集合
*/
public List<T> importExcel(InputStream is) throws Exception
{
return importExcel(is, 0);
}
/**
* 对excel表单默认第一个索引名转换成list
*
* @param is 输入流
* @param titleNum 标题占用行数
* @return 转换后集合
*/
public List<T> importExcel(InputStream is, int titleNum) throws Exception
{
return importExcel(StringUtils.EMPTY, is, titleNum);
}
/**
* 对excel表单指定表格索引名转换成list
*
* @param sheetName 表格索引名
* @param titleNum 标题占用行数
* @param is 输入流
* @return 转换后集合
*/
public List<T> importExcel(String sheetName, InputStream is, int titleNum) throws Exception
{
this.type = Type.IMPORT;
this.wb = WorkbookFactory.create(is);
List<T> list = new ArrayList<T>();
// 如果指定sheet名,则取指定sheet中的内容 否则默认指向第1个sheet
Sheet sheet = StringUtils.isNotEmpty(sheetName) ? wb.getSheet(sheetName) : wb.getSheetAt(0);
if (sheet == null)
{
throw new IOException("文件sheet不存在");
}
boolean isXSSFWorkbook = !(wb instanceof HSSFWorkbook);
Map<String, PictureData> pictures;
if (isXSSFWorkbook)
{
pictures = getSheetPictures07((XSSFSheet) sheet, (XSSFWorkbook) wb);
}
else
{
pictures = getSheetPictures03((HSSFSheet) sheet, (HSSFWorkbook) wb);
}
// 获取最后一个非空行的行下标,比如总行数为n,则返回的为n-1
int rows = sheet.getLastRowNum();
if (rows > 0)
{
// 定义一个map用于存放excel列的序号和field.
Map<String, Integer> cellMap = new HashMap<String, Integer>();
// 获取表头
Row heard = sheet.getRow(titleNum);
for (int i = 0; i < heard.getPhysicalNumberOfCells(); i++)
{
Cell cell = heard.getCell(i);
if (StringUtils.isNotNull(cell))
{
String value
没有合适的资源?快使用搜索试试~ 我知道了~
温馨提示
Spring Boot+Spring Security+MyBatis+Vue+Mysql物业管理系统源码,前后端分离,有完整前后台源码,系统经多次测试,运行无误,大家放心下载。
资源推荐
资源详情
资源评论
收起资源包目录
Spring Boot+Spring Security+MyBatis+Vue+Mysql物业管理系统源码 (2943个子文件)
ry.bat 2KB
run.bat 269B
package.bat 185B
build.bat 142B
package.bat 141B
run-web.bat 139B
clean.bat 102B
CHANGES 3KB
CHANGES 3KB
ExcelUtil.class 38KB
PaymentBillServiceImpl.class 29KB
ProcessServiceImpl.class 23KB
DateUtil.class 23KB
PaymentBillEntity.class 20KB
ConfigHouseServiceImpl.class 20KB
PaymentContractServiceImpl.class 19KB
PaymentMeterServiceImpl.class 18KB
PaymentPayLogServiceImpl.class 18KB
FlowRepairVo.class 17KB
FlowRepairServiceImpl.class 16KB
FlowRepairBo.class 16KB
ConfigFeeItemServiceImpl.class 16KB
PaymentPreAccountServiceImpl.class 16KB
PaymentBillCreateServiceImpl.class 16KB
FlowComplaintsServiceImpl.class 16KB
PaymentPreServiceImpl.class 16KB
FileUtil.class 15KB
DictionaryDataController.class 15KB
FlowComplaintsVo.class 15KB
CustomProcessDiagramGenerator.class 15KB
FlowRepair.class 15KB
FlowRepairPagination.class 15KB
GenTableServiceImpl.class 15KB
FlowComplaintsPagination.class 15KB
FlowComplaintsBo.class 15KB
PaymentBillListVO.class 14KB
PaymentContractEntity.class 14KB
FlowComplaints.class 14KB
PaymentDepositServiceImpl.class 14KB
PaymentPayLogEntity.class 14KB
PaymentTempServiceImpl.class 14KB
SysMenuServiceImpl.class 14KB
Convert.class 13KB
Convert.class 13KB
HTMLFilter.class 13KB
DailyFeeReportController.class 13KB
BillRuleServiceImpl.class 13KB
PaymentDepositEntity.class 12KB
PaymentTempEntity.class 12KB
ActivitiProcessController.class 12KB
SysUserServiceImpl.class 12KB
DesignerAdapterUtil.class 12KB
BillRuleEntity.class 12KB
ConfigFeeItemEntity.class 11KB
PaymentMeterIndexServiceImpl.class 11KB
ModelerController.class 11KB
PaymentMeterEntity.class 11KB
ConfigFeeItemController.class 11KB
TaskVo.class 11KB
PaymentPreEntity.class 11KB
ReflectUtils.class 11KB
SysUserController.class 11KB
VelocityUtils.class 11KB
PaymentContractCrForm.class 11KB
CustomProcessDiagramCanvas.class 10KB
PaymentMeterImportController.class 10KB
PaymentPayLogListVO.class 10KB
FlowDesignerEntity.class 10KB
HouseContractListVO.class 10KB
OwnerUserServiceImpl.class 10KB
ConfigHouseEntity.class 10KB
ConfigFeeAlertServiceImpl.class 10KB
DictionaryDataEntity.class 10KB
ActivitiProcessDefinitionController.class 10KB
ConfigHouseBlockServiceImpl.class 10KB
SysDeptServiceImpl.class 10KB
DictionaryDataServiceImpl.class 10KB
PaymentPayLogCrForm.class 9KB
PaymentBillCrForm.class 9KB
PaymentContractController.class 9KB
SysRoleServiceImpl.class 9KB
SysRoleController.class 9KB
DictionaryTypeEntity.class 9KB
ListToTreeUtil.class 9KB
PaymentContractFeeServiceImpl.class 9KB
ProcessDefinitionService.class 9KB
PaymentStatisticsMapper.class 9KB
StringUtil.class 9KB
ConfigHouseContractController.class 9KB
RedisUtil.class 9KB
HttpUtils.class 8KB
DictionaryTypeServiceImpl.class 8KB
TreeViewModel.class 8KB
PaymentBillStatisticsController.class 8KB
MyBatisConfig.class 8KB
OwnerUserController.class 8KB
Server.class 8KB
OwnerUser.class 8KB
PaymentDepositListVO.class 8KB
PaymentTempListVO.class 8KB
共 2943 条
- 1
- 2
- 3
- 4
- 5
- 6
- 30
资源评论
reg183
- 粉丝: 1811
- 资源: 1万+
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功