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.
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
There, search for Excel and see the examples:
Set myExcel = CreateObject(Excel) etc.
www.homescript.com
RE: plot excel table in autocad
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
RE: plot excel table in autocad