Why am I unable to open .csv file with the readmatrix function?
19 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Poulomi
el 10 de Jun. de 2022
Comentada: Poulomi
el 13 de Jun. de 2022
The file I am trying to import in matlab is CSV (comma delimited).
So each cell in the excel file is like:
0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 3.000
So 11 values with space in between.
Initially using matlab 2020a, readmatrix could read each value separately and could import it without any issues as a 1 x 11 double.
But now I am not able to anymore. It would just read it as 1x1 double with the value as NaN.
Any suggestions as to how I can read my excel file now?
10 comentarios
Stephen23
el 12 de Jun. de 2022
@Poulomi: I used https://notepad-plus-plus.org/downloads/, but every text editor on the planet has find-and-replace functionality.
Respuesta aceptada
Mathieu NOE
el 10 de Jun. de 2022
hello
workaround suggestions
faster with readcell vs importdata
>> tic;
out2 = str2double(split(readcell('t4md6p1 - partial file.csv')));
toc
Elapsed time is 10.480521 seconds.
>> tic;
out2 = str2double(split(importdata('t4md6p1 - partial file.csv')));
toc
Elapsed time is 34.013224 seconds.
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!