CAD Forum - tips, tricks, discussion and utilities for AutoCAD, Inventor and other Autodesk products [www.cadforum.cz]
Cesky English Deutsch
Login/Register:
 Visitors: 1960 

CAD tip CAD tip # 6692:

Question CAD 
 %  platform  category 
Q - question

Simply create points or polyline from coordinates in Excel.

A - answer If you need to import a list of coordinates from Excel, generate blocks at computed coordinates, or draw a mathematic curve computed with Excel expressions, you may need the CADstudio Xls2Curve utility.

This tool imports coordinates (XY or XYZ) from a previously selected region in an opened (active) Excel sheet. From these 2D or 3D coordinates, it then creates points (Point), curves (LWPolyline, 3DPolyline), splines or block references (Insert) in your drawing. In the Excel table just mouse-select any contiguous range containing the point coordinates.

An example of import of the results from a mathematic expression describing a lemniscate curve (see the attached XLS sample):

List of coordinates X-Y in Excel

Imported spline curve in AutoCAD

Included is the complementary function Curve2Xls which exports coordinates (XY or XYZ) of curves and points to Excel (the selected cell of the running Excel sheet).

You can download the Xls2Curve utility at www.cadstudio.cz/download. The activation of this trial version (limited to 10 points) can be done with the XANADUREG command.

ACADADTMapCivil
100% *  CAD 
25.5.2009    24853x  
Comments   Tell a friend

See also:
Tip 9788:How to import named workpoints from Excel to Inventor?
Tip 9596:How to copy UCS from another DWG drawing?
Tip 8657:Import error: No point file format match found
Tip 8496:Import a XYZ-coordinate file as AutoCAD points with labels.
Tip 8361:Automatic vertex labels with autonumbering and coordinates.


Back   All CAD Tips All CAD tips&tricks

What is the maximum number of vertices in AutoCAD polylines? « | » Switching Display configurations from command line.

Have we helped you? If you want to support the CAD Forum web service, consider buying one of our CAD applications, or our custom software development offerings, or donating via PayPal (see above). You may also add a link to your web - like this "fan" link: CAD Forum - tips, utilities, blocks for Autodesk products
CAD:    OS:    Categ: 
Text:  FAQ glossary   



Featuring:
Export 3D VRML scenes from AutoCAD and Inventor 2015
VRMLout More info


Please use these tips at your own risk.
CAD Studio (Xanadu) is not responsible for possible problems that may occur as a result of using any of these tips.
TOPlist