Import large CSV file

4 次查看（过去 30 天）
SM
SM 2021-1-18
回答： SM 2021-1-19
Hello
I have a CSV file that has 239615 rows and 24 columns with 85 Mb size.
the first row is headers and the rest of it are numbers.
I tried the following methods:
1-readmatrix
2-readtable
3-Matlab import
all of them only read up to 238491 and ignored rest of it.
Does anyone have any idea how to read the whole file?
Cheers
  4 个评论
显示 2更早的评论
Ive J
Ive J 2021-1-18
编辑：Ive J 2021-1-18
Unless you have some specific issues with your machine, your file is not even close to being large. Manually inspect your file (Notepad++ for instance) or just read it entirely by fileread and splitlines to see what's really going on with your file.
Walter Roberson
Walter Roberson 2021-1-18
xls files have a maximum of 65535 rows, but cvs files should not have that limitation.
As an experiment, try readmatrix with the 'Encoding', 'UTF-8' option.

请先登录，再进行评论。

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

回答（1 个）

SM
SM 2021-1-19
Thank you everyone
It seems there was a malfunction in microsoft excel.
It resolved spontaneously.

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by