how to change value of xlswrite array using one-item vector

2012 11 20
1 个回答
回答已采纳
9 次查看（30 天）

0 个投票

Hi everyone!
I was wondering if it is possible to have "flexible" array number using xlswrite in MATLAB?
This is what I have:
arrayNumber = ID+1;
xlswrite('output.xlsx', ID, 1, 'A1');
Instead of 'A1' I would like the 1 to be replaced by the vector 'arrayNumber'.
Is this possible?
Thanks! -Andrea

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

 采纳的回答

Matt Fig
Matt Fig 2012-11-20
编辑：Matt Fig 2012-11-20

0 个投票

Here is an example of how to manipulate strings in a loop...
Str = 'A';
for ii = 1:5
disp(sprintf('A%i',ii))
end
So use:
% xlswrite('output.xlsx', ID, 1, sprintf('A%i',arrayNumber));

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Cell Arrays 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by