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: 4288

CAD tip CAD tip # 9814:

   
Question CAD 
 %  platform  category 
Q - question

Export picked texts/dims from DWG drawings to Excel.

A - answer Using the free AutoLISP utility CADstudio Click2XLS with its added command Text2XLS you can easily transfer picked AutoCAD drawing texts or dimensions to a MS Excel sheet (automatically created or pre-prepared). All types of drawing text objects are supported - single-line and paragraph texts, block attributes (incl. nested), attribute definitions, dimensions, leaders, tables (except table cells written in TrueType fonts). If MText texts are formatted, Excel will receive cleaned up, pure text.

The "Paragraph" mode will write clicked MText paragraphs to individual cells.

Sample video:

You can download the Click2XLS utility from cadstudio.cz/freeware

ACAD
100% *  CAD 
8.5.2014    27093×  
Prices - CAD eShop:
applies to: AutoCAD ·

See also:
Tip 13683:Limitations of the LISP language (AutoLISP, VisualLISP) in AutoCAD LT - what to watch out for
Tip 9594:Click2OO - export of AutoCAD coordinates to OpenOffice Calc.
Tip 8030:Click2XLS - click points to export from AutoCAD to Excel.
Tip 7258:Export of point- and curve coordinates to Excel.


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:
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.
TOPlist