函数功能:excel名称与开始记录的时间相关;
最多支持26*26列数据记录;
在表格后面增加新数据。
测试程序
%写数据到excel表格
filename = ['./data/udp_truestates-',datestr(now,30),'.xls'];
v = [1 2 3];
p = [4 5 6];
headers = {'v[0]','v[1]','v[2]','p[0]','p[1]','p[2]'};
num_length = length(headers);% 定义表格的列数,表格的列数与headers的长度相同
xls_row = num2str(1);
xls_colume_start = 'A'; %初始列。'A'表示从表格的第一列开始写起
%计算最后一列。Excel列的命名方式是:A-Z,BA-BZ,...,ZA,-ZZ
%所以这里最多支持26*26列
if rem(num_length,26) == 0
xls_colume_end = char('A' + mod(num_length,26) - 1);
else
colume_26 = rem(num_length,26);
xls_colume_first = char('A' + colume_26);
xls_colume_second = char('A' + mod(num_length,26) - 1);
xls_colume_end = [xls_colume_first, xls_colume_second];
end
start_point= [xls_colume_start, xls_row];
end_point = [xls_colume_end, xls_row];
xlRange = [start_point,':',end_point];
data = headers;
if length(data) < num_length
data = [data,zeros(1, num_length - length(data))];
end
xlswrite(filename, data,xlRange);
for i = 1:10
xls_row = num2str(i+1); %更新行
data = ones(1,5)*i;
my_xlswrite(filename, xls_row, xls_colume_start, xls_colume_end, data, num_length)
end
function my_xlswrite(filename, xls_row, xls_colume_start, xls_colume_end, data, norm_length)
start_point= [xls_colume_start, xls_row];
end_point = [xls_colume_end, xls_row];
xlRange = [start_point,':',end_point]; %更新写入excel中的范围
if length(data) < norm_length %给定的数据少于表格的列数,少的数据用0补齐
data = [data,zeros(1, norm_length - length(data))];
end
xlswrite(filename, data, xlRange);
end
效果