qc.ExcelSheet

Description

excel table data, specific reference sample:Using Excel

Variables

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

Methods

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