xlswrite with formula in loop function
2 ビュー (過去 30 日間)
古いコメントを表示
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)
0 件のコメント
採用された回答
その他の回答 (1 件)
参考
カテゴリ
Help Center および File Exchange で Spreadsheets についてさらに検索
製品
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!