How to set names to each colunm and row using "writematrix"?

Dear Mathcoders,

I just wonder how to name the colunms and rows of table done by using writematrix, have not found a workaround for this yet:

B=flip([Irr_ SOC_ PV_Harvest_ Mean_consump ElecEnergy_cons PVenergy_ ...
    Power_Batt_ heating_c_ Cooling_c HDW_c EV_ Sp_ Power_Build_]);
 Labels=["Irr", "SOC", "PVHarvest", "Mecons", "ElecEne", "PVen", "PBatt", "heatc", "Coc", "HDc", "EV", "Sp", "PBuild"];
writematrix(B, Labels, 'Means.xls')

Answer 1

[Turlough Hughes]

You can use writetable for this as follows:

B = rand(100,13);
Labels=["Irr", "SOC", "PVHarvest", "Mecons", "ElecEne", "PVen", "PBatt", "heatc", "Coc", "HDc", "EV", "Sp", "PBuild"];
writetable(array2table(B, 'VariableNames', Labels), 'Means.xls')

[Tony Castillo]

Thank you Turlough, it worked properly.

Answer 2

[Walter Roberson]

You can first writecell the header and then writematrix with WriteMode append.

Or array2table using the labels as variable names and writetable()