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

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    25582×  
Prices - CAD eShop:
applies to: AutoCAD · Civil 3D ·

See also:
Tip 14088:3 methods of creating true rectangles in AutoCAD.
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.

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   

Increase your productivity with our set of BIM add-on functions for Autodesk Revit
CADstudio Revit 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.