Splines in Autocad

[arun17]

Hi friends,
I want to draw a spline in Autocad.I am having the coordinates of the points( approx. 1000 points), through which spline is to be drawn, in a data file. I want to read the coordinates from the data file and draw the spline. How we can do it using a simple lisp routine or VBA routine. Obviously I would not like to do it manually because I want to compare the splines drawn for various data files containing same amount of data.
Any suggestions?
Thanks.

"Knowledge is power"

 

[exit]

Hi,

I would export the coords into excel, save as a script and "import" it back (a lot of work).

Maybe Landcad can more...?

Lothar

Win NT4.0(SP6),2000(SP3)
AC 2000i(SP2), ADT 3.0(SP3),
AC 2002, ADT 3.3,
AC 2004, ADT 2004

 

[arun17]

Hi,
My data file is a tab delimited file generated by some other software. I have already read the file in excel. How to get this data in Autocad from excel?
Thanks

"Knowledge is power"

 

[OZZY84]

what version of acad, any other add-on applications?
if not, then post e-mail, i will send you mine. then send file, i will generate the points and pline and return in dwg format, you can then manipulate as needed
by the way, i will be using acad + eagle point for this.
if you do this often, then a good civil package will help.

hope this helps

Intel P4 1.7 GHZ
768 RDRAM
Win 2000 Pro
Autocad 14, 2002 with EP 2.3.1

 

[FacilitiesCAD]

I don't know if you want a spline or line but I'll tell you how to do either from excel.
first open your excel and autocad.
now I am going to assume your data is in 2 colums such as bellow.
A B C etc
1 X Y
2 1 1
3 5 2
etc
1001 27 35

You need to make another colum with the following command
=A2&","&B2
and copy it down the column.


A B C etc
1 X Y
2 1 1 1,1
3 5 2 5,2
etc
1001 27 35 27,35

Now in the spot c1 in the diagram You can write _line
and hilight c1 through c1002 hit control C to copy and then in Autocad hit control V at the command line to paste.
To spline put in _spline instead of _line in cell c1 and then you need to put some points for the start and stoping tangents in cells c 1003 and c1004.
You can also start the comand (_line) and just paste in the coordinates.

Thanks

 

[exit]

Hi,
@arun17: thread555-52987 "spline" in the first line

if You want,you mail the *.xls to Kramer24@freenet.de
I would have a look...
Lothar

Win NT4.0(SP6),2000(SP3)
AC 2000i(SP2), ADT 3.0(SP3),
AC 2002, ADT 3.3,
AC 2004, ADT 2004

 

[arun17]

Hi,
Thanks exit & Facilitiescad. I tried the method suggested by Facilitiescad and it worked nicely.However I had written a VBA routine also which read my data file and plots the spline using Addspline method.
Problem is solved!!!!!!!!!!!


"Knowledge is power"