How can I open a generic EXCEL file ?

Hi,

the procedure to access a spreadsheet data from MATLAB running an Excel application in an Automation server is well known and explained at the matlab Documentation. As an example, something like this is seen:

exl = actxserver('excel.application');

exlWkbk = exl.Workbooks;

exlFile = exlWkbk.Open([docroot '/techdoc/matlab_external/examples/input_resp_data.xls']);

I need to open a generic file from Excel (something you wold do otherwise at the Command Window through winopen(cd) ). I would like to have the possibility to chose the file and don't let it fix.

Thank you.

Answer 1

[Meade]

Hope this helps.

Best, Meade

exl = actxserver('excel.application');
% Open a new workbook
exlWkbk = exl.workbooks.Add;

% To save (if you choose)
exlWkbk.SaveAs(filename);

[Fernanda]

Hello,

you can see here the answer posted by OCDER: https://de.mathworks.com/matlabcentral/answers/406812-how-can-i-open-a-generic-not-defined-excel-file?s_tid=mlc_ans_email_view

Thank you anyway for your support!