xlswrite with formula in loop function

JB
2017 10 19
2 个回答
回答已采纳
更新时间：2017 10 19
2 次查看（30 天）

0 个投票

I have a large cell (2500,3) array which I want to export as a .xls file, but I want to include a formula ('=SUM(B1:C1)') which can be used in excel, The code below is working fine but I want the "B1" and "C1" to increase by 1 for each loop ('=SUM(B1:C1)', '=SUM(B2:C2)', '=SUM(B2:C2)' etc). How can I do this??? My present loop code is:
for II = 1:length(out)
out{II,4}='=SUM(B1:C1)';
end
xlswrite('Book1.xls',out)

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

 采纳的回答

Walter Roberson
Walter Roberson 2017-10-19

0 个投票

out{II,4} = sprintf('=SUM(B%d:C%d)', II, II);

更多回答（1 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Loops and Conditional Statements 的更多信息

产品

标签

Community Treasure Hunt

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

Start Hunting!

Translated by