Niz Posted December 18, 2007 Share Posted December 18, 2007 Hello everyone I want to import an Excel file´s (.xls) coordinate information (X,Y) into Auto CAD as geometry - one point for every X,Y. I need to draw a profile grade - I have 123 points for one profile grade and i am trying to find easier way of drawing it then just drawing point by point How do I do that? (I use AutoCAD 2007, Excel 2003 ) Thank you all in advance Quote Link to comment Share on other sites More sharing options...
Guest LElkins Posted December 18, 2007 Share Posted December 18, 2007 check this out, see if it is what you are after. http://management.cadalyst.com/cadman/AutoCAD/Import-3D-points-from-Excel/ArticleStandard/Article/detail/101138 Quote Link to comment Share on other sites More sharing options...
Niz Posted December 18, 2007 Author Share Posted December 18, 2007 from what i see it is i will go to try it on and give you feedback later thanx a bunch Quote Link to comment Share on other sites More sharing options...
SLW210 Posted December 18, 2007 Share Posted December 18, 2007 You can also scroll to the bottom of this page and check out the "Similar Threads" and do a search on here. This topic has been covered many times. Quote Link to comment Share on other sites More sharing options...
Niz Posted December 20, 2007 Author Share Posted December 20, 2007 Little update I tried with scripts but i guess as beginner it is still hard for me to make it happen..so i searched for some help on web and i saw this page http://www.glamsen.se/CadTools.htm it is free utility and it has many features ..one to import coordinates and get Polyline Hope someone will have use of this as i did Quote Link to comment Share on other sites More sharing options...
azman Posted December 26, 2007 Share Posted December 26, 2007 I just download and install the program, but everytime i hit the command button, it says "AutoCad is not running, or wrong version!" Why? I'm using AutoCad 2007 tq Quote Link to comment Share on other sites More sharing options...
Lars Karlsson Posted January 2, 2008 Share Posted January 2, 2008 I just download and install the program, but everytime i hit the command button, it says "AutoCad is not running, or wrong version!" Why? I'm using AutoCad 2007 tq look in the CadTools Settings, there's a dropdown list with cad versions. Select Autocad 2007. If not working, send a email to the developer (me) Regards Lars Quote Link to comment Share on other sites More sharing options...
longcrier Posted November 12, 2009 Share Posted November 12, 2009 I used the method from the "Odd Spot" to create several stream cross-sections and these are some tips I picked up along the way. 1. don't put the x and y coordinates in the same cell in excell, it's easier and there is less chance of transposing number and such if you copy the two columns (X and Y) into note pad then remove the tab spaces and add commas 2. If you format your cells in excell to have the same number of decimal places the process goes really fast once you are in notepad 3. The polyline comes in on the current layer, maybe this is obvious but it helped me make sure I knew which x-sections were which It's all about caditude. Quote Link to comment Share on other sites More sharing options...
vickwarya Posted March 26, 2010 Share Posted March 26, 2010 Hi, i currently have a layout of the building in AutoCAD 2010 and i have some data in the excel file. Excel files consists of unique #s for different location in the AutoCAD layout. Each number is assosiated with the location in layout. Each location gets tested everyday day and according to the result if its positive or negative i make a green/red circle in the AutoCAD layout. Now what i was wondering is if it possible for me to somehow connect the excel file to the AutoCAD layout so when i put in the result (positive or Negative) it would automatically make a either a green or red circle in the layout. Any help or suggestion is much appreciated. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.