Read a 3D matrix from Excel file
조회 수: 7 (최근 30일)
이전 댓글 표시
I have an Excel file of multiple rows and columns. I want to plot the entire file as a 3D plot. The first row is X and the First column is Y. I have tried to read X,Y and Z with the below codes, but I faild.I want to insert this data into a 3D matrix, in which I could do some calculations on that and then plot it. How can I insert this Excel file into a 3D matrix? and How can I plot it? I have also attached the Excel file. Thanks
x=sample(1,2:22)
y=sample(2:102,1)
xSize=length(x);
ySize=length(y);
for i=1:xSize
for j=1:ySize
xP(i)=x(i);
yP(j)=y(j);
zP(i,j,j)=sample((i+1),(j+1))
end
end
댓글 수: 6
채택된 답변
Voss
2022년 1월 28일
I think a 2D matrix is the way to go, since you have one value for each (x,y) point.
Here are some ways you might visualize your data. All of these ways create a surface object:
sample = readmatrix('sample.csv');
x=sample(1,2:end);
y=sample(2:end,1);
data = sample(2:end,2:end);
figure();
surf(x,y,data);
colorbar();
Then the same surface viewed from above:
figure();
surf(x,y,data);
colorbar();
view([0 90]);
Another way to do the same thing:
figure();
pcolor(x,y,data);
colorbar();
추가 답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Graphics Object Programming에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!