CAD Forum - tips, tricks, discussion and utilities for AutoCAD, Inventor, Revit and other Autodesk products []
CZ | EN | DE
Login or
  Visitors: 7558

CAD tip CAD tip # 11896:

Question CAD 
 %  platform  category 
Q - question

How to drive dyn.block parameters or constraints from Excel?

A - answer With the LISP add-on utility XLSparam for AutoCAD, you can control dimensional parameters of dynamic block, parametric constraints and other properties of drawing objects in your DWG files, by data from Excel XLS tables, from data extraction tables, or from manual tables in your DWG.

XLSparam links geometric parameters of dynamic blocks and constraint parameters with Excel XLS tables. In this way you can export parameter values to Excel and subsequently read the changed values back into your DWG drawing. You can also establish links between the values of dyn.block parameters (or other object properties) and given tables, and then drive these parameters by changing the tables (local drawing tables or datalinked Excel tables or dynamic dataextracted tables).

XLSparam brings more intelligent parametric behavior to your DWG drawings. Dimensions, rotation, or other properties of drawing objects can be driven by complex computations performed from your Excel worksheets. Entities can dynamically react to the results of BOMs (data extractions) from the same or from other drawings. By changing a single parameter in a table you can influence multiple objects at once.

Since version 1.1 you can also export, change and re-import visibility states.

How to use XLSparam:

More information and Trial download - see XLSparam.

100% *  CAD 
28.5.2018    8005×  
Prices - CAD eShop:
applies to: AutoCAD · Civil 3D ·

See also:
Tip 13760:Parametric text content in Fusion 360 sketches (and models).
Tip 13737:Formatting leading zeros in AutoCAD fields (and automatic field update).
Tip 13666:Oblique rectangular array in AutoCAD.
Tip 13522:LookupXLS - populating DWG texts from Excel spreadsheets.
Tip 13433:How to create a parametric dynamic 3D block in AutoCAD?

Back   All CAD Tips

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   

Use Google Earth images in your AutoCAD projects with the Plex.Earth Tools More info

Please use these tips at your own risk.
Arkance Systems is not responsible for possible problems that may occur as a result of using any of these tips.