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:
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,
Solved! Go to Solution.
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
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)
that pastes the coordinates directly into the command-line and you don't need to create a script-file.
Just another way, same result
- alfred -
Perfect Alfred. This is a quite satisfactory workflow and important contribution. Brilliant
Could you please have a look on the link of the thread below, it is quite relevant to this thread.
Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register