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

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 Excelu 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.

How to use XLSparam:

More information and Trial download - see XLSparam.

ACADCivil
100% *  CAD 
28.5.2018    1057×  
Comments   Tell a friend
applies to: AutoCAD · AutoCAD Civil 3D ·

See also:
Tip 11898:Automatic schedule - number of blocks in a drawing.
Tip 11780:How to rename layouts by a specific attribute of the title block?
Tip 11614:How to reorder custom properties in a dynamic block?
Tip 11561:How to create a block with multiple insertion points?
Tip 11497:Automatic grouping of drawing objects.


Back   All CAD Tips All CAD tips&tricks

Automatic schedule - number of blocks in a drawing. « | » Dynamic label of area and perimeter - DynArea.

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:
Use Google Earth images in your AutoCAD projects with the Plex.Earth Tools 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