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
end
dpb
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)

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by