How can I open a generic EXCEL file ?

Question

Fernanda 2018-6-21

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/406810-how-can-i-open-a-generic-excel-file

评论： Fernanda 2018-6-22

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 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Meade 2018-6-22

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/406810-how-can-i-open-a-generic-excel-file#answer_325828

在 MATLAB Online 中打开

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 个评论
显示 -1更早的评论隐藏 -1更早的评论

Fernanda 2018-6-22

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!

请先登录，再进行评论。