How to read external file data from a .xls file into matlab
7 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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 commentaires
Réponses (2)
Jiro Doke
le 15 Mar 2011
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 commentaires
Sisi Ma
le 15 Mar 2011
you mean the property of a xls file? try putting those xls files in your current directory and do:
dir('*.xls')
1 commentaire
Kalpesh Nayak
le 25 Nov 2016
Hi Jiro Doke,
Can you please tell how to change this properties of existing document. and save it.
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!