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

export data of a loop in different excel files

4 次查看（过去 30 天）
Homayoon
Homayoon 2015-8-27
评论： Sham Babu 2017-12-26
Hello all-- Well it seems i face with a new problem. :-(
How can I export the data corresponding to each filenumber in my code to a different excel file?
for k = 1:10
filename = sprintf('%d.txt',k);
A = load(filename);
% doing some calculations
import output as k.xlsx
end
Well my desired outputs are 10 excel files whose names are 1.xlsx,2.xlsx and etc. Thank you so much

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

采纳的回答

Stephen23
Stephen23 2015-8-27
编辑：Stephen23 2015-8-27
Try reading the documentation for xlswrite, and thinking about how you could adapt the code that I gave you earlier:
for k = 1:10
...
newfilename = sprintf('%d.xls',k);
xlswrite(newfilename,output)
end
Note that there are many options for xlswrite, so please read the documentation carefully.
  2 个评论
Homayoon
Homayoon 2015-8-31
Dear Stephen,
I got it right just after posted the question. That is why i have not checked your answer until now. Anyway I do appreciate your concern to teach online users.

请先登录，再进行评论。

更多回答（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