MATLAB Answers

0

How to Split excel file using matlab

Asked by Jerry Paul on 26 Jan 2017
Latest activity Commented on by dbmn
on 27 Jan 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

  0 Comments

Sign in to comment.

2 Answers

Answer by dbmn
on 26 Jan 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!

  0 Comments

Sign in to comment.


Answer by Jerry Paul on 27 Jan 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 Comment

dbmn
on 27 Jan 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);

Sign in to comment.