MATLAB: How to write data on excel.

excel data

I have this part of code

i1 = 23;
i2 = 67;
alpha1 = 1.51;
m11 = 1.34;
d1 = 2.44;
j = 0;
for i = i1:i2
    j = j + 1;
    v(i) = (y(i)- y(i-1))/(t(i)-t(i-1));
    force(j)= d1*(v(i))^alpha1;
end
fr_max = max (force)
fr_min = min (force) 
fr_mean = mean(force)
fr_std = std(force)
%xlswrite('force_data.xls',fr_max, fr_min, fr_mean, fr_std);

how can i use xlswrite to write fr_max, fr_min, fr_min, fr_std in E3, F3, G3, H3.

Best Answer

xlswrite('force_data.xls',[fr_max, fr_min, fr_mean, fr_std])

Related Solutions

MATLAB: The exact same command (xlswrite) work with some varible but not others of the same kind

Character arrays have to be rectangular. So you can't do this ['123', '12345678']. If your texts are different sizes, then you need a cell array. You need a cell array anyway, otherwise xlswrite will put one only character into each Excel cell, instead of putting the whole string into a single cell. So try this:

ca = {min1; min2; min3; min4; min5; min6; min7; min8; min9; min10};
xlswrite('min.xls', ca);

MATLAB: Working with a three dimensional matrix

The problem is how you construct kunn, in general there are so many nested loops that my suspect is you end up overwriting the data, go in debug mode and see what happens each time you increase the frist loop and so on:

function[F0mean,F0max,F0min,F0max_min,F0std,F0median,relF0VR,relF0SD,...
         Emean,Emax,Emin,Emax_min,Estd,Emedian,TEO,Jmean,...
         Jmax,Jmin,Jmax_min,Jstd,Jmedian,Smean,Smax,Smin,...
         Smax_min,Sstd,Smedian,F1mean,F1max,F1min,F1max_min,F1std,...
         F1median,F2mean,F2max,F2min,F2max_min,F2std,F2median]...
         = HRA()
[wav,lab]=databaze;
wav = wav';
lab = lab';
L = length(wav);
for j = 2:L+1
    brd = process_lab_file(lab{j-1});
    label = brd(:,1);
    K = length(label);
    for i = 1:K
        [F0mean,F0max,F0min,F0max_min,F0std,F0median,relF0VR,relF0SD,...
         Emean,Emax, Emin,Emax_min, Estd, Emedian, TEO,...
         Jmean,Jmax,Jmin,Jmax_min,Jstd,Jmedian,...
         Smean,Smax,Smin,Smax_min,Sstd,Smedian,...
         F1mean,F1max,F1min,F1max_min,F1std,F1median,...
         F2mean,F2max,F2min,F2max_min,F2std,F2median]=extr_part_of_sig(wav{j-1},label(i),lab{j-1});
          priznaky =...
              [F0mean,F0max,F0min,F0max_min,F0std,F0median,relF0VR,relF0SD,...
               Emean,Emax, Emin,Emax_min, Estd, Emedian, TEO,...
               Jmean,Jmax,Jmin,Jmax_min,Jstd,Jmedian,...
               Smean,Smax,Smin,Smax_min,Sstd,Smedian,...
               F1mean,F1max,F1min,F1max_min,F1std,F1median,...
               F2mean,F2max,F2min,F2max_min,F2std,F2median];
          O = length(priznaky);
          for o = 1:O
              zap(o,i) = priznaky(o);
          end
      end
      F = length(priznaky);
      for i = 1:K
          for a = 1:F
              kunn(a,j-1,i) = zap(a); 
          end
      end
  end
S = length(label);
jaj = zeros(39,17);
for f = 1:S
    jaj = kunn(:,:,2); 
    koj = jaj';
    %xlswrite('ZK.xls', koj, label{i}, 'B2');
end

Best Answer

Related Solutions

MATLAB: The exact same command (xlswrite) work with some varible but not others of the same kind

MATLAB: Working with a three dimensional matrix

Related Question