Error opening Excel file in Matlab using actxserver

25 次查看（过去 30 天）
Sidhhant Nayak
Sidhhant Nayak 2019-9-5
评论： Sidhhant Nayak 2019-9-5
Hello all,
I am trying to edit and excel file by opening it via the 'actxserver' functionality. However, an error always throws up as soon as I run the following command:
excel = actxserver('Excel.application')
workbook = excel.Workbooks.Open('EA988_15Fe_Gen4v1_#14mix_200ml_105411.6_Cooldown_2.xlsx');
Error using
Interface.000208DB_0000_0000_C000_000000000046/Open
That is all what I get from Matlab. I have referred to multiple threads regarding this issue but none of them have been helpful. Can someone help me with resolving this issue?
Thanks in advance.
Best regards,
Sidhhant

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

采纳的回答

Cris LaPierre
Cris LaPierre 2019-9-5
I think you need to include the entire path in the filename.
file = 'C:\user\me\Documents\example.xls';
excel = actxserver('Excel.Application');
workbook = excel.Workbooks.Open(file)
...
delete(excel);

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品


版本

R2015b

Community Treasure Hunt

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

Start Hunting!

Translated by