gu.sql2java.excel

类 SheetReader

java.lang.Object

gu.sql2java.excel.BaseExcelReader<org.apache.poi.ss.usermodel.Row>

gu.sql2java.excel.SheetReader

public class SheetReader
extends BaseExcelReader<org.apache.poi.ss.usermodel.Row>

EXCEL(.xls,.xlsx)文件导入

从以下版本开始:

3.29.0

作者:

guyadong

字段概要

从类继承的字段 gu.sql2java.excel.BaseExcelReader

beanConsumer, debugOutput, fetchColumns, sheetConfig

构造器概要

构造器

构造器和说明
SheetReader()
SheetReader(java.util.function.Consumer<?> beanConsumer)
SheetReader(SheetConfig sheetConfig)
SheetReader(SheetConfig sheetConfig, java.util.function.Consumer<?> beanConsumer)
SheetReader(SheetConfig sheetConfig, java.util.List<?> rows, java.util.function.Consumer<?> beanConsumer)

方法概要

限定符和类型	方法和说明
SheetReader	debugOutput(boolean debugOutput) 设置调试输出标志
protected java.lang.String	getCellAsString(org.apache.poi.ss.usermodel.Row row, int idx)
protected java.util.List<java.lang.Integer>	indexsOfRow(org.apache.poi.ss.usermodel.Row row) 返回列的索引范围列表
protected boolean	isEmptyCell(org.apache.poi.ss.usermodel.Row row, int idx) 行由idx指定单元为空返回true，否则返回false
protected boolean	moreEmptyCheck(org.apache.poi.ss.usermodel.Row row)
void	read(java.io.InputStream inputStream, java.nio.charset.Charset charset, java.lang.String format) 从InputStream将导入数据记录

从类继承的方法 gu.sql2java.excel.BaseExcelReader

converExp, getRows, getSheetConfig, read, read, read, read, readFrom, setRows, setSheetConfig

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

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

构造器详细资料

SheetReader

public SheetReader()

SheetReader

public SheetReader(java.util.function.Consumer<?> beanConsumer)

SheetReader

public SheetReader(SheetConfig sheetConfig,
                   java.util.function.Consumer<?> beanConsumer)

SheetReader

public SheetReader(SheetConfig sheetConfig,
                   java.util.List<?> rows,
                   java.util.function.Consumer<?> beanConsumer)

SheetReader

public SheetReader(SheetConfig sheetConfig)

方法详细资料

debugOutput

public SheetReader debugOutput(boolean debugOutput)

设置调试输出标志

参数:

debugOutput -

read

public void read(java.io.InputStream inputStream,
                 java.nio.charset.Charset charset,
                 java.lang.String format)
          throws java.io.IOException

从类复制的说明: BaseExcelReader

从InputStream将导入数据记录

指定者:

read 在类中 BaseExcelReader<org.apache.poi.ss.usermodel.Row>

charset - 数据编码为null使用默认值

format - 文件格式,即文件后缀: .xls,xlxs,.cxv

抛出:

java.io.IOException

getCellAsString

protected java.lang.String getCellAsString(org.apache.poi.ss.usermodel.Row row,
                                           int idx)

指定者:

getCellAsString 在类中 BaseExcelReader<org.apache.poi.ss.usermodel.Row>

isEmptyCell

protected boolean isEmptyCell(org.apache.poi.ss.usermodel.Row row,
                              int idx)

从类复制的说明: BaseExcelReader

行由idx指定单元为空返回true，否则返回false

指定者:

isEmptyCell 在类中 BaseExcelReader<org.apache.poi.ss.usermodel.Row>

indexsOfRow

protected java.util.List<java.lang.Integer> indexsOfRow(org.apache.poi.ss.usermodel.Row row)

从类复制的说明: BaseExcelReader

返回列的索引范围列表

指定者:

indexsOfRow 在类中 BaseExcelReader<org.apache.poi.ss.usermodel.Row>

moreEmptyCheck

protected boolean moreEmptyCheck(org.apache.poi.ss.usermodel.Row row)

覆盖:

moreEmptyCheck 在类中 BaseExcelReader<org.apache.poi.ss.usermodel.Row>