xlsfinfo (MATLAB Functions)

Determine if file contains Microsoft Excel (.xls) spreadsheet

Syntax

type = xlsfinfo('filename')
[type, sheets] = xlsfinfo('filename')
xlsfinfo filename

Description

type = xlsfinfo('filename') returns the string 'Microsoft Excel Spreadsheet' in the type output if the file specified by filename can be read by the MATLAB function xlsread. Otherwise, type is the empty string.

[type, sheets] = xlsfinfo('filename') returns in the sheets output a cell array of strings containing the names of each spreadsheet in the file.

xlsfinfo filename is the command format for xlsfinfo.

Examples

When filename is an Excel spreadsheet,

[type, sheets] = xlsfinfo('myaccount.xls')

type =
   Microsoft Excel Spreadsheet

sheets = 
    'Sheet1'    'Income'    'Expenses'

See Also

xlsread, xlswrite

xlim, ylim, zlim xlsread