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
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?
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.
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?
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?
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 ?
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 RUclips 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
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.
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.
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.
@@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
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!
@@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
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
Хобби
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
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?
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.
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?
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?
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 ?
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 RUclips 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
Hello, how can I suppress from excel??? Please
how to add inventor build option in excel
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.
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.
@@3DSteve52 Thank you for the reply, the spaces were the problem.
How do you add text into inventor? Thanks!
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.
@@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
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!
@@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
update is not showing any changes
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
@@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.
@@abdulansari2007 I am glad that you figured it.