<< 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 = fullpath(atomsGetLoadedPath("xlreadwrite")+'/demos/xlsx/Testbig.xlsx');
[status,sheets,wbformat] = xlinfo(filename)

See also

Bibliography

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


Report an issue
<< xlreadwrite xlreadwrite xlread >>