See the top rated post in this thread. Click here

Page 2 of 4 FirstFirst 1234 LastLast
Results 11 to 20 of 40

Thread: excel data to draw line in autocad.

  1. #11
    Member
    Join Date
    2012-10
    Posts
    4
    0 Did you find this post helpful? Yes

    Default 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.

  2. #12
    AUGI Addict fixo's Avatar
    Join Date
    2005-05
    Location
    Pietari, Venäjä
    Posts
    1,267
    0 Did you find this post helpful? Yes

    Default 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
    "The whole problem with the world is that fools and fanatics are always
    so certain of themselves, and wiser people so full of doubts."
    Bertrand Russell

  3. #13
    AUGI Addict fixo's Avatar
    Join Date
    2005-05
    Location
    Pietari, Venäjä
    Posts
    1,267
    0 Did you find this post helpful? Yes

    Default Re: excel data to draw line in autocad.

    Quote Originally Posted by fixo View Post
    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
    Attached Files Attached Files
    "The whole problem with the world is that fools and fanatics are always
    so certain of themselves, and wiser people so full of doubts."
    Bertrand Russell

  4. #14
    Member
    Join Date
    2012-10
    Posts
    4
    0 Did you find this post helpful? Yes

    Default 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.

  5. #15
    AUGI Addict fixo's Avatar
    Join Date
    2005-05
    Location
    Pietari, Venäjä
    Posts
    1,267
    0 Did you find this post helpful? Yes

    Default 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
    "The whole problem with the world is that fools and fanatics are always
    so certain of themselves, and wiser people so full of doubts."
    Bertrand Russell

  6. #16
    Member
    Join Date
    2012-10
    Posts
    4
    0 Did you find this post helpful? Yes

    Default 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.

  7. #17
    AUGI Addict fixo's Avatar
    Join Date
    2005-05
    Location
    Pietari, Venäjä
    Posts
    1,267
    0 Did you find this post helpful? Yes

    Default Re: excel data to draw line in autocad.

    Well, if I will be in the good condition,
    "The whole problem with the world is that fools and fanatics are always
    so certain of themselves, and wiser people so full of doubts."
    Bertrand Russell

  8. #18
    I could stop if I wanted to
    Join Date
    2006-03
    Location
    Midland, MI
    Posts
    358
    0 Did you find this post helpful? Yes

    Default Re: excel data to draw line in autocad.

    Quote Originally Posted by fixo View Post
    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!

  9. #19
    AUGI Addict fixo's Avatar
    Join Date
    2005-05
    Location
    Pietari, Venäjä
    Posts
    1,267
    0 Did you find this post helpful? Yes

    Default Re: excel data to draw line in autocad.

    Quote Originally Posted by Darren Allen View Post
    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
    "The whole problem with the world is that fools and fanatics are always
    so certain of themselves, and wiser people so full of doubts."
    Bertrand Russell

  10. #20
    Member
    Join Date
    2013-02
    Location
    Kolkata, India
    Posts
    7
    0 Did you find this post helpful? Yes

    Angry 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
    Attached Files Attached Files

Page 2 of 4 FirstFirst 1234 LastLast

Similar Threads

  1. use excel data to draw
    By santhoshi.civil114776650 in forum AutoCAD General
    Replies: 11
    Last Post: 2012-11-06, 08:35 AM
  2. import text and data from excel into autocad
    By elipman in forum AutoCAD General
    Replies: 4
    Last Post: 2008-12-22, 07:04 PM
  3. Replies: 1
    Last Post: 2007-10-23, 09:40 AM
  4. Replies: 2
    Last Post: 2007-08-25, 02:35 AM
  5. Bring Excel data in AutoCAD drawings
    By cosnobum02 in forum AutoCAD General
    Replies: 8
    Last Post: 2006-10-18, 04:34 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •