清空筛选条件
清空筛选条件

for loop and xlswrite

1 次查看（过去 30 天）
Muhammad Usman
Muhammad Usman 2014-7-1
评论： Muhammad Usman 2014-7-1
Hi,i want to use xlswrite to write my data using for loop but the issue I am facing that if i have for loop with decimal interval then how can i write it to excel (discrete cells),e.g
for k=1:0.5:5
x=rand;
my_cell = sprintf( 'A%s',num2str(k) );
xlswrite('my_xls.xls',x,1,my_cell);
end
by using this i got error,please help me in writing such stuff. Thanks* |

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

采纳的回答

Sara
Sara 2014-7-1
K is not an integer so you can't use it to select the excel cell. Do this:
j = 0;
for k=1:0.5:5
j = j + 1;
x=rand;
my_cell = sprintf( 'A%s',num2str(j) );
xlswrite('my_xls.xls',x,1,my_cell);
end

更多回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by