How are you today.
This is the second day on blogger.com and today I wanna give you a tips 'How to draw points and poly line in auto cad software through Microsoft excel, and using this command you can copy one object to multiple location in a second so lets start......
1) Open Microsoft Excel, in 1st column type command PL (LIST in 2nd column will be easting(X) value (214609.15), in 3rd column will be northing (Y) value (389996.38) and in 4th column if you have level (Z) value (42.359) and in 5th column (bracket close) ), this all will be in 1st row.
2) In second row, 1st column type (LIST, in 2nd column will be next easting(X) value, 3rd column next northing(Y) value 4th column level (Z) value and in last 5th column bracket close )
as shown in image below, select from 2nd row column A to last whatever data you have up to column E and copy ctrl+c
3) Now open your auto cad software and directly paste in command line, remember before paste your data you have to off Osnap with pressing F3 button.
you can see polyline is drawn....
4) And now if you want to copy any object to this coordinates in a second just copy that object in cad with copy command not ctrl+c and select that object then in command line right click and paste coordinates you already copied from excel lets see below images
1)
2
3
4
object copied to same location
Thanks for reading,,,
Happy blogging...
This is the second day on blogger.com and today I wanna give you a tips 'How to draw points and poly line in auto cad software through Microsoft excel, and using this command you can copy one object to multiple location in a second so lets start......
1) Open Microsoft Excel, in 1st column type command PL (LIST in 2nd column will be easting(X) value (214609.15), in 3rd column will be northing (Y) value (389996.38) and in 4th column if you have level (Z) value (42.359) and in 5th column (bracket close) ), this all will be in 1st row.
2) In second row, 1st column type (LIST, in 2nd column will be next easting(X) value, 3rd column next northing(Y) value 4th column level (Z) value and in last 5th column bracket close )
as shown in image below, select from 2nd row column A to last whatever data you have up to column E and copy ctrl+c
3) Now open your auto cad software and directly paste in command line, remember before paste your data you have to off Osnap with pressing F3 button.
you can see polyline is drawn....
4) And now if you want to copy any object to this coordinates in a second just copy that object in cad with copy command not ctrl+c and select that object then in command line right click and paste coordinates you already copied from excel lets see below images
1)
2
3
4
object copied to same location
Thanks for reading,,,
Happy blogging...
No comments:
Post a Comment