+ Reply to Thread
Results 1 to 10 of 10
  1. #1
    Full Member
    Using
    AutoCAD 2007
    Join Date
    Mar 2011
    Posts
    25

    Default autocad excel coordinate to excel

    Registered forum members do not see this ad.

    KAMÇİZ.dwg
    I request you to have a function similar to that of the macro attached. However, your request is appended in the macro kamçiz.dwg painting yellow lines and red color (the cam determines the limit) of the line intersection points (with a circle mark, technical illustration, I wanted to specify that) automatically determine the value of these points automatically revised to an Excel file, can you throw? I would like to wait for your assistance regards to this issue valuable. Excel format may be appendedDid he kamçiz.xls? this cam should be in the drawing of the coordinate values ​​kamçiz.xls file again presented.
    Last edited by ses4; 10th Apr 2011 at 10:55 am.

  2. #2
    Forum Deity Organic's Avatar
    Discipline
    Civil
    Using
    AutoCAD 2015
    Join Date
    Feb 2009
    Posts
    2,206

    Default

    I think you might need to be clearer about what exactly you wish to achieve.

  3. #3
    Full Member
    Using
    AutoCAD 2007
    Join Date
    Mar 2011
    Posts
    25

    Default

    the exact coordinates of the points I want to get from the content of autocad windows in order to transfer an excel file.
    yellow painted lines kamçiz.dwg file excel file in a sequence that transfers the coordinates of end points for a macro solution P0 istiyorum.İlk marked with the final value of the values ​​which must be marked with the P359.

  4. #4
    Full Member
    Using
    AutoCAD 2007
    Join Date
    Mar 2011
    Posts
    25

    Default excel coordinate

    KAMÇİZ.dwg
    yellow painted lines kamçiz.dwg file excel file in a sequence that transfers the coordinates of end points I would like a macro solution. The first value is marked with the final value P0 of the values ​​must be marked with the P359.
    In addition, only these are attached in a similar macro excel macro in order to transfer the data should be used.
    http://rapidshare.com/files/456862686/PointList.dvb
    Last edited by ses4; 11th Apr 2011 at 06:20 am.

  5. #5
    Full Member
    Using
    AutoCAD 2007
    Join Date
    Mar 2011
    Posts
    25

    Default

    please help me this issue!
    Quote Originally Posted by ses4 View Post
    Attachment 26958
    yellow painted lines kamçiz.dwg file excel file in a sequence that transfers the coordinates of end points I would like a macro solution. The first value is marked with the final value P0 of the values ​​must be marked with the P359.
    In addition, only these are attached in a similar macro excel macro in order to transfer the data should be used.
    http://rapidshare.com/files/456862686/PointList.dvb

  6. #6
    Forum Deity Organic's Avatar
    Discipline
    Civil
    Using
    AutoCAD 2015
    Join Date
    Feb 2009
    Posts
    2,206

    Default

    I am still unclear as to what you exactly want.

    Looking at the macro and drawing, try contacting
    Code:
    'Suphi TUNALI
    'Survey & Civil Technician
    'TGO (Tekfen-Gama) Ltd.
    'Maritza East-I Power Plant Project
    'AES-3C Maritza East-I TPP Site Office
    'Industrial Region 6280 Galabovo Bulgaria
    'Tel   : ++ 359 42 900100
    'Fax   : ++ 359 42 900197
    'Gsm   : ++ 359 897 971995
    'Email : suphit@gmail.com
    '        suphi@tgo-bg.com
    'Web   : http://www.maritza-photos.blogspot.com/
    who seems to be the author of the macro (unless that is you).

  7. #7
    Full Member
    Using
    AutoCAD 2007
    Join Date
    Mar 2011
    Posts
    25

    Default

    Dear Sir
    I have connected Mr.Tunalı He hasn't replied.
    To clarify what I want to do exactly.P0 is the highest value and P359 is lowest.When the drawing is chosen in a window and macro is running,we want to value to be exported in to excel (from P0 To P359 in a row)

    for example

    excel file adding

    http://rapidshare.com/files/456875969/kam__iz.xls

  8. #8
    Senior Member
    Using
    AutoCAD 2010
    Join Date
    Feb 2011
    Posts
    108

    Default

    http://www.cadtutor.net/forum/showth...619#post383619

    I posted a script in the above thread that I think does what you're looking for with the exception that it deals with blocks. It should get you started.
    Give a man a solution and he'll become more efficient at a single task. Give a man the tools required for a solution and he can fix a shelf later.

  9. #9
    Full Member
    Using
    AutoCAD 2007
    Join Date
    Mar 2011
    Posts
    25

    Default

    Quote Originally Posted by SOliver View Post
    http://www.cadtutor.net/forum/showth...619#post383619

    I posted a script in the above thread that I think does what you're looking for with the exception that it deals with blocks. It should get you started.
    I do not get the result I want to give to your page with AutoLISP.

    I wonder if I wanted to write code to help me in this regard would be grateful if the coordinates of the points I have to choose only one hand.
    Last edited by ses4; 11th Apr 2011 at 12:41 pm.

  10. #10
    Full Member
    Using
    AutoCAD 2007
    Join Date
    Mar 2011
    Posts
    25

    Default

    Registered forum members do not see this ad.

    Please edit this as I want, not lisp blocks Could you put here?
    http://rapidshare.com/files/456875969/kam__iz.xls
    http://rapidshare.com/files/456862686/PointList.dvb
    KAMÇİZ.dwg

    Function;
    - Before you ask us to pick the circle
    - Then spline object (cam cross-section) to be selected
    - we chose the center of the circle as the origin of the coordinate system to take
    - y axis of the spline to be cut off since the peak
    - Clockwise (clockwise) for every 1 degree of scrolling through an imaginary line
    - Locate the point of intersection with this line, spline
    - x and y coordinates with point number to write to the file
    Last edited by ses4; 11th Apr 2011 at 06:37 pm.

Similar Threads

  1. excel to autocad
    By fbby in forum AutoLISP, Visual LISP & DCL
    Replies: 30
    Last Post: 26th Dec 2010, 03:28 pm
  2. Coordinate from excel to autocad
    By rick_belial in forum AutoCAD Drawing Management & Output
    Replies: 7
    Last Post: 15th Nov 2007, 03:19 pm
  3. Excel to AutoCAD
    By homer in forum AutoCAD Beginners' Area
    Replies: 10
    Last Post: 4th Oct 2007, 12:16 pm
  4. AutoCAD lt to excel
    By ollylandandwater in forum AutoCAD Beginners' Area
    Replies: 3
    Last Post: 23rd Mar 2007, 10:24 pm
  5. autocad to excel
    By magre17 in forum AutoLISP, Visual LISP & DCL
    Replies: 5
    Last Post: 15th Dec 2005, 07:59 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