Visual LISP, AutoLISP and General Customization

Reply
Valued Contributor
imtaha
Posts: 53
Registered: ‎03-25-2009
Message 1 of 10 (472 Views)

From Excel to AutoCAD

472 Views, 9 Replies
09-26-2011 08:33 AM

Hi Guys,

 

We usually have like data points in Excel that we need to draw a chart from in AutoCAD, what we do know is we do it in Excel then copy and paste it in AutoCAD. It would much more efficient and accurate if we a lisp that convert the points from Excel and convert it to a chart in AutoCAD automatically. That would really help us big time.

 

Thanks

*Expert Elite*
azrdgldr
Posts: 1,250
Registered: ‎01-09-2007
Message 2 of 10 (469 Views)

Re: From Excel to AutoCAD

09-26-2011 08:44 AM in reply to: imtaha

Have you looked into the data link from the table command?  But it depends on the version of AutoCAD you have.

Valued Contributor
imtaha
Posts: 53
Registered: ‎03-25-2009
Message 3 of 10 (465 Views)

Re: From Excel to AutoCAD

09-26-2011 08:55 AM in reply to: imtaha

Will it make the chart as an AutoCAD object?

*Expert Elite*
azrdgldr
Posts: 1,250
Registered: ‎01-09-2007
Message 4 of 10 (460 Views)

Re: From Excel to AutoCAD

09-26-2011 09:24 AM in reply to: imtaha

Yes, no OLE object.

Valued Contributor
imtaha
Posts: 53
Registered: ‎03-25-2009
Message 5 of 10 (454 Views)

Re: From Excel to AutoCAD

09-26-2011 09:43 AM in reply to: azrdgldr

Thanks, but on the image you sent I see only the Table. How can I get the chart?

*Expert Elite*
azrdgldr
Posts: 1,250
Registered: ‎01-09-2007
Message 6 of 10 (450 Views)

Re: From Excel to AutoCAD

09-26-2011 09:48 AM in reply to: imtaha

You have to go thru the command process of picking the excel file you want to bring in as a table.  I just provided the pic for you to see the data link portion of the tables command. 

 

Now I am wondering if we are on the same page.  You mention points as in x, y, and z but say charts.  You are talking about points or pie charts in Excel?  Just clarifying.

Valued Contributor
imtaha
Posts: 53
Registered: ‎03-25-2009
Message 7 of 10 (434 Views)

Re: From Excel to AutoCAD

09-26-2011 01:14 PM in reply to: azrdgldr

I'm talking about points chart, and I tried the table command it does not give an option for a chart, how can I make the chart after I bring the x, y and z coordinates.

 

Thanks

Valued Contributor
imtaha
Posts: 53
Registered: ‎03-25-2009
Message 8 of 10 (426 Views)

Re: From Excel to AutoCAD

09-26-2011 02:13 PM in reply to: imtaha

I think I wasn't clear on that. What I have is a long list (1000) of x, y and z points in Excel it represents a pipeline profile, I want to bring those points in AutoCAD and then draw poly line between the points so I can have the profile drawn in AutoCAD.

 

Thanks

*Expert Elite*
Patchy
Posts: 6,222
Registered: ‎09-16-2009
Message 9 of 10 (424 Views)

Re: From Excel to AutoCAD

09-26-2011 02:23 PM in reply to: imtaha

Google for Lee Mac Programming, he has it in there.

Valued Mentor
TerryDotson
Posts: 482
Registered: ‎06-06-2010
Message 10 of 10 (386 Views)

Re: From Excel to AutoCAD

09-27-2011 08:26 AM in reply to: imtaha

Most likely you are seconds away from completely drawing the polyline.  Try inserting a new line at the top with the word 3DPOLY, then save the file as a TXT file, but use the extension .SCR.  You can then issue the AutoCAD SCRIPT command and it will draw the polyline.   Here is a link to a more elaborate procedure to create layers.

 

http://www.dotsoft.com/procedures.htm#ExcelScripting

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