excel table data, specific reference sample:Using Excel


Variable Name Type Description
columns Array Read Only. Table column array
rows Array Read Only. Table row array


Method Description
addSortIndex Add a sort index to tabular data
addHashIndex Add a hash index to tabular data
getIndex Get a existed index
getPrimary Get sort index of primary key, sort index for the firest column by default
find Traversal search for the first data that satisfies the condition
findLast Traversal search for the last data that satisfies the condition
matches Traversal search for all datas that satisfies the condition
parseColumnToData transforming a column of data into a date class