Effacer les filtres
Effacer les filtres

Sum values for a spreedsheet of excel

2 vues (au cours des 30 derniers jours)
Tony Castillo
Tony Castillo le 23 Sep 2016
Commenté : Tony Castillo le 4 Oct 2016
Hello, i want to do this:
  1. load a excel spreedsheet
  2. read that excel spreedsheet
  3. set a stepsize of 4 numbers
  4. sum from 4 by 4 the elements of the column vector
  5. generate a new column vector only with the the new values (for instance if at the begining i had 8 values now i should has only 2 values)
this was the code that i did for it,
k = 1;
stepsize = 4;
xlsread('DatosCM.xlsx', 1, 'c2:c10');
for nn = 2:stepsize:10-stepsize
partsum(k) = sum(vekt(nn:nn+stepsize-1));
k = k+1;
end
that code send me this error Index exceeds matrix dimensions.
Error in consumo2 (line 7) partsum(k) = sum(vekt(nn:nn+stepsize-1));
  1 commentaire
Adam
Adam le 23 Sep 2016
Surely you need to assign the output of xlsread to a variable?

Connectez-vous pour commenter.

Réponse acceptée

Image Analyst
Image Analyst le 24 Sep 2016
Try
vekt = xlsread(............
  1 commentaire
Tony Castillo
Tony Castillo le 4 Oct 2016
Thanks so much, is correct your solution.

Connectez-vous pour commenter.

Plus de réponses (0)

Catégories

En savoir plus sur Data Import from MATLAB dans Help Center et File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by