How to copy each column to other file faster?

Question

adhi dermawan 2022-11-28

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1865193-how-to-copy-each-column-to-other-file-faster

评论： adhi dermawan 2022-11-29

Dear matlab expert, I have 2 excel data . The first one is the main data, the other one is the output file. I want to copy each column of the main data to the third column of the output file one by one with the header still on and save it as txt format for each copy. How can copy each column and make a multiple output file all at once?

2 个评论
显示无隐藏无

Jan 2022-11-28

编辑：Jan 2022-11-28

Why there are 4 Excel files attached?

What have you tried so far? Which names do you want for the output files? Are you able to import the Excel files already? Then please post the existing code.

What does "faster" mean - faster than what?

adhi dermawan 2022-11-28

在 MATLAB Online 中打开

Sorry sir, I already deleted those 2 files. I am able import the excel

clc;clear; close all;
format long g
filename1 = 'C:\ZTD\MainData.xlsx';
filename2 = 'C:\ZTD\Output.xlsx';
zw = readtable (filename2);
pwv = readmatrix(filename1);

I want to copy and paste the value in each column of the main data to the third column of the Output and save it as 01.txt,02.txt and so on with the same format as the output excel file. There are 1820 column in the Main Data so the result will be 1820 txt file.

请先登录，再进行评论。

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

Answer 1

Arif Hoq 2022-11-29

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1865193-how-to-copy-each-column-to-other-file-faster#answer_1114843

在 MATLAB Online 中打开

mainfile=readtable('MainData.xlsx');
outputfile=readtable('Output.xlsx');
C=cell(size(mainfile,2),1);
for i=1:size(mainfile,2)
    outputfile(:,3)=mainfile(:,i);
    result=[outputfile(:,[1 2]) outputfile(:,3) outputfile(:,4)];
    C{i,1}=table2cell(result);
end
mat=[C{:}];
% making text files
for j=1:4:size(mat,2)
col= mat(:,j:j+3);
writecell(col,[num2str(j) '.txt'])
end

3 个评论
显示 1更早的评论隐藏 1更早的评论

Arif Hoq 2022-11-29

在 MATLAB Online 中打开

try this:

mainfile=readtable('MainData.xlsx');
outputfile=readtable('Output.xlsx');
C=cell(size(mainfile,2),1);
for i=1:size(mainfile,2)
    outputfile(:,3)=mainfile(:,i);
    result=[outputfile(:,[1 2]) outputfile(:,3) outputfile(:,4)];
    C{i,1}=table2cell(result);
end
mat=[C{:}];
varname={'Lat','Lon','PWV','STA'};
repitvar=repmat(varname,1,size(mat,2)/4);
mat2=[repitvar;mat];
% making text files
for j=1:4:size(mat2,2)
col= mat2(:,j:j+3);
writecell(col,[num2str(j) '.txt'])
end