How adding multiples values insiade Excel file ?

Question

Furat Alobaidy 2020-2-8

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/504373-how-adding-multiples-values-insiade-excel-file

回答： Furat Alobaidy 2020-2-8

hi , i have multi excel files contains multiple values, i need adding the values for each variable which is repeated much time inside the Excel file as in the code below, Please

the variable: sim_ticks have multi vales inside the Excel file , i need adding all these values together !

 xlfiles = dir('*.xlsx'); % You are in the folder of xl files
      Nfiles = length(xlfiles) ;  % number of xl files
        % loop for each file 
    for i = 1:Nfiles
      fname = xlfiles(i).name ;   % file name
             [~,~,dat] = xlsread(fname) ;   % read the file 
             p= strcmp(dat(:,1),'sim_ticks') ;           %# 1- Find the value of  sim_ticks 
        
             
             simtickx(i) = sum( cell2mat(dat(p,2));   % this summing values gave me error !!!
    
        ca{i, 1} = simtickx(i); 
      end
    col_header={'Total Ticks'};     %Row cell array (for column labels)
     
       xlswrite('SRAMBLACkholes.xlsx',col_header,'Sheet1','A1');     %Write column header
            
      cellReference = sprintf('A2');
     xlswrite('SRAMBLACkholes.xlsx', ca, 'Sheet1', cellReference); % Write out ca, not data.
     