Xlsreadr

Purpose

Reads .XLS files from MS Excel and other spreadsheets.

Synopsis

out = xlsreadr(file,sheets,options)

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 (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. Optional input (options) specifies the parsing options. For details on these options, see parsemixed.

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, parsemixed, writecsv, xclgetdata, xclreadr