How to Split excel file using matlab

Question

Jerry Paul 2017-1-26

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/322033-how-to-split-excel-file-using-matlab

评论： 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

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

dbmn 2017-1-26

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/322033-how-to-split-excel-file-using-matlab#answer_252129

在 MATLAB Online 中打开

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 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

Answer 2

Jerry Paul 2017-1-27

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/322033-how-to-split-excel-file-using-matlab#answer_252184

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 个评论
显示 -1更早的评论隐藏 -1更早的评论

dbmn 2017-1-27

在 MATLAB Online 中打开

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);

请先登录，再进行评论。