Excel 将一列数据分成多列

处理数据需要将Excel中的一列数据重新排列成若干列，发现直接用excel操作比较复杂，于是用MATLAB实现，顺便复习MATLAB读取excel数据。程序中仅需要参数clm确定需要分成多少列即可。

clc;
clear all;
filename = 'input.xlsx';
readin = xlsread(filename);
clm = 2; % seperate how many columns
t = 1;
size_data = size(readin);
a = size_data(1);

for i = 1:clm:a
     if(i+clm-1 <= a)
    writein = readin(i:i+clm-1);
     else
    writein = readin(i:a);
      end
  str_xls=['A', int2str(t)];
  filename = 'out.xlsx';
  sheet = 1;
  xlRange = str_xls;
  xlswrite(filename, writein', sheet, xlRange);
  t = t+1;
end