xlread_scan

Arguments

data,isText,isNum

These parameters are described as the outputs of xlread_data.

tightFlag

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.

text

a matrix of strings containing the textual data found in the sheet at specfied range.

value

a matrix of numbers containing the numerical data found in the sheet at specfied range.

Description

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.

See also

• xlread — Read Microsoft Excel spreadsheet file using Java
• xlread_data — Auxiliary function used by xlread
• xlwrite — Write to Microsoft Excel spreadsheet file using Java
• xlinfo — Test if file is an Excel workbook file and get info

Bibliography

This function is based on POI library (http://poi.apache.org/).