plot excel table in autocad 2

[a3a]

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.

 

[tigrek]

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.

http://www.homescript.com

 

[tigrek]

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.

 

[a3a]

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!

 

[tigrek]

Delighted