Changing WriteTable inputs for every loop and changing the "sheets" value for every loop

1 次查看（过去 30 天）
nathan stallworth
评论： nathan stallworth 2021-8-13
Hey there,
So two fold, one I am trying to change the input varible each iteration in a for loop and the number of sheets. I am wanting the filename to be my 7 seperate Atl files (Alt_300, Alt_400, Alt_500...ect). Then I am wanting the value of in "sheets" varible place to go from 1 to 7 (creating a total of 7 sheets once the program has run). Alterntively I could just not use eval and just overwrite "alt" varible each time but still raises the issue of the sheets varible. There is problem a straight forward way of doing all of this but I am at a loss.
Thank you!

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

回答（1 个）

Walter Roberson
Walter Roberson 2021-8-7
i_vals = 300:100:900;
for i_idx = 1 : length(i_vals)
i = i_vals(i_idx);
filename = sprintf('Alt_%d.xlsx', i);
ind = find(altitude >= i & altitude < i+100); %not <= !!
alt = table(those variables);
sheets = sprintf('Alt_%d', i);
writetable(alt, filename, 'sheet', sheets, 'Range', 'A1');
end

类别

在 Help Center 和 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