How adding multiples values insiade Excel file ?

조회 수: 1 (최근 30일)
Furat Alobaidy
Furat Alobaidy 2020년 2월 8일
답변: 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.
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.

채택된 답변

Furat Alobaidy
Furat Alobaidy 2020년 2월 8일
thanks a lot for your help.

추가 답변 (1개)

BN
BN 2020년 2월 8일
편집: BN 2020년 2월 8일
Hello
Look at this line of your code:
simtickx(i) = sum( cell2mat(dat(p,2)); % one ) is missed
You don't close a parenthesis ), so :
simtickx(i) = sum( cell2mat(dat(p,2))); % fixed
Further than this, I recommend you to use writetable instead of xlswrite.

카테고리

Help CenterFile Exchange에서 Spreadsheets에 대해 자세히 알아보기

태그

제품


릴리스

R2019b

Community Treasure Hunt

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

Start Hunting!

Translated by