xlsread error in 2018b

10 Ansichten (letzte 30 Tage)
진회 김
진회 김 am 8 Feb. 2023
Beantwortet: Jeremy Hughes am 9 Feb. 2023
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 Kommentare
Walter Roberson
Walter Roberson am 8 Feb. 2023
I suggest you use readtable()
Sulaymon Eshkabilov
Sulaymon Eshkabilov am 8 Feb. 2023
Or use readmatrix()

Melden Sie sich an, um zu kommentieren.

Antworten (2)

Rishav am 9 Feb. 2023
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 am 9 Feb. 2023
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.


Community Treasure Hunt

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

Start Hunting!

Translated by