Importing large .csv files into MATLAb but confined by limits of excel

5 次查看（过去 30 天）
Patrick Lydon
Patrick Lydon 2017-7-25
评论： Katrina Anderson 2019-1-7
So I am using an Arduino to collect many values over a long period of time. I am storing these values in a CSV file. Excel does not let you exceed 1048576 rows in one file. However, that is only 8 minutes worth of data for me and I want to collect about 24 hours of data. Now I thought, I will just open the file straight in matlab, surely matlab doesnt have a restriction such as this one. To my dismay, when I open up my file in MATLAB it only shows me 1048576 rows, just like excel. So does matlab have a restriction? When I open the disk the .csv file is written on, there is a small excel icon next to it (by default I am supposing). Does this mean when I import it into Matlab, it is importing it not only as a .csv file but also as an excel file, and the restrictions of excel are imposed upon it? I am using uigetfile to open it up. Thank you

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

采纳的回答

Titus Edelhofer
Titus Edelhofer 2017-7-25
Hi Patrick,
the importer you mention will use xlsread in the background and yes, would be limited by the same limit.
But: nobody stops you from reading the file directly, the easiest will be to use a datastore:
doc datastore
Hope this helps,
Titus
  4 个评论
显示 2更早的评论
Walter Roberson
Walter Roberson 2017-7-25
If you use the 'basic' option of xlsread then it will not use excel. Also readtable will not use excel
Katrina Anderson
Katrina Anderson 2019-1-7
Hi,
I am having the same issue. However, I am uploading data from an IMU device and I think it is uploaded on to the computer as a .csv
Is there anyway I can get around that?
Thanks
Katrina

请先登录，再进行评论。

更多回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by