adding data to an existing excel file
4 次查看(过去 30 天)
显示 更早的评论
Hi,
I have the following script. I want to write the "data" from 36 folders to be written in one excel file, one at a time. For example, the first piece of data be written in columns A,B, and C. The second piece of data be written in columns D, E, and F, etc. How should I change the script? I thank you in advance.
clc, clear, close all;
STIMroot='C:\Users\';
Drop=strcat('C:\Users\final.xls'); for i=1:36
for j=1:2
for h=1:29
STIMfile=strcat(STIMroot,num2str(i),'\',num2str(i),'_',num2str(j),'_',num2str(h),'.xls'); if exist(STIMfile,'file')
STIMdata = xlsread(STIMfile);
data=STIMdata(:,3:5); m=1;
[rows,cols] = size(data);
startingcolumn = (m-1)*cols + 1;
colsstring = num2str(startingcolumn);
m=m+1;
xlswrite(Drop,data,1,colsstring); end
end
end
end
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!