com.sh.javax.datastore

类 ExcelDatastore

java.lang.Object

com.sh.javax.datastore.Datastore

com.sh.javax.datastore.FileDatastore

com.sh.javax.datastore.ExcelDatastore

所有已实现的接口:

DatastoreInterface, java.io.Serializable, java.lang.Cloneable

public class ExcelDatastore
extends FileDatastore

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

Title:首亨软件 - 聚天平台

版本:

4.0

作者:

江兴春

另请参阅:

序列化表格

嵌套类概要

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

Datastore.Comp, Datastore.DsFilter_I

字段概要

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

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(java.lang.String path) 加载Excel数据到数据集中
static void	main(java.lang.String[] args)
ExcelDatastore	setSheetIndex(int sheetIndex) 设置读取的sheet页

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

getContext, getLimitRow, getPath, getStartRow, getTotalLoadRowCount, getTotalRowCount, isFirstAsHeader, isForceCalTotalRow, isUseTrim, setBatchModelFunc, setFirstLineAsHeader, setForceCalTotalRow, setLimitRow, setPath, setStartRow, setUseTrim

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

addGloableData, addRowData, addRowData, avg, avg, changeColumnName, clearFilter, clone, columnCount, concat, concat, concat, concat, concatWithNoRepeat, concatWithNoRepeat, convert2XMLDatastore, convert2XMLDatastore, copy, copy, deleteColumn, deletedCount, deleteDuplicateRow, deleteRow, filter, filter, filteredCount, 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, 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, getItemObjectString2, getItemObjectString2, getItemStatus, getItemStatus, getItemStatus, getItemStatus, getItemString, getItemString, getItemString, getItemString, getItemString2, getItemString2, getItemTime, getItemTime, getItemTime, getItemTime, 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, 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, toJSONArray2, toJSONArray2, toJSONArrayWithBeautify, toJSONArrayWithBeautify2, toJSONArrayWithLowerKey, toJSONArrayWithLowerKey2, toString

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

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

构造器详细资料

ExcelDatastore

public ExcelDatastore()

方法详细资料

load

public boolean load(java.lang.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开始

返回:

main

public static void main(java.lang.String[] args)
                 throws java.lang.Exception

抛出:

java.lang.Exception