com.alanpoi.analysis.excel.imports.handle

类 ExcelHandle

java.lang.Object

com.alanpoi.analysis.excel.imports.handle.ExcelHandle

直接已知子类:

AbstractFileParser

public class ExcelHandle
extends Object

excel核心处理类

从以下版本开始:

2020-2-26

作者:

zhuoxun.peng

字段概要

字段

限定符和类型	字段和说明
String	downloadPath
ExcelWorkbookManage	excelWorkbookManage
ExecutorTools	executorTools
String	port
org.springframework.data.redis.core.StringRedisTemplate	redisTemplate
String	tmpPath

构造器概要

构造器

构造器和说明
ExcelHandle()

方法概要

限定符和类型	方法和说明
void	addErrorInfo(String workbookId, int sheetIndex, List<RowError> rowErrors)
void	addErrorInfo(String workbookId, int sheetIndex, RowError rowError)
void	addErrorInfo(String workbookId, List<RowError> rowErrors)
ExcelImportRes	process(String workbookId, List<ExcelSheetData> sheetDataList, Excel excel)

从类继承的方法 java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

字段详细资料

excelWorkbookManage

public ExcelWorkbookManage excelWorkbookManage

executorTools

public ExecutorTools executorTools

redisTemplate

public org.springframework.data.redis.core.StringRedisTemplate redisTemplate

port

@Value(value="${server.port:8080}")
public String port

tmpPath

@Value(value="${excel.tmp_path:/tmp/import/}")
public String tmpPath

downloadPath

@Value(value="${excel.download_path:/download/}")
public String downloadPath

构造器详细资料

ExcelHandle

public ExcelHandle()

方法详细资料

process

public ExcelImportRes process(String workbookId,
                              List<ExcelSheetData> sheetDataList,
                              Excel excel)

addErrorInfo

public void addErrorInfo(String workbookId,
                         List<RowError> rowErrors)

addErrorInfo

public void addErrorInfo(String workbookId,
                         int sheetIndex,
                         RowError rowError)

addErrorInfo

public void addErrorInfo(String workbookId,
                         int sheetIndex,
                         List<RowError> rowErrors)