Xlsreadr: Difference between revisions
Jump to navigation
Jump to search
imported>Scott |
imported>Bob No edit summary |
||
| Line 9: | Line 9: | ||
===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 | 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. 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. | ||
Revision as of 09:32, 18 January 2015
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 (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.