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

52 次查看（过去 30 天）
Tony Castillo
Tony Castillo 2022-2-9
评论： Tony Castillo 2022-2-9
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')

请先登录，再回答此问题。

采纳的回答

Turlough Hughes
Turlough Hughes 2022-2-9
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')

更多回答（1 个）

Walter Roberson
Walter Roberson 2022-2-9
You can first writecell the header and then writematrix with WriteMode append.
Or array2table using the labels as variable names and writetable()

类别

在 Help Center 和 File Exchange 中查找有关 File Operations 的更多信息

标签

产品


版本

R2021a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by