Effacer les filtres
Effacer les filtres

Reading large data from Excel into MATLAB

2 vues (au cours des 30 derniers jours)
BenL
BenL le 13 Jan 2017
Modifié(e) : BenL le 15 Jan 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?

Réponses (0)

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by