处理数据需要将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