How adding multiples values insiade Excel file ?
4 次查看(过去 30 天)
显示 更早的评论
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 个评论
采纳的回答
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!