3D plots from Excel spreadsheet

2 次查看（过去 30 天）

kcl128 2016-3-5

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/271636-3d-plots-from-excel-spreadsheet

BH001.xlsx

I am new to Matlab. I am importing data from a spreadsheet into a numerical matrix (32 rows and 10 columns). All the data is numeric and represents the wall thickness measurements made in a 100 mm grid marked on the full circumference of the pipe (i.e. 32 x 10 cells of measurement). I have successfully imported the data and can read each row, but only by entering each row individually e.g. row1 = ut(1,:). What I would like to be able to do is:

a) automate the calculation for all of the 37 rows to show the data for each cell, max, min and mean for each row b) create a 3D plot to show the pipe with the measured depths as contours. A spreadsheet is attached.

Thank you.