matlab记录数据到excel

函数功能：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

效果