AutoCAD 2010/2011/2012

Reply
Mentor
JamaL9722060
Posts: 1,302
Registered: ‎04-09-2010
Message 1 of 4 (2,331 Views)
Accepted Solution

How to plot (draw) the xy data saved in a CSV file?

2331 Views, 3 Replies
02-25-2012 03:35 PM

How to plot (draw) the xy data saved in a CSV file?

 

I’m not sure if there is an enhanced workflow to plot the xy coordinates saved in an CSV file in the AutoCAD 2012.

 

I found the approach below in the web

----------

1.Open the Excel file.
2. Save it as a .CSV file (comma separated values).
3. Open the .CSV file in notepad, add two lines at the top:

._multiple
._point

4. Then save this file with a .SCR file extension.
5. In AutoCAD run the ._Script command, and pick the .SCR file above.

-------

 

Is there a better way?

 

Thank you in advance,

 

Best

 

Jamal

----------------------------------------------------------
Jamal NUMAN, GIS and Civil Engineer, MSc
e-mail: JamaL9722060@yahoo.com
P.O.Box: 731, Ramallah, West Bank, Palestine.
----------------------------------------------------------
Software: AutoCAD 2014, AutoCAD C3D, AutoCAD M3D, Revit
Windows 7 (Ultimate 64 bits),
Firefox 20.0,
Kaspersky 2013.
*Expert Elite*
Alfred.NESWADBA
Posts: 8,867
Registered: ‎06-29-2007
Message 2 of 4 (2,318 Views)

Re: How to plot (draw) the xy data saved in a CSV file?

02-26-2012 02:11 AM in reply to: JamaL9722060

Hi,

 

the approach doing this with script is OK.

 

One additional option would be to create a new column in Excel (using formulas) that contains X and Y (and optional Z) values separated with "," (and decimal-character as point), so the column looks like this

10.23,400.5

20.45,401.0

23.10,402.5

21.98,403.0

 

And now you can mark the fields in this column in Excel ==> <Ctrl>-<C> to bring them to the copy-buffer.

Change the focus to AutoCAD ... to the command-line, type in (as you already mentioned)

_MULTIPLE<ENTER>

_POINT<ENTER>

<Ctrl>-<V>

 

that pastes the coordinates directly into the command-line and you don't need to create a script-file.

 

Just another way, same result :smileywink:

 

- alfred -

-------------------------------------------------------------------------
Alfred NESWADBA
Ingenieur Studio HOLLAUS ... www.hollaus.at
-------------------------------------------------------------------------
Mentor
JamaL9722060
Posts: 1,302
Registered: ‎04-09-2010
Message 3 of 4 (2,304 Views)

Re: How to plot (draw) the xy data saved in a CSV file?

02-26-2012 01:13 PM in reply to: Alfred.NESWADBA

Perfect Alfred. This is a quite satisfactory workflow and important contribution. Brilliant

 

 

Many thanks

 

Best

 

Jamal

 

Clip_317.jpg

 

Clip_319.jpg

 

Clip_320.jpg

 

 

----------------------------------------------------------
Jamal NUMAN, GIS and Civil Engineer, MSc
e-mail: JamaL9722060@yahoo.com
P.O.Box: 731, Ramallah, West Bank, Palestine.
----------------------------------------------------------
Software: AutoCAD 2014, AutoCAD C3D, AutoCAD M3D, Revit
Windows 7 (Ultimate 64 bits),
Firefox 20.0,
Kaspersky 2013.
Mentor
JamaL9722060
Posts: 1,302
Registered: ‎04-09-2010
Message 4 of 4 (2,281 Views)

Re: How to plot (draw) the xy data saved in a CSV file?

02-27-2012 01:11 PM in reply to: Alfred.NESWADBA

Hi Alfred,

 

Could you please have a look on the link of the thread below, it is quite relevant to this thread.

 

http://forums.autodesk.com/t5/AutoCAD-2012/Points-Labeling/td-p/3348259

 

best

 

Jamal

----------------------------------------------------------
Jamal NUMAN, GIS and Civil Engineer, MSc
e-mail: JamaL9722060@yahoo.com
P.O.Box: 731, Ramallah, West Bank, Palestine.
----------------------------------------------------------
Software: AutoCAD 2014, AutoCAD C3D, AutoCAD M3D, Revit
Windows 7 (Ultimate 64 bits),
Firefox 20.0,
Kaspersky 2013.

You are not logged in.

Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register

Announcements
Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.

Need installation help?

Start with some of our most frequented solutions to get help installing your software.

Ask the Community




Connect with AutoCAD

Twitter

Facebook

Blogs

Pinterest

Youtube