Can't open a range of a .csv excel file in Matlab online version
4 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Cyprien Nshimiyimana
el 15 de Nov. de 2021
Comentada: Cyprien Nshimiyimana
el 15 de Nov. de 2021
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 comentario
Mathieu NOE
el 15 de Nov. de 2021
hello
so what do you get if you load the entire sheet ?
can't you do the needed data extraction from there ?
Respuesta aceptada
Cris LaPierre
el 15 de Nov. de 2021
Editada: Cris LaPierre
el 15 de Nov. de 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."
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');
Más respuestas (0)
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!