MATLAB Answers

0

Error opening Excel file in Matlab using actxserver

Asked by Sidhhant Nayak on 5 Sep 2019
Latest activity Commented on by Sidhhant Nayak on 5 Sep 2019
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

  0 Comments

Sign in to comment.

Products


Release

R2015b

1 Answer

Answer by Cris LaPierre
on 5 Sep 2019
 Accepted Answer

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);

  1 Comment

Indeed, it works now.
Thanks.
Best regards,
Sidhhant

Sign in to comment.