Re: excel data to draw line in autocad.
I'm working on AUTOCAD 2010 and Excel 2007 version. I'm not sure, but for me it looks more comfortable and automatic to use some executing button in an excel file than saving it as a .CSV file. I thought even it would be nice if excel in first step creates the layers (various thickness, colour and line types) and then in second step generates the lines combined with particular layers.
I'm grateful for your help Fixo.
Re: excel data to draw line in autocad.
Try this Excel file, in the following order
first open drawing, then open Excel file,
open desired spreadsheet and select
data range, then click button,
if this woking good for you, then back
to Excel file and repopulate the range with your
own data
Here you can get it
https://dl.dropbox.com/u/18024145/Drawing_Lines.zip
1 Attachment(s)
Re: excel data to draw line in autocad.
Quote:
Originally Posted by
fixo
Try this Excel file, in the following order
first open drawing, then open Excel file,
open desired spreadsheet and select
data range, then click button,
if this woking good for you, then back
to Excel file and repopulate the range with your
own data
Here you can get it
https://dl.dropbox.com/u/18024145/Drawing_Lines.zip
Or get it from attachment
Re: excel data to draw line in autocad.
It works, it's amazing. How do You know this all Fixo? Where can I find some tips how to create such a connection between ACAD and Excel? I have much more questions but I don't want to bother you.
Re: excel data to draw line in autocad.
Glad if this working for you,
To be honestly I'm just an old homesitter and
do nothing but make the programs, piece by piece,
day by day, on many languages, its all my life...
Search this forum: Interaction between AutoCAD and Excel,
all 6 parts
Cheers :)
Re: excel data to draw line in autocad.
I'm only a civil engineering student, so programing is tricky for me.
Respect for your knowledge Fixo. I admire your skills.
I hope, You will help me if the other problems appear.
Thanks.
Re: excel data to draw line in autocad.
Well, if I will be in the good condition,
:)
Re: excel data to draw line in autocad.
Quote:
Originally Posted by
fixo
Try attached file
Open Autocad drawing
Open Excel file (AutoCAD must be opened)
Select four columns
Press button
~'J'~
I am attempting the same thing. I have selected to four columns and pressed the button, Received "Compile Error: Cannot find project or library." Excel 2007 with ACADm 2012. Please advise, Thank you!
Re: excel data to draw line in autocad.
Quote:
Originally Posted by
Darren Allen
I am attempting the same thing. I have selected to four columns and pressed the button, Received "Compile Error: Cannot find project or library." Excel 2007 with ACADm 2012. Please advise, Thank you!
Hi Darren, I just tested this one on my AutoCAD 2010,
try to change references on your A2012 Relesase,
then let me know about
1 Attachment(s)
Re: excel data to draw line in autocad.
hi fixo ,i have attached the required autocad file here.please see your inbox massage folded..........related massage i have sent to you there