程序包 com.sh.javax.datastore

类 ExcelDatastore

java.lang.Object

com.sh.javax.datastore.Datastore

com.sh.javax.datastore.FileDatastore

com.sh.javax.datastore.ExcelDatastore

所有已实现的接口:

DatastoreInterface, Serializable, Cloneable

public class ExcelDatastore
extends FileDatastore

Description: 通过Excel文件生成Datastore对象

Title:首亨软件 - 聚天平台

另请参阅:

• 序列化表格

嵌套类概要

从类继承的嵌套类/接口 com.sh.javax.datastore.Datastore

Datastore.Comp, Datastore.DsFilter_I

字段概要

从类继承的字段 com.sh.javax.datastore.FileDatastore

batchRow, consumer, context, firstAsHeader, forceCalTotalRow, hasRenderHeader, headerFunc, itemDataFunc, limitRow, path, separator, startRow, totalLoadRowCount, totalRowCount, useTrim

从类继承的字段 com.sh.javax.datastore.Datastore

cols, columnIndexMap, datalist, drows, filter, forEachBreak, frows, gloableDataMap, header, isCacheData, lastGetCol, log4j, prows, queryColsType, queryObj, queryTime, sort, sql

从接口继承的字段 com.sh.javax.datastore.DatastoreInterface

BIGDECIMAL, BIGINT, BLOB, CLOB, DATAMODIFYED, DATATYPE_UNDEFINE, DATE, DELETE, DOUBLE, FILTER, FLOAT, INTEGER, NEW, NEWMODIFYED, NOTMODIFYED, OBJECT, PRIMARY, STRING, TIME, TIMESTAMP

构造器概要

构造器

构造器	说明
ExcelDatastore()

方法概要

修饰符和类型	方法	说明
int	getSheetIndex()
boolean	load(ExcelFile excelFile)	加载Excel文件到数据集中
boolean	load(String path)	加载Excel数据到数据集中
ExcelDatastore	setSheetIndex(int sheetIndex)	设置读取的sheet页

从类继承的方法 com.sh.javax.datastore.FileDatastore

checkAndFireConsumer, finishLoad, getContext, getLimitRow, getPath, getStartRow, getTotalLoadRowCount, getTotalRowCount, isFirstAsHeader, isForceCalTotalRow, isUseTrim, resetData, setBatchModelFunc, setFirstLineAsHeader, setForceCalTotalRow, setHeaderFunc, setItemDataFunc, setLimitRow, setPath, setStartRow, setUseTrim

从类继承的方法 com.sh.javax.datastore.Datastore

addGloableData, addRowData, addRowData, avg, avg, changeColumnName, clearAll, clearFilter, clone, columnCount, concat, concat, concat, concat, concatWithNoRepeat, concatWithNoRepeat, convert2XMLDatastore, convert2XMLDatastore, copy, copy, count, deleteColumn, deletedCount, deleteDuplicateRow, deleteRow, filter, filter, filteredCount, filterRow, find, find, forEach, forEach, getBlobInputStream, getBlobInputStream, getClobInputStream, getClobInputStream, getClobReader, getClobReader, getClobString, getClobString, getClobString, getClobString, getClobString2, getClobString2, getColumnIndexByName, getColumnName, getColumnName2, getColumnType, getColumnType, getData, getFilterDatastore, getFilterDatastore, getGloableData, getGloableData, getHeader, getItemBigDecimal, getItemBigDecimal, getItemDate, getItemDate, getItemDate, getItemDate, getItemDouble, getItemDouble, getItemDouble, getItemDouble, getItemDouble2, getItemDouble2, getItemDouble2Int, getItemDouble2Int, getItemDouble2Long, getItemDouble2Long, getItemDouble2String, getItemDouble2String, getItemDouble2String, getItemDouble2String, getItemDoubleEx, getItemDoubleEx, getItemFloat, getItemFloat, getItemFloat, getItemFloat, getItemFloat2, getItemFloat2, getItemFloat2Int, getItemFloat2Int, getItemFloat2String, getItemFloat2String, getItemFloat2String, getItemFloat2String, getItemInteger, getItemInteger, getItemInteger, getItemInteger, getItemInteger2, getItemInteger2, getItemInteger2String, getItemLong, getItemLong, getItemLong, getItemLong, getItemLong2, getItemLong2, getItemLong2String, getItemObjectString, getItemObjectString, getItemObjectString, getItemObjectString, getItemObjectString2, getItemObjectString2, getItemStatus, getItemStatus, getItemStatus, getItemStatus, getItemString, getItemString, getItemString, getItemString, getItemString2, getItemString2, getItemTime, getItemTime, getItemTime, getItemTime, getItemTimestamp, getItemTimestamp, getItemTimestamp, getItemTimestamp, getItemTimestamp, getItemTimestamp, getItemTimestamp, getItemTimestamp, getLabel, getLabel, getObject, getObject, getObject, getObject, getRowData, getRowInfo, getRowInfo, getRowInfoRef, getRowInfoRef, getSql, getValueWithExpress, getValueWithExpress, getValueWithExpress2, getValueWithExpress2, getValueWithExpress3, getValueWithExpress3, hasColumn, indexofcol, insertColumn, insertColumn, insertColumn, insertRow, isCacheData, isContainGlobleData, isEmpty, isForEachBreak, isPrimaryKey, isPrimaryKey, isVisible, isVisible, iterator, iterator, max, max, min, min, printLog, printLog, printLog, printLog, refresh, removeGloableData, reset, restoreFilterData, rowCount, rowsCopy, rowsCopy, rowsMove, setCacheData, setColumnData, setColumnData, setData, setFilter, setForEachBreak, setHeader, setItem, setItem, setItem, setItem, setItem, setItem, setItem, setItem, setItem, setItem, setItem, setItem, setItem, setItem, setItem, setItem, setItem, setItemStatus, setItemStatus, setItemStatus, setItemStatus, setObject, setObject, setPkCol, setRowData, setSort, setSql, setVisible, setVisible, sort, sort, stream, sum, sum, sum2, sum2, toDBBuilder, toJSONArray, toJSONArray, toJSONArrayWithBeautify, toJSONArrayWithLowerKey, toMarkdown, toString

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

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

构造器详细资料

ExcelDatastore

public ExcelDatastore()

方法详细资料

load

public boolean load(String path)

加载Excel数据到数据集中

指定者:

load 在类中 FileDatastore

参数:

path - 文件路径，支持网络文件

返回:

load

public boolean load(ExcelFile excelFile)

加载Excel文件到数据集中

参数:

excelFile - 文件解析对象

返回:

getSheetIndex

public int getSheetIndex()

setSheetIndex

public ExcelDatastore setSheetIndex(int sheetIndex)

设置读取的sheet页

参数:

sheetIndex - 从0开始

返回: