Table Export ( Text to Excel )

-
Export Text from a Drawing to an Excel Spreadsheet "TE" is a LISP command for exporting text from a drawing to an Excel spreadsheet. 

 This command will attempt to locate text in columns based on your selection criteria. Start by loading the LISP code and typing "TE" at the Command line. 

 The program first will attempt to link with the Excel application, which must exist on your computer. 

 This program is very cool when it works, but make sure you have Excel installed. You might need to edit the code yourself for specific versions of Excel.






Comments

Post a Comment

Popular posts from this blog

BGTOOLS (Background tools)

-
Image
BGLAYDEL - Deleting frozen and frozen layers with primitives BG1BLEXP - Blocks blocks consisting of one primitive (possibly another block) BGBLEXP - Blocks the block and all the blocks included in it, turning visible attributes into text BGBLEXP1 - Blocks the blocks of the 1st level, turning visible attributes into text BGBLDYNEXP1 - Explodes dynamic blocks of the 1st level, turning visible attributes into text BGBLEXP1NOATT - Blocks level 1 blocks that do not have visible attributes BGBLXCLIP - Shows clipped blocks BGBLDYN2A - Converts dynamic blocks to anonymous BGBLDYN2S - Converts dynamic blocks to static ones BGBLALLDYN2A - Converts ALL dynamic blocks to anonymous     BGBLALLDYN2S - Converts ALL dynamic blocks to static ones   BGBLXCLIPEXP - to blow up the cropped block BGCB - copies one of the block occurrences to a block with a new name  BGRB - renames one of the block occurrences in a block with a new name M2U - Convert MINSERT to Unnamed block M2B - Convert MIN
Read more

Strip Mtext

-
Image
This program creates a user command that will quickly remove formatting applied to individual characters and words inside Mtext objects. StripMtext can remove the following types of formatting: Alignment  Color  Font Height  Underscore  Overscore  Linefeed (Paragraph Return)  Obliquing  Stacking  Tracking  Width  Non-breaking Space StripMtext does not modify Mtext properties such as style, justification, width, and rotation.  Nor does it manipulate inherited properties such as layer, entity color, etc. Note: Removing Mtext formatting is a very complex procedure.  This program has been designed to safely remove formatting but no guarantee exist.  Until you become familiar with StripMtext, please save your drawing before using.  If you do not like the results, you can immediatly issue an Undo command to restore your Mtext to its prior condition.  You are encouraged to spend a few minutes experimenting with different format removal settings on sample drawin
Read more