How can I open a generic EXCEL file ?
1 回表示 (過去 30 日間)
古いコメントを表示
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 件のコメント
回答 (1 件)
Meade
2018 年 6 月 22 日
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);
参考
カテゴリ
Help Center および File Exchange で Spreadsheets についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!