Open an xls file

2 次查看（过去 30 天）
Maria Grazia Di Giorgio
回答： Shashank Arya 2020-12-17
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?
  1 个评论
Ive J
Ive J 2020-12-15
Just out of pure curiosity, why don't you use readtable?

请先登录，再进行评论。

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

回答（1 个）

Shashank Arya
Shashank Arya 2020-12-17
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

类别

在 Help Center 和 File Exchange 中查找有关 Use COM Objects in MATLAB 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by