How to read excel files in chunk?

3 次查看（过去 30 天）
Atik Faysal
Atik Faysal 2021-2-2
评论： dpb 2021-2-2
I do not want to load the whole excel file in the environment to save memory. I know in can be done with pandas in python. Any way to implement the same thing in matlab?
  2 个评论
Ive J
Ive J 2021-2-2
编辑：Ive J 2021-2-2
See datastore or similar.
ds = tabularTextDatastore(myBigdata, 'ReadSize', 100); % set desired line num
while hasdata(ds)
chunk = read(ds); % reads only 100 rows of original file
% do something
end
dpb
dpb 2021-2-2
tabularTextDatastore is not available for a spreadsheet; a spreadsheetDatastore is required. Could then partition it into n smaller pieces.
Or, one can simply use the 'Range' row numbers wanted with readtable or readmatrix if is numeric data; readcell it otherwise.

请先登录，再进行评论。

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

回答（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