How to read external file data from a .xls file into matlab
7 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
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 Commenti
Risposte (2)
Jiro Doke
il 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 Commenti
Sisi Ma
il 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 Commento
Kalpesh Nayak
il 25 Nov 2016
Hi Jiro Doke,
Can you please tell how to change this properties of existing document. and save it.
Vedere anche
Categorie
Scopri di più su Spreadsheets in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!