Can't open a range of a .csv excel file in Matlab online version

I am using Matlab online version. It seems though that I can use the "xlsread" function to open a range of .csv excel file.

M = xlsread('ratings.csv','A2:C100837');

Error: Warning: Range cannot be used in 'basic' mode. The entire sheet will be loaded.

How can I solve this please?

[Mathieu NOE]

hello

so what do you get if you load the entire sheet ?

can't you do the needed data extraction from there ?

Answer 1

[Cris LaPierre]

Basic mode means you are using xlsread without having access to Excel. That is the case with MATLAB Online, and is mentioned in the documentation:

" If your computer does not have Excel for Windows® or if you are using MATLAB® Online™, xlsread automatically operates in basic import mode".

"Range selection is not supported when reading XLS files in basic mode."

You can read more about basic mode here.

The soluion is to use one of the functions recommended at the top of the xlsread documentation page: readtable, readmatrix or readcell. If your data is all of the same data type, I would use readmatrix. Try this.

M = readmatrix("ratings.csv","Range",'A2:C100837');

[Cyprien Nshimiyimana]

Yes this works. Thank you very much!