Linking Inventor with Excel

A customer called in earlier this week wanting to link Autodesk Inventor with a Microsoft Excel spreadsheet. In other words, driving the value of a dimension inside of Inventor with a value from an Excel sheet. There are 2 possibilities here, using either a direct link with Excel between files or using iLogic.

In this example, we will step through the process using a simple parameter link.

Firstly, create an Excel spreadsheet containing your desired values. I have kept things simple here:

Excel Sheet for Linking to Inventor

Now head over into Inventor, we are to use a simple box to show this example. So create yourself a new part, and head straight over into the parameters screen before creating any geometry:

Inventor Parameters Screen

Choose ‘Link’ in the lower right hand corner. Browse to your Excel file and choose to link and now embed the file. By embedding, it would insert the excel data into the Inventor part. By linking, we are creating a live link between the two files:

Linking Inventor with Excel

Depending on the formatting of your Excel sheet, you may get a warning that you can ignore. This is down to Inventor not understanding that there are titles above the values in the spreadsheet:

Inventor Parsing Error

You will not be able to see parameters have been created from the Excel Spreadsheet. Actually, these are still being pulled live from Excel which you can see by looking at the fact they are hosted by the Excel file still:

Excel Parameter Values in Inventor

At this point, start modelling. When you want to create a link between dimension and Excel, simply enter the name of the parameter as the dimension value. For example, we create a sketch on the front plane and add a dimension for the width and length of the part:

Width Dimension
Adding Width and Length Dimensions

We finish the sketch and use the same functionality for the height of the component:

Height Component

We are left with, in this example, a box which is fully linked to Excel:

Inventor Box Linked with Excel

Here are the parameters for reference:

Inventor Parameters

If you open the Excel file again, make a change followed by saving the file, Inventor will prompt an update and change your dimensions to suit:

Excel Parameter Values
Inventor Update Dimensions

On updating the Inventor model, your Excel changes are pulled into the model, and everything updates automatically:

Inventor Pulls Linked Excel Values in to Model

And that is it! A simple example, but very scalable for your own requirements. Keep your eyes peeled for the follow up blog using iLogic to perform the same functionality, and if you’d like any more information on this blog post, please complete the below form:

Related Links
Autodesk Inventor – Autodesk Platinum Partner | Man and Machine

Autodesk Inventor Training Courses | Man and Machine

Previous

AutoCAD Dynamic Blocks – What, Why & How??

New Solibri Release – Solibri Model Checker

Next

Click here to view all of our blog posts