Borrar filtros
Borrar filtros

How to read excel files in chunk?

4 visualizaciones (últimos 30 días)
Atik Faysal
Atik Faysal el 2 de Feb. de 2021
Comentada: dpb el 2 de Feb. de 2021
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 comentarios
Ive J
Ive J el 2 de Feb. de 2021
Editada: Ive J el 2 de Feb. de 2021
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
dpb el 2 de Feb. de 2021
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.

Iniciar sesión para comentar.

Respuestas (0)


Community Treasure Hunt

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

Start Hunting!

Translated by