For a 2D- and 3D-POLYLINE examples and a video check below.
Paste XLS to Points: This tool creates a 2D or 3D curve [as: a polyline, a set of points, or a set of line segments], or a 3D surface [as: a set of points, or a 3D mesh], when you paste a set of XLS [o simmilar] coordinates.
First choose the type of data [point coordinates] to enter [either 2D points - curve; 3D points - curve; or 3D points - surface].
Note: For surfaces you will also need to enter the number of N x M points.
Then, copy your XLS data [set of 2 or 3 columns], all the required range, and paste the data in your CAD’s command line. The data will be automatically catched as it got pasted.
The resulting 2D o 3D curve, or 3D surface will be drawn.
AutoCAD & GStarCAD users: Get your now!
Or use the following secondary link, or go to the downloads page.
Unlock YOUR FULL version of LitioLAB and start making all patterns right away!
How to import a collection of XLS 3D point coordinate data into AutoCAD/GStarCAD/ZwCAD to draw a 3D MESH surface
For these examples, I picked the headform definition to test helmets as per ISO 16073 standard.
The standard defines a set of 3D coordinates as a function of an angle and a height. It is easy to copy and paste these data into an XLS file and
do some XLS calculations to get the set of X Y Z coordinates of the headform definition.
So, I got these sets of points for three Headforms. For easier input, I have copied the data into a TEXT file, every point coordinate after the other.
So, for the first example I run LitioLAB and input the data belonging to the first set: the headform D.
The same for the next one, which is the headform G.
And finally, the same for the headform K.
These graphs can be used for CNC machining or 3D printing.
How to import a collection of XLS point coordinate data into AutoCAD/GStarCAD/ZwCAD to draw a 2D/3D Polyline
For these examples, I picked the coordinate data for several airfoils.
I just copy the coordinate data from this PDF and paste them into a TEXT file. And I start picking and copying the first set of data.
Then, I start LitioLAB and I choose the data import tool.
I select the 2D coordinate option.
And I paste the data I have already copied, to get a 2D polyline with an airfoil shape.
I repeat the process for the other 3 sets of data.
Finally, I turn into the 3D space to make an example of a 3D Polyline.
I pick a series of 3D point coordinates and I copy it.
Then, I start LitioLAB and I pick the data import tool. I chose the 3D option and I paste the set of data I have copied before, to get a 3D Polyline.