How adding multiples values insiade Excel file ?
4 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Furat Alobaidy
am 8 Feb. 2020
Beantwortet: Furat Alobaidy
am 8 Feb. 2020
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.
Error: File: test1.m Line: 11 Column: 51
Invalid expression. When calling a function or indexing a variable, use parentheses. Otherwise, check for mismatched
delimiters.
0 Kommentare
Akzeptierte Antwort
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!