i want to store 3 attributes in 3 columns of excel sheet and 10 times

1 次查看（过去 30 天）

显示更早的评论

amrin shaikh 2018-9-28

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/421220-i-want-to-store-3-attributes-in-3-columns-of-excel-sheet-and-10-times

关闭： MATLAB Answer Bot 2021-8-20

code is>>>> f1='13_1_1'; f2='13_1_2'; a=0;

i want to create excel sheet named sheet1 having 3 columns where in firts attribute value of f1, second attribute value of f2 and in 3rd attribute value of a should get stored and i want to repeat the writing process.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

此问题已关闭。

回答（1 个）

ANKUR KUMAR 2018-9-28

3
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/421220-i-want-to-store-3-attributes-in-3-columns-of-excel-sheet-and-10-times#answer_338875

在 MATLAB Online 中打开

f1='13_1_1'; 
 f2='13_1_2'; 
 a=0;
 A={f1,f2,a}
 xlswrite('sample.xlsx',A,'sheet1 ','A1')

You can easily put this in a loop. If not, let us know.

5 个评论
显示 3更早的评论隐藏 3更早的评论

amrin shaikh 2018-9-29

ANKUR KUMAR 2018-9-29

It will overwrite the data if you re-execute the program with different values, because writing process in excel always starts with cell A1. You have to give cell number as input, then pass the cell number argument at the time of writing in excel.

TIP: Don't write multiple times in excel, as it complicated because everytime you have to provide cell number. Make a cell matrix,completely, in matlab in the manner you wish to write in excel and then use xlswrite command.

此问题已关闭。