adding data to an existing excel file

4 views (last 30 days)
Elaheh
Elaheh on 19 Apr 2018
Answered: Walter Roberson on 19 Apr 2018

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

Answers (1)

Walter Roberson
Walter Roberson on 19 Apr 2018
Look in the File Exchange for xlsappend

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by