How to read external file data from a .xls file into matlab
12 次查看(过去 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 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!