xin.allonsy.utils

类 EasyExcelUtil

java.lang.Object

xin.allonsy.utils.EasyExcelUtil

public class EasyExcelUtil
extends Object

EasyExcelUtil

作者:

wangshuai

嵌套类概要

嵌套类

限定符和类型	类和说明
static class	EasyExcelUtil.CommonExcelListener<T> 模型 解析监听器
static class	EasyExcelUtil.ModelExcelListener 模型 解析监听器
private static class	EasyExcelUtil.StringExcelListener StringList 解析监听器

构造器概要

构造器

构造器和说明
EasyExcelUtil()

方法概要

限定符和类型	方法和说明
static boolean	isExcelFile(String fileName)
static List<Map<Integer,String>>	readExcelAsStringList(InputStream inputStream, String sheetName) 使用 StringList 来读取Excel 列号 ： value（列号从0开始）
static <T> List<T>	readExcelFromInputStream(InputStream inputStream, Class<T> clazz, int headRowNumber)
static List<Object>	readExcelFromLocalFilePath(String filePath, Class<? extends com.alibaba.excel.metadata.BaseRowModel> clazz, int headRowNumber) 通过文件名直接读取excel
static List<Object>	readExcelFromMultipartFile(org.springframework.web.multipart.MultipartFile multipartFile, Class<? extends com.alibaba.excel.metadata.BaseRowModel> clazz, int headRowNumber) 从web上读取excel
static List<Object>	readExcelWithModel(InputStream inputStream, Class<? extends com.alibaba.excel.metadata.BaseRowModel> clazz, com.alibaba.excel.support.ExcelTypeEnum excelTypeEnum, int sheetNo, int headLineMun) 已过时。
static <T> List<T>	readExcelWithSheetName(InputStream inputStream, Class<T> clazz, String sheetName)

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

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

构造器详细资料

EasyExcelUtil

public EasyExcelUtil()

方法详细资料

readExcelAsStringList

public static List<Map<Integer,String>> readExcelAsStringList(InputStream inputStream,
                                                              String sheetName)

使用 StringList 来读取Excel 列号 ： value（列号从0开始）

参数:

inputStream - Excel的输入流

返回:

返回 StringList 的列表

readExcelWithModel

@Deprecated
public static List<Object> readExcelWithModel(InputStream inputStream,
                                                           Class<? extends com.alibaba.excel.metadata.BaseRowModel> clazz,
                                                           com.alibaba.excel.support.ExcelTypeEnum excelTypeEnum,
                                                           int sheetNo,
                                                           int headLineMun)
                                                    throws IOException

已过时。

从流读取excel

参数:

inputStream -

clazz -

excelTypeEnum -

返回:

抛出:

IOException

readExcelWithSheetName

public static <T> List<T> readExcelWithSheetName(InputStream inputStream,
                                                 Class<T> clazz,
                                                 String sheetName)
                                          throws IOException

抛出:

IOException

readExcelFromLocalFilePath

public static List<Object> readExcelFromLocalFilePath(String filePath,
                                                      Class<? extends com.alibaba.excel.metadata.BaseRowModel> clazz,
                                                      int headRowNumber)

通过文件名直接读取excel

参数:

filePath -

headRowNumber -

返回:

readExcelFromInputStream

public static <T> List<T> readExcelFromInputStream(InputStream inputStream,
                                                   Class<T> clazz,
                                                   int headRowNumber)
                                            throws IOException

抛出:

IOException

readExcelFromMultipartFile

public static List<Object> readExcelFromMultipartFile(org.springframework.web.multipart.MultipartFile multipartFile,
                                                      Class<? extends com.alibaba.excel.metadata.BaseRowModel> clazz,
                                                      int headRowNumber)
                                               throws IOException

从web上读取excel

参数:

multipartFile -

headRowNumber -

返回:

抛出:

IOException

isExcelFile

public static boolean isExcelFile(String fileName)