Read a 3D matrix from Excel file
10 ビュー (過去 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!