+ Reply to Thread
Page 1 of 4 1 2 3 ... LastLast
Results 1 to 10 of 35
  1. #1
    Full Member
    Using
    AutoCAD 2006
    Join Date
    Nov 2009
    Posts
    30

    Default Read Excel Data Cells and Draw in AutoCAD thru LISP

    Hi All,
    Need to work out a LISP Routine which prompts the user to open an Excel File and read the data from the used cells of Excel to create a drawing in AUTOCAD depending upon the Excel Cells' Data...

    Please do help in context to the above mentioned subject...

  2. #2
    Super Member fixo's Avatar
    Computer Details
    fixo's Computer Details
    Operating System:
    Windows 7
    Motherboard:
    E7500
    CPU:
    Intel(R)Core(TM)2 DUO CPU 2.93HGz
    RAM:
    4098 Gb
    Graphics:
    1024 Gb
    Using
    AutoCAD 2009
    Join Date
    Jul 2005
    Location
    Pietari, Venäjä
    Posts
    1,687

    Default

    Quote Originally Posted by NHM View Post
    Hi All,
    Need to work out a LISP Routine which prompts the user to open an Excel File and read the data from the used cells of Excel to create a drawing in AUTOCAD depending upon the Excel Cells' Data...

    Please do help in context to the above mentioned subject...
    Grab function EXD from this page:
    http://www.cadtutor.net/forum/showth...light=topo.lsp

    ~'J'~
    The soul is healed by being with children. - Fyodor Dostoyevsky, novelist (1821-1881)

  3. #3
    Full Member
    Using
    AutoCAD 2006
    Join Date
    Nov 2009
    Posts
    30

    Default

    Thanks fixo....
    I still need to work out the data from Excel Cells to Draw Beam Sizes as well as laying Reinforcement in it with specific Layer Properties and Linetype as well as Pline width all incorporated (all fed in Excel Data Sheet itself) to complete the longitudnal section of the Beam along with Reinforcement.... I would not want it to get converted into a BLOCK....

  4. #4
    Super Member fixo's Avatar
    Computer Details
    fixo's Computer Details
    Operating System:
    Windows 7
    Motherboard:
    E7500
    CPU:
    Intel(R)Core(TM)2 DUO CPU 2.93HGz
    RAM:
    4098 Gb
    Graphics:
    1024 Gb
    Using
    AutoCAD 2009
    Join Date
    Jul 2005
    Location
    Pietari, Venäjä
    Posts
    1,687

    Default

    Quote Originally Posted by NHM View Post
    Thanks fixo....
    I still need to work out the data from Excel Cells to Draw Beam Sizes as well as laying Reinforcement in it with specific Layer Properties and Linetype as well as Pline width all incorporated (all fed in Excel Data Sheet itself) to complete the longitudnal section of the Beam along with Reinforcement.... I would not want it to get converted into a BLOCK....
    All these stuffs are very difficult for my understanding -
    but the task is very interesting
    Please, attach your sample drawing with beam and
    also the Excel sheet (just one row of this beam data)
    Hope I could be able to help
    Or maybe somebody from here knows
    the exact solution

    Cheers :0)

    ~'J'~
    Last edited by fixo; 11th Nov 2009 at 01:12 pm. Reason: spell check
    The soul is healed by being with children. - Fyodor Dostoyevsky, novelist (1821-1881)

  5. #5
    Full Member
    Using
    AutoCAD 2006
    Join Date
    Nov 2009
    Posts
    30

    Default

    I shall do the pre requisite in some time from now...

    Thanks for offering help...
    Shall mail the sample dwg as well as excel data file...

  6. #6
    Super Member fixo's Avatar
    Computer Details
    fixo's Computer Details
    Operating System:
    Windows 7
    Motherboard:
    E7500
    CPU:
    Intel(R)Core(TM)2 DUO CPU 2.93HGz
    RAM:
    4098 Gb
    Graphics:
    1024 Gb
    Using
    AutoCAD 2009
    Join Date
    Jul 2005
    Location
    Pietari, Venäjä
    Posts
    1,687

    Default

    Quote Originally Posted by NHM View Post
    I shall do the pre requisite in some time from now...

    Thanks for offering help...
    Shall mail the sample dwg as well as excel data file...
    You can use "Manage Attachments" button below

    Or you can send the PM to me

    ~'J'~
    The soul is healed by being with children. - Fyodor Dostoyevsky, novelist (1821-1881)

  7. #7
    Full Member
    Using
    AutoCAD 2006
    Join Date
    Nov 2009
    Posts
    30

    Default Attachments

    Hi Fixo,
    here is the model excel data file with cells filled from where data is to be read and model drawing based on this data to be drawn in AutoCAD.... Worth mentioning that Layer Properties and other Drafting settings can be developed in AutoCAD itself...
    Attached Files
    Last edited by NHM; 11th Nov 2009 at 02:24 pm. Reason: One attachment left out for editing

  8. #8
    Super Member fixo's Avatar
    Computer Details
    fixo's Computer Details
    Operating System:
    Windows 7
    Motherboard:
    E7500
    CPU:
    Intel(R)Core(TM)2 DUO CPU 2.93HGz
    RAM:
    4098 Gb
    Graphics:
    1024 Gb
    Using
    AutoCAD 2009
    Join Date
    Jul 2005
    Location
    Pietari, Venäjä
    Posts
    1,687

    Default

    Quote Originally Posted by NHM View Post
    Hi Fixo,
    here is the model excel data file with cells filled from where data is to be read and model drawing based on this data to be drawn in AutoCAD.... Worth mentioning that Layer Properties and other Drafting settings can be developed in AutoCAD itself...
    Ok, I will try to finish it at tomorrow only

    ~'J'~
    The soul is healed by being with children. - Fyodor Dostoyevsky, novelist (1821-1881)

  9. #9
    Super Member fixo's Avatar
    Computer Details
    fixo's Computer Details
    Operating System:
    Windows 7
    Motherboard:
    E7500
    CPU:
    Intel(R)Core(TM)2 DUO CPU 2.93HGz
    RAM:
    4098 Gb
    Graphics:
    1024 Gb
    Using
    AutoCAD 2009
    Join Date
    Jul 2005
    Location
    Pietari, Venäjä
    Posts
    1,687

    Default

    Quote Originally Posted by NHM View Post
    Hi Fixo,
    here is the model excel data file with cells filled from where data is to be read and model drawing based on this data to be drawn in AutoCAD.... Worth mentioning that Layer Properties and other Drafting settings can be developed in AutoCAD itself...
    One more question...
    I did not found in Excel the diameter of supports
    Is it always will be equal to 1?

    ~'J'~
    The soul is healed by being with children. - Fyodor Dostoyevsky, novelist (1821-1881)

  10. #10
    Super Member fixo's Avatar
    Computer Details
    fixo's Computer Details
    Operating System:
    Windows 7
    Motherboard:
    E7500
    CPU:
    Intel(R)Core(TM)2 DUO CPU 2.93HGz
    RAM:
    4098 Gb
    Graphics:
    1024 Gb
    Using
    AutoCAD 2009
    Join Date
    Jul 2005
    Location
    Pietari, Venäjä
    Posts
    1,687

    Default

    Registered forum members do not see this ad.

    Attached is what I've ended up my work on today with
    (just a sketch only)
    I need your opinion

    ~'J'~
    Attached Files
    The soul is healed by being with children. - Fyodor Dostoyevsky, novelist (1821-1881)

Similar Threads

  1. How to import Excel x,y,z data into AutoCAD
    By sjm in forum AutoCAD Drawing Management & Output
    Replies: 24
    Last Post: 16th Nov 2012, 09:35 pm
  2. Writing LISP Data to an External Program (such as Excel/Notepad...etc)
    By Lee Mac in forum AutoLISP, Visual LISP & DCL
    Replies: 8
    Last Post: 15th Dec 2008, 05:43 pm
  3. Cannot move cells in table from data extraction
    By SuperCAD in forum AutoCAD Drawing Management & Output
    Replies: 0
    Last Post: 24th Sep 2008, 10:39 pm
  4. Excel data sheets into Autocad
    By Milner in forum AutoCAD Drawing Management & Output
    Replies: 1
    Last Post: 11th Aug 2005, 05:39 pm
  5. coordinates form excel cells to an autocad drawing
    By sTixi in forum AutoCAD Drawing Management & Output
    Replies: 1
    Last Post: 29th Jun 2005, 10:32 pm

Bookmarks

Posting Permissions

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