xlsread error in 2018b

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

[Walter Roberson]

I suggest you use readtable()

[Sulaymon Eshkabilov]

Or use readmatrix()

Answer 1

[Rishav]

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);

Answer 2

[Jeremy Hughes]

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.