CAD Forum - tips, tricks, discussion and utilities for AutoCAD, Inventor, Revit and other Autodesk products [www.cadforum.cz]
CZ | EN | DE
Login or
registration
  Visitors: 3511

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.

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

See also:
Tip 13337:How to select blocks by attribute values? (SelByAttr)
Tip 13246:I can't copy/paste a block from AutoCAD into an Inventor drawing.
Tip 13000:Labels of dimensional parameter values in dynamic blocks (parameters->attributes)
Tip 12966:TrimArr - trim a dynamic array to a boundary curve.
Tip 12609:Dynamo - how to convert a raster photo to 3D model in Revit?


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   



Featuring:
Save your floating licenses (NLS) consumed by inactive users - free unused licenses with
LogOff 2006 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.
TOPlist