IMPORTING POINTS FROM EXCEL TO INVENTOR

[khushank.ks]

I want to import several points into inventor from excel.

The points in my excel spreadsheet are such that two consecutive rows contain the two end points of a line and the next two rows contain coordinates for another line.

Like:

1 2

3 4

2 3

5 6

Here, (1,2) and (3,4) are the end points of one line; (2,3) and (5,6) are the end points of the other line.

But when i import this into inventor, instead of making two separate lines, it connects all the points together.

How can it be done? 

[johnsonshiue]

Hi! I think this will have to be done via iLogic rule or VBA. There should be sample code for you to reference. Please take a look at the Solution#3 in below thread. You can add some code to create lines based on the points. Make sure you skip every two rows. to create a line.

https://knowledge.autodesk.com/support/inventor-products/learn-explore/caas/sfdcarticles/sfdcarticle...

Many thanks!

[khushank.ks]

This file does not load in the VBA editor.

It keeps on showing "No open projects".

[Xun.Zhang]

@khushank.ks,

Here is an example for VBA to handle import point and make a spline though them all.

Hope it helps a little bit.

Sub CreateOneSpline()
    Dim oDoc As PartDocument
    Set oDoc = ThisApplication.ActiveDocument
    
    Dim oSk3d As Sketch3D
    Set oSk3d = oDoc.ComponentDefinition.Sketches3D(1)
    
    Dim oPoints As ObjectCollection
    Set oPoints = ThisApplication.TransientObjects.CreateObjectCollection
    Dim oPt As SketchPoint3D
    For Each oPt In oSk3d.SketchPoints3D
        oPoints.Add oPt
    Next
    
    Dim oNewSk3d As Sketch3D
    Set oNewSk3d = oDoc.ComponentDefinition.Sketches3D.Add
    
    Dim oSkSpline3d As SketchSpline3D
    Set oSkSpline3d = oNewSk3d.SketchSplines3D.Add(oPoints, kSmoothSplineFit)
End Sub 

[S_May · Accepted solution]

Hi @khushank.ks,

You can practice with this...