How can I do contour plot from set of data from .xlsx?

Question

Nanthanon Visitpongaree 2018-11-3

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/427767-how-can-i-do-contour-plot-from-set-of-data-from-xlsx

回答： Jacob Mathew 2025-1-3

Test11x11 z=0.xlsx

I get this code from this website http://linuxrajib.blogspot.com/2012/04/2d-contour-plot-in-matlab.html but I don't know how to do with it. I want to do contour plot like this in my .xlsx file. (.xlsx file in the attachment)

clear all;
close all;
L1 = load('dataset1.dat');
N1=6;     
N2=220;
k = 1;
for i = 1 : 1 : N1
  for j = 1 : 1: N2 
    k = (i - 1) * N2 + j;
    X1(j,i)  = L1(k, 1);
    Y1(j,i)  = L1(k, 2);
    Z1(j,i)  = L1(k, 3);
  end 
end 
contourf(X1, Y1, Z1);
lighting gouraud
xlim([0.0 0.6])
ylim([0.04 0.09])
set(gca, 'xtick', 0.0:0.1:0.6,'Fontsize', 15)
set(gca, 'ytick', 0.04:0.01:0.09,'Fontsize', 15)
xlabel('xlabel text','Fontsize', 20);
ylabel('ylabel text','FontSize', 20);