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.
0 个评论
回答(2 个)
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();
0 个评论
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')
1 个评论
Kalpesh Nayak
2016-11-25
Hi Jiro Doke,
Can you please tell how to change this properties of existing document. and save it.
另请参阅
类别
在 Help Center 和 File 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!