How to Split excel file using matlab

12 visualizaciones (últimos 30 días)
Jerry Paul
Jerry Paul el 26 de En. de 2017
Comentada: dbmn el 27 de En. de 2017
Hello,
I have a 62000 row excel file that I want to split to 61 files. Can I do this with MatLAB. The content is a single column with numbers (like .605785). Kindly help.
Thanks

Respuestas (2)

dbmn
dbmn el 26 de En. de 2017
Hi,
you should be able to build something like that, using the following commands.
1. reading your data
your_data= xlsread(filename);
2. split your array
len = ceil(numel(your_data)/num_files);
for k=1:num_files
tmp = your_data([1:len]+len*k);
end
alternatively use reshape in this step
3. saving the excel (preferably in the loop)
xlswrite(filename,tmp)
maybe you want wo use csvread/csvwrite instead
this should get started!

Jerry Paul
Jerry Paul el 27 de En. de 2017
Thanks for your reply! I am new to MatLAB and now after executing the code its showing 'Index exceeds matrix dimensions.' Any help! Thank you
  1 comentario
dbmn
dbmn el 27 de En. de 2017
You are right. I was slightly sloppy on the indices (and didn't test my code). The last iteration is actually shorter (no 1017 elements but less)
% All the loops (but not the last one)
for k=0:num_files-2
tmp = your_data([1:len]+len*k);
end
% And now the last iteration (this one is only 981 elements long)
tmp = your_data(len*(num_files-1):end);

Iniciar sesión para comentar.

Community Treasure Hunt

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

Start Hunting!

Translated by