PLS_Toolbox Documentation: xlsreadr	< xclreadr	yscale >

xlsreadr

Purpose

Reads .XLS files from MS Excel and other spreadsheets.

Synopsis

out = xlsreadr(file,sheets)

Description

This function reads Microsoft XLS files, parses the contents into a DataSet object. If called with no input a dialog box allows the user to select a file to read from the hard disk. Optional input file is a text string with the file name. Optional input sheets is a cell array containing the names of one or more sheets in XLS file to read.

Note that the primary difference between this function and the Mathworks function xlsread is the parsing of labels and output of a dataset object.

See Also

areadr, dataset, xclgetdata, xclreadr