generating files using loop or other functions

1 次查看（过去 30 天）

Abdulkarim Almukdad 2020-10-26

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/627023-generating-files-using-loop-or-other-functions

评论： Sudhakar Shinde 2020-10-27

I have the attached data and I want to create an excel sheet with name Test1 that includes the 1st column with the 2nd column, then to create another files with name Test2 that includes the 1st column with the 3rd column and so on assuming I have many columns. Thanks in advance.

2 个评论
显示无隐藏无

Stephen23 2020-10-27

编辑：Stephen23 2020-10-27

To future readers: the accepted answer uses inefficient, complex code to access the table variables.

Do NOT follow this bad code example!

My comment below the answer shows the simpler, neater, less buggy, easier to debug, and much more efficient approach (i.e. the one given in the MATLAB documentation). Do NOT learn bad ways of writing MATLAB code.

Sudhakar Shinde 2020-10-27

@Stephen, Thanks for your comment.

请先登录，再进行评论。

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

采纳的回答

Sudhakar Shinde 2020-10-27

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/627023-generating-files-using-loop-or-other-functions#answer_525313

在 MATLAB Online 中打开

Use readtable and writetable functions.

Data=readtable('x1)Data.xlsx'); % Read excel data
[R,C]=size(Data); % get number of columns 
VariableNames = Data.Properties.VariableNames; % Name of each column heading
for i=2:C
Out.Nu = eval(['Data.',VariableNames{1}]); % 1st column
Out.Var = eval(['Data.',VariableNames{i}]) ; 
Table = table(Out.Nu,Out.Var);
writetable(Table,['Test' num2str(i-1),'.xlsx']); %%write into excel exmaple: Test1.xlsx 
end