How can I open a generic EXCEL file ?

13 Ansichten (letzte 30 Tage)
Fernanda am 21 Jun. 2018
Kommentiert: Fernanda am 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.

Antworten (1)

Meade am 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 Kommentar
Fernanda am 22 Jun. 2018
you can see here the answer posted by OCDER:
Thank you anyway for your support!

Melden Sie sich an, um zu kommentieren.

Community Treasure Hunt

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

Start Hunting!

Translated by