xlsread error in 2018b

2 次查看（过去 30 天）
진회 김
진회 김 2023-2-8
回答： Jeremy Hughes 2023-2-9
now im using 2018b in cloud server environment.
when i use xlsread, i get some error like
----------------------------------
Source: Microsoft Office Excel
Description: Open method of Workbooks class failed
Help File: C:\Program Files (x86)\Microsoft Office\Office12\1044\XLMAIN11.CHM
Help Context ID: 0
----------------------------------
however, when i use 2015version, the xlsread work well.
please give me answer.
thank yon

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

回答（2 个）

Rishav
Rishav 2023-2-9
You can use the ‘readtable’ alternative from MATLAB, which is designed to read text-based files, including .csv and .xlsx files. Here is a code snippet, that you can refer to use readtable() function.
filename = 'myfile.xlsx';
T = readtable(filename);
Jeremy Hughes
Jeremy Hughes 2023-2-9
xlsread uses an active Excel process on windows and has different behavior entirely on other platforms (or if excel isn't installed), this is one reason isn't not recommended, especially in cloud contexts where the platform may not always be the same. It could be that the cloud server environement is different (not sure if this is some MATLAB server or what...) but newer functions, like the already mentioned readtable and readmatrix, don't have the same limitation.

类别

在 Help Center 和 File Exchange 中查找有关 Startup and Shutdown 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by