<< xlreadwrite

xlreadwrite

xlread >>

xlreadwrite >> xlreadwrite > xlinfo

xlinfo

Test if file is an Excel workbook file and get info

Syntax

[status,sheets,wbformat]=xlinfo(file_path)

Arguments

file_path: a character string giving the path of the file to be checked
status: A boolean with %t value if file is a valid Excel file or %f if not.
sheets: a vector of strings containing the sheets names.
wbformat: a character string giving the format of the Excel file, 'xlOpenXMLWorkbook' for EXCEL2007 files or 'xlWorkbookNormal' for EXCEL97 files.

Examples

filename = fullfile(SCI,'modules/spreadsheet/demos/xls/t1.xls');
[status,sheets,wbformat] = xlinfo(filename)

filename = fullfile(SCI,'contrib/xlreadwrite/1.2/demos/xlsx/Testbig.xlsx');
[status,sheets,wbformat] = xlinfo(filename)

See also

xlwrite — Write to Microsoft Excel spreadsheet file using Java
xlinfo — Test if file is an Excel workbook file and get info
xls_open
xls_read
readxls

Bibliography

This function is based on POI library (http://poi.apache.org/).

Report an issue
<< xlreadwrite	xlreadwrite	xlread >>