CAD Forum - tips, tricks, discussion and utilities for AutoCAD, Inventor, Revit and other Autodesk products [www.cadforum.cz] ARKANCE | CONTACT - CZ | SK | EN | DE
Over 1.101.000 registered users (EN+CZ). AutoCAD tips, Inventor tips, Revit tips, Civil tips, Fusion tips. Try the new precise Engineering calculator. New AutoCAD 2026 commands and sys.variables and env.variables,.

CAD tip CAD tip # 11896:

Question

CAD 
 %  platform  category 
A
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    30090×  
Comments   Tell a friend
applies to: AutoCAD · Civil 3D ·

See also:
Tip 14721:Pixel fonts and "cube" styled texts in Fusion.
Tip 14714:Why is Fusion suddenly putting apostrophes in my text?
Tip 14699:How to add an attribute to all visibility states in a dynamic block?
Tip 14604:QRcode - dynamically generated QR codes in AutoCAD.
Tip 14537:Automation of AutoCAD drawing texts using fields.
Selected tip: How to get paper size from a .PLT file


Back    All CAD Tips

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
  



Featuring:
Revit plugins for automating data management, opening creation for clashes, and documentation Be.Smart Core Collection More info


Please use these tips at your own risk.
ARKANCE is not responsible for possible problems that may occur as a result of using any of these tips.
TOPlist
CADfórum
CADforum
Tips, tricks, utilities, help, how-tos and FAQ for AutoCAD, LT, Inventor, Revit, Map, Civil 3D, Fusion, Forma, 3ds Max and other Autodesk software (community support by ARKANCE). See About CADforum.
Copyright © 2025 | Advertise with us | Online privacy
ARKANCE CZ (CAD Studio) - Autodesk Platinum Partner & Training Center & Consulting Services Partner
CONTACT:
webmaster.cz@arkance.world | tel. +420 910 970 111
FB LN TW YT TW Blog RSS
.