MATLAB: How to use xlswrite

xlswrite

Dear all

I made three loops using P1,P2 and P3, where these values appear in a Matrix A in the loops:

for i=15:imax
for j=20:jmax
for k=25:kmax
A= [ 1       i       100      
     10      j       14
     3       k       16];
b= function (i,j,k) %b can be calculated from a long process, but for each (i,j,k), we have a unique value of b 
end;
end; 
end;

My question is how I can have an excel file using xlswrite, displaying in each row in the same sheet the values of i, j, k and corresponding b. Thanks a lot

Best Answer

thanks a lot. This is what I was looking for.

It works. Great!

Related Solutions

MATLAB: How to return the values of a loop

You are computing k once for each value of i and overwriting it. If I understand what you want, try:

 i = 1:5;
 j = 0:5;
 k = zeros(numel(i),numel(j));
 for a = 1:numel(i)
     for b = 1:numel(j)
         k(a,b) = i(a)^2 + i(a)*j(b) + j(b)^2;
     end
 end
 display(k)

MATLAB: How to generate a 2D grid plot the data

You can use the PCOLOR function to plot a pseudocolor (checkerboard) plot. The plot is a logically rectangular, two-dimensional grid with vertices at the points [X(i,j), Y(i,j)] where, X and Y are vectors or matrices that specify the spacing of the grid lines. Increase the size of data (Z) and X, Y co-ordinates by one if you want the number of squares to be the size of the data.

%Generate the X and Y grid arrays using the MESHGRID function.
x = [1:6];
y = [1:4];
[X,Y] = meshgrid(x,y)
%Note that size(Z) is the same as size(x) and size(y)
Z = [1 0 -2 1 2 1;2 -2 0 -1 0 1;1 0 0 -2 2 1;1 1 1 1 1 1];
% create a colormap having RGB values of dark green,
%light green, white, dark red and light red.
map2 = [0 1 0; 0 0.8 0;1 1 1;0.6 0 0;1 0 0 ];
%use the user defined colormap for figure.
colormap(map2);
%plot the figure
pcolor(X,Y,Z);
%set the x and y labels
set(gca,'XTick',[1 2 3 4 5 6],'YTick',[1 2 3 4],'XTicklabel',[' ';'a';'b'; 'c'; 'd';'e'],'YTicklabel',[' ';'f';'g';'h']);
%set the color limits
caxis([-2 2])

Best Answer

Related Solutions

MATLAB: How to return the values of a loop

MATLAB: How to generate a 2D grid plot the data

Related Question