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.

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.

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by