net.ymate.platform.commons

Class ISheetHandler.Default

java.lang.Object

net.ymate.platform.commons.ISheetHandler.Default

All Implemented Interfaces:

ISheetHandler<Object[]>

Enclosing interface:

ISheetHandler<T>

public static class ISheetHandler.Default
extends Object
implements ISheetHandler<Object[]>

Nested Class Summary

Nested classes/interfaces inherited from interface net.ymate.platform.commons.ISheetHandler

ISheetHandler.CellMeta, ISheetHandler.Default

Constructor Summary

Constructors

Constructor and Description
Default()

Method Summary

Modifier and Type	Method and Description
ISheetHandler.Default	decimalPattern(String decimalPattern)
ISheetHandler.Default	firstCellNum(int firstCellNum)
ISheetHandler.Default	firstRowNum(int firstRowNum)
ISheetHandler.CellMeta[]	getCellMetas() 获取单元格描述对象集合
List<Object[]>	handle(org.apache.poi.ss.usermodel.Sheet sheet) 处理Sheet页
ISheetHandler.Default	lastCellNum(int lastCellNum)
ISheetHandler.Default	lastRowNum(int lastRowNum)
Object[]	parseRow(org.apache.poi.ss.usermodel.Row row) 分析行数据

Methods inherited from class java.lang.Object

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

Constructor Detail

Default

public Default()

Method Detail

firstRowNum

public ISheetHandler.Default firstRowNum(int firstRowNum)

lastRowNum

public ISheetHandler.Default lastRowNum(int lastRowNum)

firstCellNum

public ISheetHandler.Default firstCellNum(int firstCellNum)

lastCellNum

public ISheetHandler.Default lastCellNum(int lastCellNum)

decimalPattern

public ISheetHandler.Default decimalPattern(String decimalPattern)

handle

public List<Object[]> handle(org.apache.poi.ss.usermodel.Sheet sheet)
                      throws Exception

Description copied from interface: ISheetHandler

处理Sheet页

Specified by:

handle in interface ISheetHandler<Object[]>

Parameters:

sheet - Sheet页接口对象

Returns:

返回数据对象集合

Throws:

Exception - 可能产生的任何异常

getCellMetas

public ISheetHandler.CellMeta[] getCellMetas()

Description copied from interface: ISheetHandler

获取单元格描述对象集合

Specified by:

getCellMetas in interface ISheetHandler<Object[]>

Returns:

返回单元格描述对象集合

parseRow

public Object[] parseRow(org.apache.poi.ss.usermodel.Row row)
                  throws Exception

Description copied from interface: ISheetHandler

分析行数据

Specified by:

parseRow in interface ISheetHandler<Object[]>

Parameters:

row - 记录行接口对象

Returns:

返回行数据对象

Throws:

Exception - 可能产生的任何异常