Results 1 to 2 of 2

Thread: Lisp to update blocks from excel file Acad 2017

  1. #1
    Join Date
    Login to Give a bone

    Smile Lisp to update blocks from excel file Acad 2017

    Good Morning!
    I am looking for a lisp routine that will update the loading tree diagrams on my Transmission line drawings. The loading trees are attributed and I have and excel file containing the information for the loading trees
    The lisp should populate the blocks when the lisp is loaded. I have upload a typical drawing scenario and excel file. Your help is appreciated.
    Attached Files Attached Files
    Last edited by Colette; 2017-05-10 at 11:56 AM.

  2. #2
    Join Date
    Login to Give a bone

    Default Re: Lisp to update blocks from excel file Acad 2017

    AutoCAD Express tools has two great functions: Export Attributes and Import Attributes. Export Attributes creates Tab Delimited text file. This text file can then be opened in Excel. But it must remain a Tab Delimited text file. You can map this AutoCAD data into another excel spread sheet for further manipulation in other documents etc. but the integrity of the original text file must remain. Use this master text file to make any changes to the attribute values and then use the Express Tools "Import Attributes" to import the modified values from the text file. As simple as that.

Similar Threads

  1. Update titleblock lisp AutoCad 2017
    By Colette in forum AutoLISP
    Replies: 8
    Last Post: 2017-06-21, 04:16 PM
  2. Replies: 0
    Last Post: 2015-10-21, 05:54 PM
  3. Replies: 0
    Last Post: 2014-04-02, 05:30 PM
  4. Replies: 5
    Last Post: 2013-05-18, 01:44 PM
  5. Replies: 3
    Last Post: 2006-11-30, 05:30 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts