com.diboot.components.file.excel

类 ExcelReader

java.lang.Object

com.diboot.components.file.excel.ExcelReader

public class ExcelReader
extends Object

Dibo Excel 读取类

版本:

20161107 Copyright @ www.dibo.ltd

作者:

Mazc@dibo.ltd

字段概要

字段

限定符和类型	字段和说明
private static String	DATE_FORMAT
private static String	ERROR
private static DecimalFormat	fmtDecimal
private static org.slf4j.Logger	logger

构造器概要

构造器

构造器和说明
ExcelReader()

方法概要

限定符和类型	方法和说明
private static String[]	buildRowValues(org.apache.poi.ss.usermodel.Row hssfRow, int rowNum, int cellCount) 组装行数据
private static String	getValue(org.apache.poi.ss.usermodel.Cell cell) 获取Excel单元格的值
private static List<String[]>	readXls(InputStream is) Read the Excel 2003-2007
private static List<String[]>	readXlsx(InputStream is) Read the Excel 2010
static List<String[]>	toList(File file) 对excel文件的解析
static List<String[]>	toList(org.springframework.web.multipart.MultipartFile file) 对excel文件的解析
static List<String[]>	toList(String excelFilePath) 对excel文件的解析

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

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

字段详细资料

logger

private static final org.slf4j.Logger logger

fmtDecimal

private static DecimalFormat fmtDecimal

DATE_FORMAT

private static final String DATE_FORMAT

另请参阅:

常量字段值

ERROR

private static final String ERROR

另请参阅:

常量字段值

构造器详细资料

ExcelReader

public ExcelReader()

方法详细资料

toList

public static List<String[]> toList(String excelFilePath)
                             throws Exception

对excel文件的解析

参数:

excelFilePath -

返回:

抛出:

Exception

toList

public static List<String[]> toList(File file)
                             throws Exception

对excel文件的解析

参数:

file -

返回:

抛出:

Exception

toList

public static List<String[]> toList(org.springframework.web.multipart.MultipartFile file)
                             throws Exception

对excel文件的解析

参数:

file -

返回:

抛出:

Exception

readXlsx

private static List<String[]> readXlsx(InputStream is)
                                throws Exception

Read the Excel 2010

参数:

is - the path of the excel file

返回:

抛出:

Exception

readXls

private static List<String[]> readXls(InputStream is)
                               throws Exception

Read the Excel 2003-2007

参数:

is - the path of the Excel

返回:

抛出:

Exception

buildRowValues

private static String[] buildRowValues(org.apache.poi.ss.usermodel.Row hssfRow,
                                       int rowNum,
                                       int cellCount)
                                throws Exception

组装行数据

参数:

hssfRow -

rowNum -

cellCount -

返回:

抛出:

Exception

getValue

private static String getValue(org.apache.poi.ss.usermodel.Cell cell)

获取Excel单元格的值

参数:

cell -

返回: