Open an xls file

Hi everyone,

I'm trying to open an excel file with actxserver function in Matlab R2019a.

The command line written are:

A = actxserver('Excel.Application');

B= A.workbooks.Open(strFilePath);

We are able to read the Excel file only in some PC, not in all.

The Open function is suggested by Matlab, but it doesn't work. What could be the problem?

[Ive J]

Just out of pure curiosity, why don't you use readtable?

Answer 1

[Shashank Arya]

Hi, 

From my understanding, you want to open an excel file using the actxserver function, which works in specific machines but not all.

I am assuming, this does not works for you in PC, but not in MAC.

MATLAB does not support COM functions on MAC since COM is Microsoft technology, and available only on Windows.

An easier alternative for you would be to use ”readtable” function available in MATLAB, which creates a table by reading column-oriented data from a file.

Refer to the below link to access readtable documentation

https://www.mathworks.com/help/matlab/ref/readtable.html

Thanks and Regards,

Shashank Arya