MATLAB: Importing coordinates from excel and making points.

3d plotsimporting excel data

Hello. I need to import 3D coordinates from excel to matlab and make points in matlab from those coordinates, I have three columns for each X, Y and Z coordinate. Thanks for help

Best Answer

[num,txt,raw] = xlsread('myfile.xlsx') ;
X = num(:,1) ;
Y = num(:,2) ;
Z = num(:,3) ;
plot3(X,Y,Z,'.')

Related Solutions

MATLAB: Read Excel sheet (one after other )

The second output of xlsinfo can tell you the names of all of the sheets. You can then loop over them with xlsread

filename = 'YourInputFile.xls';
[~, sheets] = xlsinfo(filename);
num_sheets = length(sheets);
data = cell(num_sheets, 1);
for K = 1 : num_sheets
  data{K} = xlsread(filename, sheets{K});
end

MATLAB: I have 3 columns of numerical data and I want to plot a surface. How to do this? I am willing to send the file and code. If I could get a coded response, I would be elated! Thanks.

clc; clear all ;
[num,txt,raw] = xlsread('ScaleData.xlsx');
x = num(:,1) ; 
y = num(:,2) ;
z = num(:,3) ;
X = reshape(x,[],3) ;
Y = reshape(y,[],3) ;
Z = reshape(z,[],3) ;
surf(X,Y,Z) ; 
shading interp ;

Best Answer

Related Solutions

MATLAB: Read Excel sheet (one after other )

MATLAB: I have 3 columns of numerical data and I want to plot a surface. How to do this? I am willing to send the file and code. If I could get a coded response, I would be elated! Thanks.

Related Question