How to read external file data from a .xls file into matlab

Hi,

Can anyone tell me how to read external file data like author, date created, date modified etc.. from an excel file into matlab.

Answer 1

[Jiro Doke]

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();

Answer 2

[Sisi Ma]

you mean the property of a xls file? try putting those xls files in your current directory and do:

dir('*.xls')

[Kalpesh Nayak]

Hi Jiro Doke,

Can you please tell how to change this properties of existing document. and save it.