How to read external file data from a .xls file into matlab
7 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
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 comentarios
Respuestas (2)
Jiro Doke
el 15 de Mzo. de 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 comentarios
Sisi Ma
el 15 de Mzo. de 2011
you mean the property of a xls file? try putting those xls files in your current directory and do:
dir('*.xls')
1 comentario
Kalpesh Nayak
el 25 de Nov. de 2016
Hi Jiro Doke,
Can you please tell how to change this properties of existing document. and save it.
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!