MATLAB Answers

How can I open a generic EXCEL file ?

1 view (last 30 days)
Fernanda
Fernanda on 21 Jun 2018
Commented: Fernanda on 22 Jun 2018
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.

  0 Comments

Sign in to comment.

Answers (1)

Meade
Meade on 22 Jun 2018
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);

  1 Comment

Fernanda
Fernanda on 22 Jun 2018
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!

Sign in to comment.

Sign in to answer this question.