Source: Autodesk Inventor
You can import points from a Microsoft® Excel spreadsheet into a 2D sketch, 3D sketch, or drawing sketch. You can use the points to represent items such as inspection points, locations for spot welds, and points on a spline.
The points are automatically created in the sketch according to the coordinates specified in the spreadsheet. The origin of the sketch is used as the origin for the imported point data.
Keep in mind that the points are not associative. A geometry that is based on the points will not be updated if the points are moved or deleted.
The Excel file containing the points should be in the following format:
- The table of points must be in the first worksheet of the Excel file.
- The table always starts at cell A1.
- If the first cell (A1) contains a unit of measure, it is applied to all the points in the spreadsheet. If no unit is specified, the default file units are used.
- Columns are defined as follows:
- Column A is for X coordinates
- Column B is for Y coordinates
- Column C is for Z coordinates
- If the spreadsheet contains Z axis values, only X and Y axis values are imported into a 2D sketch.
- Cells can contain a formula, but the result of the formula must be a numeric value.
To import points into a sketch
- On the Sketch panel bar, click the Import Points icon.
- On the Standard toolbar, click the Point/Center Point tool to specify either sketch points or center points.
- In the Open dialog box, browse to the folder where the spreadsheet is located, select the spreadsheet, and click Open.
In this tutorial we will learn how to import points from Excel to Autodesk Inventor. You can download the Excel points from this link.
Autodesk Inventor – Move & Rotate
When you constrain or join assembly components to one another, you control their position. To move or rotate a component, either temporarily or permanently, use one of the following methods:
Autodesk Inventor – Scale Assembly
One of the new features in Inventor is the ability to scale your models. You might be wondering, why didn’t Inventor have this ability prior to the release?
Do you want to learn Ansys Design Modeler?.
Related Articles
Autodesk Inventor – Scale
One of the new features in Inventor is the ability to scale your models. You might be wondering, why didn’t Inventor have this ability prior to the release?
Autodesk Inventor – 2D Sketch / Constraints
The idea that geometry within Autodesk Inventor behaves differently due to the application of constraints often hinders new users transitioning from a 2D drawing application.
Autodesk Inventor uses constraints in two primary ways:
2D and 3D sketch constraints control geometry within sketches
Assembly constraints and joints establish relationships between components in an assembly that control position and behavior.
Autodesk Inventor – Revolve
There are two ways to created revolved features: from a sketch profile or from a primitive. The primitive shape creation commands create full revolutions only.
Stay Up to Date With The Latest News & Updates
Help us keep growing
CFD.NINJA is financed with its own resources, if you want to support us we will be grateful.
Join Our Newsletter
Subscribe to receive emails with detailed information related to the CFD.
Follow Us
Subscribe to our social networks to receive notifications about our new tutorials