Plot 3 axis from Excel

Question

Maciej 2022-9-16

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1806815-plot-3-axis-from-excel

评论： dpb 2022-9-20

Heat exchange.xlsx

Dears

How to plot data from attachment.

X axis 10-75

Y axis 10-75

Z axis (horizontal) 0-30000

3 个评论
显示 1更早的评论隐藏 1更早的评论

Maciej 2022-9-17

Dear Friends

row 10-75 on the top is temperature goes into the heat exchanger

column 10-75 is temperature comes out from heat exchanger

rest is the amount of heat exchanged depends on the temperature difference.

so axis x and y is temperature

z (vertical) (mistake in description above) is a heat exchanged

tahk you for help

dpb 2022-9-17

"row [1, values] 10-75 on the top is temperature goes into the heat exchanger"

"column [1, values] 10-75 is temperature comes out from heat exchanger"

-dpb

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

dpb 2022-9-17

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1806815-plot-3-axis-from-excel#answer_1055300

编辑：dpb 2022-9-17

Q=readmatrix('https://www.mathworks.com/matlabcentral/answers/uploaded_files/1127410/Heat%20exchange.xlsx');

Tin=Q(1,2:end);Tout=Q(2:end,1);Q=Q(2:end,2:end);

surf(Tin,Tout,Q)

hAx=gca;

hAx.View=[-60 40];

xlabel('T_{in}');ylabel('T_{out}');zlabel('Q')

NOTA BENE: Must take the 'Z' data from the overall array read ignoring the first row/column to matchup the actual 'X,Y' vector lengths from the whole array read in that has them all smooshed together. That's the only "trick" here.

It was very confusing to read the description owing to the language issues -- thought were describing that 10 rows/columns were all X, Y values until actually opened the spreadsheet to look -- the image @Image Analyst posted was so small couldn't read it ... :)

8 个评论
显示 6更早的评论隐藏 6更早的评论

dpb 2022-9-18

编辑：dpb 2022-9-18

That appears to be an issue with your default language/character set -- MATLAB is complaining that it can't read the filename string with bidirectional unicode characters.

I've never run across them before; know nothing about such animals with languages other than English so I'm not sure how one would go about fixing the issue on such a system.

How did you create the text string in the image -- since it was attached as an image and not as the text, we can't see what the actual code bytes are; see what

FQN=....;           % paste the filename string in your readmatrix command here
double(FQN(1:10))   % see what the ASCII codes of the first 10 characters are

If just mimic the beginning get

FQN='C:\Users\inzma\...';
double(FQN(1:10))
ans = 1×10
    67    58    92    85   115   101   114   115    92   105

where '67' is the ASCII code for single quote. If you don't get that try

FQN=strrep(FQN,char(XX),char(67));

where 'XX' would be the value you see other than 67 (presuming see something different) as first value of the filename. Then retry the code with the patched filename and see what happens.

How did you create the file name above???