PLS_Toolbox Documentation: xclreadr	< xclputdata	xlsreadr >

xclreadr

Purpose

Reads ASCII flat files from MS Excel and other spreadsheets.

Synopsis

out = xclreadr(file,delim,options)

Description

XCLREADR reads tab, space, comma, semicolon or bar delimited files with names on the columns (variables) and rows (samples).

If XCLREADR is called with no input, or an empty matrix for file name file, 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 to read.

Optional input delim can be used to specify delimiter character. Supported delimiters include:

                'tab' or   sprintf('\t')

            'space' or   ' '

            'comma' or   ','

              'semi' or   ';'

                'bar' or   '|'

The output out is a dataset object with date, time, info (data from cell (1,1)) the variable names (vars), sample names (samps), and data matrix (data).

Options

             options =   a structure array with the following fields:

         headerrows:   [{0}] number of header rows to expect in the file.

           rowlabels:   [{1}] number of row labels to expect in the file.

           collabels:   [{1}] number of column labels to expect in the file.

The default options can be retreived using: options = xclreadr('options');.

See Also

areadr, dataset, spcreadr, xclgetdata, xclputdata, xlsreadr