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

1 view (last 30 days)
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?
  1 Comment
Mathieu NOE
Mathieu NOE on 15 Nov 2021
so what do you get if you load the entire sheet ?
can't you do the needed data extraction from there ?

Sign in to comment.

Accepted Answer

Cris LaPierre
Cris LaPierre on 15 Nov 2021
Edited: Cris LaPierre on 15 Nov 2021
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');

More Answers (0)

Community Treasure Hunt

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

Start Hunting!

Translated by