Error opening Excel file in Matlab using actxserver
30 views (last 30 days)
Show older comments
Sidhhant Nayak
on 5 Sep 2019
Commented: 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
Accepted Answer
Cris LaPierre
on 5 Sep 2019
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);
More Answers (0)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!