Importing coordinates from excel and making points.

2018 6 20
1 个回答
回答已采纳
更新时间：2020 10 18
9 次查看（30 天）

0 个投票

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

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

 采纳的回答

KSSV
KSSV 2018-6-20

0 个投票

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

9 个评论
显示 7更早的评论 隐藏 7更早的评论

Matija Kosak
Matija Kosak 2018-6-20
Does xlsx file must be in a specific folder?
KSSV
KSSV 2018-6-20
Two options:
1. Run the code in the folder where file is resent.
2. Give filename with complete path and run the code.
Matija Kosak
Matija Kosak 2018-6-20
编辑：Matija Kosak 2018-6-20
Is it possible to write code to make path like on picture?
KSSV
KSSV 2018-6-20
YOu have coordinates of the path?
Matija Kosak
Matija Kosak 2018-6-20
I have coordinates for those points. I would need some code that can make path from them.
Matija Kosak
Matija Kosak 2018-6-20
http://www.rapidshare.com.cn/ozUB7yG
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.
Matija Kosak
Matija Kosak 2018-6-21
Do you maybe know any way that is possible? maybe something with point cloud?
Abel Francis
Abel Francis 2020-10-18
编辑：Abel Francis 2020-10-18
Is it possible to import coordinates in DMS from excel file into MATLAB?

请先登录，再进行评论。

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by