Jump to content

copy text from Excel to AutoCAD by Lisp at the co-ordinate (12, 6), width 6, and on sheet PV-4.0


Recommended Posts

Below is a breakdown of the tab, items in bold refer to the column headers on that tab.  The number of entries on each tab will vary from project to project, so the code should loop accordingly.
  • ACAD_PlansetNotes
    • These are text blocks that should be created and inserted into the planset on different pages and locations
    • We will only work on "standalone" items (Type), which are individual, floating pieces of text.
    • For items on this tab you will need to:
      • Write the text into AutoCAD in a visible layer (Text_Visible) onto the correct sheet (Sheet)
      • Just above the visible text, write the hidden text on the "No Plot" layer (Text_Hidden)
      • Set the width of the text block (Width_In)
      • Text should be placed in the specified location based on x-y coordinates to the top-left corner (Location_AbsX_In Location_AbsY_In)
        • e.g. if  Location_AbsX_In = 2 and  Location_AbsY_In = 4, the top-left corner of the text should be 2 inches over and 4 inches down from the top-left corner of the page.
Link to comment
Share on other sites

You can do all that in excel just write down every word and enter required doing it manually and make a command sequence like a script. The "ctab" sets the current layout, ctab Model, ctab PV-40. Make it one cell or line by line and copy and paste.


If you want it all smart then just search here so many examples of Autocad <-> Excel

Edited by BIGAL
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...