suppose I have an excel file containing data of the x,y,z coordinates and a specific attribute value obtained from some other simulation software for a large number of points (densely distributed along a surface), how to “import” the data from this excel file, create points according to the coordinates information and visualize these points by representing their respective attribute as color?
Thanks!
how to import and visualize Excel data?
9742 9 2- oat
- Member
- 479 posts
- Joined: Dec. 2009
- Offline
- edward
- Member
- 7768 posts
- Joined: July 2005
- Online
- tamte
- Member
- 8637 posts
- Joined: July 2007
- Offline
- oat
- Member
- 479 posts
- Joined: Dec. 2009
- Offline
- oat
- Member
- 479 posts
- Joined: Dec. 2009
- Offline
- edward
- Member
- 7768 posts
- Joined: July 2005
- Online
Sorry, looks like I missed this thread. But it's simple. In Excel, choose File > Save As. In the save dialog under “Save as type”, look for “Text (Tab delimited)”.
Houdini doesn't support CSV files, so if you must deal in CSV files, Tomas suggestion is probably be best way. Parsing CSV files in Python yourself is probably pretty easy.
Houdini doesn't support CSV files, so if you must deal in CSV files, Tomas suggestion is probably be best way. Parsing CSV files in Python yourself is probably pretty easy.
- oat
- Member
- 479 posts
- Joined: Dec. 2009
- Offline
- Erik_JE
- Member
- 299 posts
- Joined: Jan. 2010
- Offline
oat
thanks, edward, I'm more interested in how to “load it via a File CHOP as a .chan file”
So, can you kindly shed a light on this?
Thanks!
You have to somehow convert your data in to a tab separated data. I don't think anyone is to interested in helping you with that as it is kinda boring.
But when it is done you can load it as a chan file.
Drive, monkey, drive!
- zarti
- Member
- 330 posts
- Joined: July 2007
- Offline
hi ,
there is already the ' Table Import ' ( python ) SOP node which might do what you need .
it imports a *.csv file and maps its columns to any attribute you want .. an existing or new one .
and you can feed chops from there easily , after that .
.cheers
there is already the ' Table Import ' ( python ) SOP node which might do what you need .
it imports a *.csv file and maps its columns to any attribute you want .. an existing or new one .
and you can feed chops from there easily , after that .
.cheers
except the things that cannot be seen , nothing is like it seems .
- edward
- Member
- 7768 posts
- Joined: July 2005
- Online
-
- Quick Links