Importing coordinates from excel and making points.

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

 Accepted Answer

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

9 Comments

Does xlsx file must be in a specific folder?
Two options:
1. Run the code in the folder where file is resent.
2. Give filename with complete path and run the code.
Is it possible to write code to make path like on picture?
YOu have coordinates of the path?
I have coordinates for those points. I would need some code that can make path from them.
I can't upload directly. So this is excel file with coordinates, you can see it's not in correct order of path I want to make, so is there any code you can use to make path that is similar to picture.
Do you maybe know any way that is possible? maybe something with point cloud?
Is it possible to import coordinates in DMS from excel file into MATLAB?

Sign in to comment.

More Answers (0)

Categories

Asked:

on 20 Jun 2018

Edited:

on 18 Oct 2020

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!