Auxiliary function used by xlread
[value,text] = xlread_scan(data,isText,isNum,tightFlag)
These parameters are described as the outputs of xlread_data.
a boolean. If tightFlag is true, then the value,text matrices tightly enclose the region where data of the corresponding type is found. This is the case when the range is not specified in the xlread call.
a matrix of strings containing the textual data found in the sheet at specfied range.
a matrix of numbers containing the numerical data found in the sheet at specfied range.
This low level function is called by the main xlread function (see the dedicated help page) but it can be used after calling xlread_data and some subsequent raw data processing.
This function is based on POI library (http://poi.apache.org/).