Why am I unable to open .csv file with the readmatrix function?

12 次查看（过去 30 天）

显示更早的评论

Poulomi 2022-6-10

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1737640-why-am-i-unable-to-open-csv-file-with-the-readmatrix-function

评论： Poulomi 2022-6-13

采纳的回答： Mathieu NOE

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 个评论
显示 8更早的评论隐藏 8更早的评论

Stephen23 2022-6-12

@Poulomi: I used https://notepad-plus-plus.org/downloads/, but every text editor on the planet has find-and-replace functionality.

Poulomi 2022-6-13

@Stephen23 thank you!! find and replace function at notepad++ solved my problem... matlab can read the csv file now.

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Mathieu NOE 2022-6-10

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1737640-why-am-i-unable-to-open-csv-file-with-the-readmatrix-function#answer_982855

在 MATLAB Online 中打开

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.

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Poulomi 2022-6-13

Thank you! This works!

请先登录，再进行评论。

类别

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Spreadsheets

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

产品

MATLAB

版本

R2020a

Community Treasure Hunt

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

Start Hunting!

Translated by