Xlsreadr: Difference between revisions
Jump to navigation
Jump to search
imported>Jeremy (Importing text file) |
imported>Jeremy (Importing text file) |
||
| Line 1: | Line 1: | ||
===Purpose=== | ===Purpose=== | ||
Reads .XLS files from MS Excel and other spreadsheets. | Reads .XLS files from MS Excel and other spreadsheets. | ||
===Synopsis=== | ===Synopsis=== | ||
:out = xlsreadr(file,sheets,options) | :out = xlsreadr(file,sheets,options) | ||
===Description=== | ===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. | 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. | 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=== | ===See Also=== | ||
[[areadr]], [[dataset]], [[xclgetdata]], [[xclreadr]] | [[areadr]], [[dataset]], [[xclgetdata]], [[xclreadr]] | ||
Revision as of 14:27, 3 September 2008
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.