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
    Login to Give a bone
    0

    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,269
    Login to Give a bone
    0

    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

  3. #13
    AUGI Addict fixo's Avatar
    Join Date
    2005-05
    Location
    Pietari, Venäjä
    Posts
    1,269
    Login to Give a bone
    0

    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

  4. #14
    Member
    Join Date
    2012-10
    Posts
    4
    Login to Give a bone
    0

    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,269
    Login to Give a bone
    0

    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

  6. #16
    Member
    Join Date
    2012-10
    Posts
    4
    Login to Give a bone
    0

    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,269
    Login to Give a bone
    0

    Default Re: excel data to draw line in autocad.

    Well, if I will be in the good condition,

  8. #18
    I could stop if I wanted to
    Join Date
    2006-03
    Location
    San Cristobal, Guatemal
    Posts
    439
    Login to Give a bone
    0

    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,269
    Login to Give a bone
    0

    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

  10. #20
    Member
    Join Date
    2013-02
    Location
    Kolkata, India
    Posts
    7
    Login to Give a bone
    0

    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: 13
    Last Post: 2017-05-15, 02:36 AM
  2. Replies: 13
    Last Post: 2014-07-01, 02:23 PM
  3. Bring data to Excel from AutoCAD
    By cparvez in forum Dot Net API
    Replies: 1
    Last Post: 2014-05-27, 08:46 PM
  4. Replies: 4
    Last Post: 2014-01-01, 07:58 PM
  5. import text and data from excel into autocad
    By elipman in forum AutoCAD General
    Replies: 4
    Last Post: 2008-12-22, 08:04 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
  •