No video

Linking Inventor Parameters to Excel

  Рет қаралды 23,168

3DSteve

3DSteve

Күн бұрын

This video demonstrates how to add some automation to your Inventor Assembly by linking part parameters to an Excel file.

Пікірлер: 21
@mattremington6492
@mattremington6492 Ай бұрын
Hi, is there any possibility to add parameters from Excel and stop updating them (like turning off "Link to external file" in Solidworks equations)? I want to download data from xls only once and never update it again
@adventurefilms
@adventurefilms 5 ай бұрын
How do you deal with renaming a parameter? Currently, if you rename a parameter and save, Inventor leaves the old name parameter in the parameters list, (but highlighted yellow), and adds the newly renamed parameter in at the bottom of the parameters list. Is there any way to make Inventor just rename the existing parameter to the new one?
@jasonconstant455
@jasonconstant455 Жыл бұрын
That column format (each parameter is its own Row is very strange and even Inventor iParts uses row format in Excel (each parameter is its own column). Does it only support this format?
@abouteverything2115
@abouteverything2115 Жыл бұрын
Hi. I've been trying to find a way to link an Excel file to an assembly (say assembly X) in a way that the parameters get inherited by any part or assembly created under Assembly X. It makes sense doesn't it? You want all your subassembly items to know what the 'assembly_base_width' is. It is quite annoying when you create a part under the assembly and try to use a parameter, just to find out that the parameter is not there, and you have to link the Excel file again. Any idea?
@steveolson8283
@steveolson8283 Жыл бұрын
I think you would have two options. First, link the same parameter spreadsheet to each component in the design. Secondly, you could use iLogic to pass parameters from the assembly down into the subcomponents. This approach does require the subcomponent to have a parameter to receive the value. There is a way to export and import parameters using iLogic too. That might offer an interesting approach to generating the necessary parameter in the subcomponents. Then use iLogic to distribute the necessary parameters to the subcomponents. Hope this helps.
@rihabmaaloul7697
@rihabmaaloul7697 2 жыл бұрын
hey, is it possible to export Inventor Parameters to Excel and not the opposite ? I already added parameters in Inventor (not aware of the Excel option) and I have to do a list of every Parameter I have and I have plenty of them.. is there a possibility to expor them ?
@3DSteve52
@3DSteve52 2 жыл бұрын
It is possible to export them to an XML file, but I don't believe that you can bring that right into an Excel file. You can set up an iLogic rule that will read and write to Excel, I have other KZfaq videos that show that process. Those seem to be the closest I can get to what you are looking for. If you have an example of what you want, I would be happy to look at that for you. You can email me at steve.olson@mesa-cad.com
@onlysanepersonleft
@onlysanepersonleft 10 ай бұрын
Hello. Inventor does not display any values or parameter names in the Parameters box. It shows the file after I link it but there is no dropdown showing any parameters from the excel spreadsheet.
@3DSteve52
@3DSteve52 10 ай бұрын
If you have linked to the Excel file, you should see the line that shows the linked Excel file at the bottom of the Parameter dialog box. If you see the file without any parameters, you may have named the parameters using invalid characters. You can't use spaces, which is the most common invalid character. If that is not the case, check the Start Cell setting, to make sure you are starting in the first cell you want. If it sees a blank row, it stops reading values. I hope this helps.
@onlysanepersonleft
@onlysanepersonleft 10 ай бұрын
@@3DSteve52 Thank you for the reply, the spaces were the problem.
@anilkumarh1015
@anilkumarh1015 5 ай бұрын
how to add inventor build option in excel
@omaro1910
@omaro1910 5 ай бұрын
Hello, how can I suppress from excel??? Please
@LealLens
@LealLens Жыл бұрын
How do you add text into inventor? Thanks!
@steveolson8283
@steveolson8283 Жыл бұрын
Are you looking to create a text parameter or insert text into a sketch so you can emboss it? If you are looking to engrave or emboss text, you should create a sketch and use the Text command to add your text. From there you can use the Emboss or Mark commands. If you are looking to add a text parameter, there is a Text Parameter type under the Numeric option at the bottom of the Parameter dialog box. I hope this helps.
@LealLens
@LealLens Жыл бұрын
@@steveolson8283 hi there, no no, I wanted to import a text parameter say: Type on A1 and on B2 I wanted it to say B So that in reference it would reference between two types of models like Plate type A and plate type B. Thanks you nevertheless
@LealLens
@LealLens Жыл бұрын
Would you by any chance know how to export break line dims onto excel through a sheet metal model or in sheet metal flat model mode? For example an L shape piece. At its flat state you can see the major bend line. That bend line to us like a referred to as a break line. It’s what is used to know how far inward a tool needs to be to bend bend the part properly. I just need the bend line dim exported in excel. I haven’t had much luck exporting a basic dim through flat model state or anything. I can only think of creating a drawing and applying a dim there and then making a table that I can extract but the drawing would just add more steps. Thanks for the reply!
@steveolson8283
@steveolson8283 Жыл бұрын
@@LealLens If you got to the flat pattern, you should be able to create a sketch that represents the break line dimension you need. It will be a Driven dimension, that just means that Inventor will control its value. That parameter then can be written to Excel with a little bit of iLogic. I hope this helps, Steve
@abdulansari2007
@abdulansari2007 11 ай бұрын
update is not showing any changes
@3DSteve52
@3DSteve52 11 ай бұрын
If you are not seeing any change to the model, you will want to make sure you have done a couple of things. First, make sure you save the Excel file. The system see the modified time stamp an recognizes a change to the file. Secondly, make sure that the parameters you linked into the model are used by the dimensions of a sketch or feature. Lastly, make sure you don't have a local update, lightning bolt icon, that needs to be carried out. Let me know if you still have an issue after verifying that you have taken care of the items I listed above. Thanks, Steve
@abdulansari2007
@abdulansari2007 11 ай бұрын
@@3DSteve52many thanks for your response. yes i figured it out that I linked excel file with multiple worksheets and changed the values in wrong one.
@3DSteve52
@3DSteve52 11 ай бұрын
@@abdulansari2007 I am glad that you figured it.
iLogic For Beginners #2: Introduction to GoExcel
5:08
Automation With iLogic
Рет қаралды 15 М.
Tutorial Inventor - 151 iLogic for Assemblies
33:21
Constantin Stancescu
Рет қаралды 20 М.
а ты любишь париться?
00:41
KATYA KLON LIFE
Рет қаралды 3,6 МЛН
OMG what happened??😳 filaretiki family✨ #social
01:00
Filaretiki
Рет қаралды 13 МЛН
Zombie Boy Saved My Life 💚
00:29
Alan Chikin Chow
Рет қаралды 29 МЛН
Magic trick 🪄😁
00:13
Andrey Grechka
Рет қаралды 57 МЛН
Linking Parameters Between Inventor Files
8:40
3DSteve
Рет қаралды 13 М.
iLogic: Building Assemblies from an Excel Sheet | Autodesk Virtual Academy
57:54
Inventor Parameter mit Excel steuern
10:03
Jörg Weber
Рет қаралды 5 М.
Use Excel lists to fill out Multi-Value lists in Inventor
6:28
Synergis Engineering Design Solutions
Рет қаралды 5 М.
Autodesk Inventor - Configured Design Tutorial | Excel Linking And Embedding
5:17
O'Reilly - Video Training
Рет қаралды 20 М.
Quick Inventor Tip : Parameter & Equations
4:42
Lars Christensen
Рет қаралды 45 М.
iLogic - Adding Rules to a Drawing
30:51
Synergis Engineering Design Solutions
Рет қаралды 19 М.
Autodesk Inventor Parameters & iLogic - Part1
17:47
CAD for Mechanical Industry
Рет қаралды 14 М.
а ты любишь париться?
00:41
KATYA KLON LIFE
Рет қаралды 3,6 МЛН