1、将matlab里生成的变量导入到excel中
xlswrite('具体路径\data.xlsx',AG_set,1,'B1:k1')
%xlswrite('表格路径',变量名称,sheet1,'数据显示的范围')
2、为生成的表格指定行列标题
xlswrite('E:\data.xlsx',{'AG_set'},'A1:A1')
%xlswrite('表格路径',{'行标题'},'A1:A1')可在A1表格生成第一个行标题
%xlswrite('表格路径',{'行标题'},'A2:A2')可在A2表格生成第二个行标题
列标题同理。
图示效果如下:
变量1
变量2
变量3
变量4
变量5
变量6
变量7
变量8
变量9
变量10
变量11
具体生成的表格如下:
此表的部分设置代码如下:
xlswrite('E:\Matlab\compare\data.xlsx',AG_set,1,'B1:k1')%将变量按行导入表格指定位置
xlswrite('E:\Matlab\compare\data.xlsx',CC_set,1,'B2:k2')
xlswrite('E:\Matlab\compare\data.xlsx',EN_set,1,'B3:k3')
xlswrite('E:\Matlab\compare\data.xlsx',MI_set,1,'B4:k4')
xlswrite('E:\Matlab\compare\data.xlsx',MSE_set,1,'B5:k5')
xlswrite('E:\Matlab\compare\data.xlsx',PSNR_set,1,'B6:k6')
xlswrite('E:\Matlab\compare\data.xlsx',Qabf_set,1,'B7:k7')
xlswrite('E:\Matlab\compare\data.xlsx',SCD_set,1,'B8:k8')
xlswrite('E:\Matlab\compare\data.xlsx',SD_set,1,'B9:k9')
xlswrite('E:\Matlab\compare\data.xlsx',SF_set,1,'B10:k10')
xlswrite('E:\Matlab\compare\data.xlsx',VIF_set,1,'B11:k11')
xlswrite('E:\Matlab\compare\data.xlsx',{'AG_set'},'A1:A1')%对表格数据写入标题在指定位置
xlswrite('E:\Matlab\compare\data.xlsx',{'CC_set'},'A2:A2')
xlswrite('E:\Matlab\compare\data.xlsx',{'EN_set'},'A3:A3')
xlswrite('E:\Matlab\compare\data.xlsx',{'MI_set'},'A4:A4')
xlswrite('E:\Matlab\compare\data.xlsx',{'MSE_set'},'A5:A5')
xlswrite('E:\Matlab\compare\data.xlsx',{'PSNR_set'},'A6:A6')
xlswrite('E:\Matlab\compare\data.xlsx',{'Qabf_set'},'A7:A7')
xlswrite('E:\Matlab\compare\data.xlsx',{'SCD_set'},'A8:A8')
xlswrite('E:\Matlab\compare\data.xlsx',{'SD_set'},'A9:A9')
xlswrite('E:\Matlab\compare\data.xlsx',{'SF_set'},'A10:A10')
xlswrite('E:\Matlab\compare\data.xlsx',{'VIF_set'},'A11:A11')