Error opening Excel file in Matlab using actxserver

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

Answer 1

[Cris LaPierre]

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

[Sidhhant Nayak]

Indeed, it works now.

Thanks.

Best regards,

Sidhhant