Borrar filtros
Borrar filtros

xlsread error in 2018b

5 visualizaciones (últimos 30 días)
진회 김
진회 김 el 8 de Feb. de 2023
Respondida: Jeremy Hughes el 9 de Feb. de 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 comentarios
Walter Roberson
Walter Roberson el 8 de Feb. de 2023
I suggest you use readtable()
Sulaymon Eshkabilov
Sulaymon Eshkabilov el 8 de Feb. de 2023
Or use readmatrix()

Iniciar sesión para comentar.

Respuestas (2)

Rishav el 9 de Feb. de 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 el 9 de Feb. de 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