Converting Excel Spread sheet with XY coordinates into a Drawing

[riley_bouffard]

I don't use Cad very often however i need to find a way to convert an Excel spreadsheet with xy coordinates into a drawing in AutoCad LT. Probably very simple, but again i am a beginner. Edited by: riley_bouffard on Dec 30, 2008 7:13 PM

[Charles_Shade]

This is a spreadsheet from Brad I believe that I used to get me headed in the right direction. Search this discussion and you will find answers and help.



Regards,



Charles Shade

[riley_bouffard]

thanks for the help, if i know the equations for the lines i want to enter is it easier to enter those? If so how

[Charles_Shade]

Equations? Are you generating answers within the spreadsheet?

I use the attached to set up stair geometry and just copy/paste the Point information for # of risers I want into a PLINE at the Command line. Cocantenation is the key: &

Regards,

Charles Shade

[Anonymous]

AutoCAD can't deal with the equations directly.  You need to calculate
points and input them along with the commands to make a script.  Either
post or email a copy of your data and I will take a look at it. 

Brad

style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

<clshade> wrote in message
href="news:6096854@discussion.autodesk.com">news:6096854@discussion.autodesk.com...

Equations?
Are you generating answers within the spreadsheet?

I use the attached
to set up stair geometry and just copy/paste the Point information for # of
risers I want into a PLINE at the Command line. Cocantenation is the key:
&

Regards,

Charles Shade

[riley_bouffard]

Brad,

Thanks a lot, I got this job dropped in my lap because everybody who knows how to use cad decided to take the rest of the month off. I attached the data. I don't know how sensitive Cad is so i included all of the decimal points. The picture should be a simple curve. I can't thank you enough for the help.

[Charles_Shade]

Run the PLINE command and Paste column E from Excel at the command line. Run PEDIT and Spline the object to get a curve.



regards,

cshade

[riley_bouffard]

Thanks much easier than i thought

[Anonymous]

That was much easier than I thought too!  I
did not have to do anything! Glad I could help.....  😉

Thanks cshade for taking care of this.

--
Brad

style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

<riley_bouffard> wrote in message
href="news:6097181@discussion.autodesk.com">news:6097181@discussion.autodesk.com...

Thanks
much easier than i thought