• Industries
  • Products
  • Buy
  • Services & Support
  • Communities
  • Discussion Groups

    Autodesk Inventor

    Reply
    Member
    Posts: 3
    Registered: ‎04-27-2012

    How to export coordinates x,y,z from .ipt to .xls

    194 Views, 2 Replies
    02-14-2013 05:16 AM

    I have a 3D part that produced from an assembly document. (pic.1)

    How can I take the coordinates of the curve that is designed on the right surface (pic.2) in a .txt or better .xls file ? 

    That curve I want to draw it in Excel.

     

    It would be helpful if having vba programming solution.

    Please use plain text.
    *Expert Elite*
    ScottMoyse
    Posts: 1,278
    Registered: ‎06-10-2009

    Re: How to export coordinates x,y,z from .ipt to .xls

    02-15-2013 07:57 PM in reply to: dvakondios

    There are tools in existence which do this already, but so far as I know they all use sketch points & export them to csv.

     

    You may need to place the points manually. I would imagine this would be extremely difficult to automate via the API given the number of potential variations from one set of geometry to the next. But I'm as far as it gets from being an expert in programming.

     

    http://usa.autodesk.com/adsk/servlet/ps/dl/item?siteID=123112&id=17366925&linkID=9242018

     

    http://modthemachine.typepad.com/my_weblog/2011/06/writing-work-points-to-an-excel-file.html

    Cheers
    Scott Moyse

    Please use Mark Solutions!.Accept as Solution &Give Kudos!Kudos to further enhance the value of these forums. Cheers!


       

    Please use plain text.
    Valued Contributor
    cean_au
    Posts: 100
    Registered: ‎07-11-2011

    Re: How to export coordinates x,y,z from .ipt to .xls

    02-16-2013 03:10 PM in reply to: dvakondios

    You could try to iterate through all the surfaces and export thier vertixes with programming.

    Please use plain text.