MATLAB Answers

How to Split excel file using matlab

23 views (last 30 days)
Jerry Paul
Jerry Paul on 26 Jan 2017
Commented: 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.

Answers (2)

dbmn
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.


Jerry Paul
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
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.

Sign in to answer this question.


Translated by