Clear Filters
Clear Filters

How can I open a generic EXCEL file ?

1 view (last 30 days)
Fernanda on 21 Jun 2018
Commented: Fernanda on 22 Jun 2018
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 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)
  1 Comment
Fernanda on 22 Jun 2018
you can see here the answer posted by OCDER:
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!