How to read external file data from a .xls file into matlab

4 次查看(过去 30 天)
Hi,
Can anyone tell me how to read external file data like author, date created, date modified etc.. from an excel file into matlab.

回答(2 个)

Jiro Doke
Jiro Doke 2011-3-15
If you're on Windows, you can use the COM client support to do it. You can make use of the BuiltinDocumentProperties of the Workbook object (VBA).
% Connect to Excel
Excel = actxserver('excel.application');
% Get Workbook object
WB = Excel.Workbooks.Open(fullfile(pwd, 'Book1.xlsx'),0,true);
% Get Document Properties
x = WB.BuiltinDocumentProperties;
% Get Author
y = get(x, 'Item', 'Author');
author = get(y, 'Value')
% Get Creation Date
y = get(x, 'Item', 'Creation Date');
date_created = get(y, 'Value')
% Get Last Save Time
y = get(x, 'Item', 'Last Save Time');
date_modified = get(y, 'Value')
% Close Workbook
WB.Close();
% Quit Excel
Excel.Quit();

Sisi Ma
Sisi Ma 2011-3-15
you mean the property of a xls file? try putting those xls files in your current directory and do:
dir('*.xls')

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by