How to Split excel file using matlab

7 次查看(过去 30 天)
Jerry Paul
Jerry Paul 2017-1-26
评论: dbmn 2017-1-27
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

回答(2 个)

dbmn
dbmn 2017-1-26
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 2017-1-27
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 个评论
dbmn
dbmn 2017-1-27
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);

请先登录,再进行评论。

Community Treasure Hunt

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

Start Hunting!

Translated by