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

1 次查看(过去 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')

类别

Help CenterFile Exchange 中查找有关 Use COM Objects in MATLAB 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by