Reading large data from Excel into MATLAB

3 visualizaciones (últimos 30 días)
BenL
BenL el 13 de En. de 2017
Editada: BenL el 15 de En. de 2017
I have about 30 .xlsx sheets, with n X 5 columns of data. Each sheet has n = 400,000 rows of data (approx.). I am currently reading in the sheets, and using vertcat() to merge the data (i.e. 30n rows x 5 columns).
My script is something like this:
for k=1:numel(d);
data{k}=xlsread(fullfile(folder,d(k).name));
end
Is there a better and faster way to merge the data?

Respuestas (0)

Categorías

Más información sobre Data Import from MATLAB en Help Center y File Exchange.

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by