Entering data in Excel for AutoCad lines

[kenny]

Hi. I have numerous individual lines. Simple lines with a start and end point only, but many.

I was wondering if I could enter the x and y coordinates for all the lines in Excel and then bring them into Cad somehow.

Is this possible? I am using 2007-LT

Thanks in advance, Ken

[lpseifert]

Look at 'Similar threads' at the bottom of the page.

[phillion]

Yes,
make a number comma number column in excel, copy the column.
(if you already have your data in two columns create a third column for number comma number. Use =A1&$C$1&B1 where cell C1 is just a comma (,) in excel)

Type PLINE on the command line in CAD, hit Enter
now Paste.

hope that helps.


edit: that just gives you one continuous line

[kenny]

Is this correct for the Excel spreadsheet?

Row 1
Column A: X coordinate start line
Col B: ,
Col C: Y coordinate start line
Col D: ,
Col E: X coordinate end line
Col F: ,
Col G: Y coordinate end line
Col H: Concatenate all lines to read X,Y,X,Y
Row 2
repeat for new line

[lpseifert]

X is in A1, Y is in B1; put this in C1 =A1&","&B1
C1 will be in the form of X,Y
Copy the formula down the C column

[kenny]

thanks, so I now have two columns. One that reads

x,y for line start and the other x,y for line end

do both of these columns get concatenated? Is there an additional comma that separates them?

[eldon]

Is it not a complication to concatenate by formula to add commas ?

The data file then has to be tidied up to get rid of the duplicate data

If you merely enter the data in separate cells, then save the file as Comma Delimited (csv), then all commas are added between the data

[kenny]

Sorry - a bit slow here. Is it my understanding that the end line coordinate should be in the same column in a row below the start line coordinate - not on the same row?

When the excel file is saved as a csv file, I will then enter the line command and paste the entire column in the command line, right?

[kenny]

It's almost working!

It seems that I am unable to get separate lines - they somehow get attached by a 3rd line.

[lpseifert]

Set up your data like this in excel

line
0,0
1,1

line
2,2
3,3

Then just copy/paste it to the command line.