×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

plot excel table in autocad
2

plot excel table in autocad

plot excel table in autocad

(OP)
I have many tables of x and y values in Excel 97 (same file) that i would like for autocad to read the table and plot the points on top my exsisting drawing.  Does anyone have a routine for this, or is there a way to do it without having to use lisp.  I would prefer to have the plotted points custumized, that is, the points plotted from one table shown with symbols from my drawing blocks, and other tables where letters are plotted (i.e. an "s" is plotted instead of a dot or an x).  I'm sure I could just put the letters into a drawing block, but I have now clue how to go about writting a lisp to import data and update the drawing screen or how to get each table on a different layer

If you can't help with specifics, I appreciate a point in the right direction, as I am too pressed for time (and lazy) to re-enter hundreds of numbers into autocad from the excel file.

Thanks for any help.  

RE: plot excel table in autocad

Please try Alt-F11 from Acad Drawing to go to VBA development window.

There, search for Excel and see the examples:
Set myExcel = CreateObject(Excel) etc.

www.homescript.com

RE: plot excel table in autocad

Now that I think of it, there is another way, without messing around with Lisp or VBA.

In Excel, assuming the coordinates are on Sheet 1:

In Sheet 2, write down in a column, the few Acad comand line commands that you would be using if you did this manually, leaving cells empty for coordinates.

Then Link those cells to cells in Sheet 1.

Then copy the column and paste it in txt file, name it myScript.scr.

From Acad Menu->Tools->Run Script->Browse for script file

myScript.scr

Try a few times until the command sequence is right.
Empty line for returns etc.

Hope this helps.
It is an improvization of mine and often works even.

Take care.

RE: plot excel table in autocad

(OP)
Hey thanks tigrek!!  I played around with a generic script I made and I think I can spruce it up to do what I want .  Never used the scripts before, thanks for pointing them out!


RE: plot excel table in autocad

Delighted

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources