<< xlread xlreadwrite xlread_scan >>

xlreadwrite >> xlreadwrite > xlread_data

xlread_data

Auxiliary function used by xlread

Syntax

[data,isText,isNum,custom] = xlread_data(file_path)
[data,isText,isNum,custom] = xlread_data(file_path,sheet)
[data,isText,isNum,custom] = xlread_data(file_path,sheet,range)
[data,isText,isNum,custom] = xlread_data(file_path,sheet,range,processFun)

Arguments

file_path,sheet,range,processFun

Input parameters are described on the help page of xlread

data

a cell array containing the raw data found in the sheet at specfied range. Empty cells are represented by NaN values.

isText

A matrix of boolean values with the same size as data. isText(i,j) is true when data{i,j} is a string.

isNum

A matrix of boolean values with the same size as data. isNum(i,j) is true when data{i,j} is a number.

custom

contains the eventual second output from processFun

Description

This low level function is called by the main xlread function (see the dedicated help page) but it can be used to process the raw data independently. The optional outputs isText, isNum and custom can be used to this purpose.

See also

Bibliography

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


Report an issue
<< xlread xlreadwrite xlread_scan >>