com.alanpoi.analysis.common.utils

类 ExcelImportUtil

java.lang.Object

com.alanpoi.analysis.common.utils.ExcelImportUtil

public class ExcelImportUtil
extends Object

Excel Import Util

从以下版本开始:

2020-3-10

作者:

pengzhuoxun

构造器概要

构造器

构造器和说明
ExcelImportUtil()

方法概要

限定符和类型	方法和说明
static void	asyncImport(String excelId, InputStream inputStream, String fileName)
static void	asyncImport(String excelId, InputStream inputStream, String fileName, Map<Serializable,Object> excelParam) send async import
static ExcelImportRes	customImportData(String excelId, InputStream inputStream, String fileName)
static ExcelImportRes	customImportData(String excelId, InputStream inputStream, String fileName, Map<Serializable,Object> excelParam) Custom Import Data User inheritable interface `ExcelConsumeInterface` processing business logic,Can be used with methods `reportExcelError`
static void	download(String fileId, javax.servlet.http.HttpServletResponse response, javax.servlet.http.HttpServletRequest request)
static List<ExcelSheetData>	getExcelData(String excelId, InputStream inputStream, String fileName) Get Excel Data
static void	reportExcelError(String workbookId, int sheetIndex, List<RowError> sheetErrors) Report Excel Error
static void	reportExcelError(String workbookId, int sheetIndex, RowError rowError)
static void	reportExcelError(String workbookId, List<RowError> rowErrors)

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

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

构造器详细资料

ExcelImportUtil

public ExcelImportUtil()

方法详细资料

getExcelData

public static List<ExcelSheetData> getExcelData(String excelId,
                                                InputStream inputStream,
                                                String fileName)

Get Excel Data

参数:

excelId -

inputStream -

fileName -

返回:

List excel data

customImportData

public static ExcelImportRes customImportData(String excelId,
                                              InputStream inputStream,
                                              String fileName,
                                              Map<Serializable,Object> excelParam)

Custom Import Data User inheritable interface `ExcelConsumeInterface` processing business logic,Can be used with methods `reportExcelError`

参数:

excelId -

inputStream -

fileName -

excelParam -

返回:

ExcelImportRes

customImportData

public static ExcelImportRes customImportData(String excelId,
                                              InputStream inputStream,
                                              String fileName)

asyncImport

public static void asyncImport(String excelId,
                               InputStream inputStream,
                               String fileName,
                               Map<Serializable,Object> excelParam)

send async import

参数:

excelId -

inputStream -

fileName -

excelParam -

asyncImport

public static void asyncImport(String excelId,
                               InputStream inputStream,
                               String fileName)

reportExcelError

public static void reportExcelError(String workbookId,
                                    int sheetIndex,
                                    List<RowError> sheetErrors)

Report Excel Error

参数:

workbookId -

sheetIndex -

sheetErrors -

reportExcelError

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

reportExcelError

public static void reportExcelError(String workbookId,
                                    int sheetIndex,
                                    RowError rowError)

download

public static void download(String fileId,
                            javax.servlet.http.HttpServletResponse response,
                            javax.servlet.http.HttpServletRequest request)