in inventor 2009: i linked parameter of 3D design from excel file. If i change the value on excel file --> dimension of 3D design will change. It work fine.
So, in inventor 2011, i can not do it: when change the value on excel file, 3D model does not change dimension.
Trying to place this .xls file into my idw. Does not work too well. Part of the worksheet is cropped off and the images are out of place.
Here is what I'm getting.
Is there a way to get this to show on the drawing. I am using the Manage>Insert Object command.
I have an assembly that I have created a sketch on and applied some dimensions. I would like to send those properties to an excel file that can then be inserted into an idw. What is the best way to get the parameter values into an excel file that would update as the model changes? I found were more focused on changing the model with the excel sheet which is not what I'm trying to do. I did try them however, but whether I clicked link or embed nothing appeared in the excel file at all.
View 2 Replies View Related
I have a Multi-Value Parameter "MV" that I want to populate using a Named Range from an Excel file that is already populating other parameters for the same file.
I currently have the file working by populating "MV" by using the snippet from iLogic below...
MultiValue.List("MV") = GoExcel.CellValues("filename.xls", "Sheet1", "A2", "A10")
The reason I don't like this method is because if ever that range changes... all the iLogic code will have to be updated as well. How to set a Multi-Value Parameter using a Named Range from an Excel file? I assumed the below snippet would work but I am receiving
"Array was not a one-dimensional array." as an error.
MultiValue.List("MV")=GoExcel.NamedRangeValue("Named_Range_Value")
I have a MultiValue Parameter that I want to populate using a named range from an embedded excel spreadsheet. I would like an iLogic solution if possible because I need other people to be able to understand the code without too much difficulty.
One of the sample snippets given allows access but not if the excel file is embedded.
'GoExcel.NamedRangeValue("Part_Width")
The code below works but not when using a named range.
' Load bearing housing typesMultiValue.List("parameter1") = GoExcel.CellValues("A1","A20")
Is there something I'm missing? I was hoping to use something like below
' Populate MultiValue Parameter from excelMultiValue.List("parameter1") = GoExcel.CellValues("3rd Party:Embedding 4", "Sheet", "myNamedRange")
I have a set of sheet metal parts modeled in inventor that are produced in a wide range of sizes and several different sheet metal types.
The dimensions (length, width, flange size, etc) are driven from a spreadsheet. I would like to be able to have the user update the K Factor from the same spreadsheet by selecting a sheet metal type.
The sheet metal type and K factor are not listed in the parameters list with the other model dimensional data, so I'm not sure how to proceed.
I'm trying to get a parameter value from an Inventor .dwg file, but I keep getting an error saying the file is not found. I use this same code all over the place between different parts but its the first time I'm tried it using a dwg. Can you not access an Inventor .dwg parameters using iLogic .
MsgBox(Parameter(ThisDoc.Path & "MyDrawing.dwg", "Customer"))
I created a *.iam file. And from this asembly file, I need run some rules in *.ipt file.
I use
Parameter("PartA:1", "d12") = d12
to give d12 parameter in my assembly to d12 parameter in *.ipt. It works.
But I need get parameter in the *.ipt file after running the rules in *.ipt.
so, I put
d13 = Parameter("PartA:1", "d13")
following above line.
But everytime, I just be able to get the result before *.ipt run the rules, not after.
I noticed the rules in assembly were compeletely run, then run the rules in *.ipt. So, the result is not correct.
I am using Inventor 2009 with ilogic. XP OS.
Autodesk Inventor Professional 2013 (64 Bit) SP2
Windows 7 Professional Service Pack 1
Intel(R) Xeon(R) CPU E5645
12.0 GB Memory
I'm linking an excel file to an .ipt file with iLogic code determining if the Material type is a certian value it will find the correct material thickness. These file work great when working on them thru Vault but when I "Save As Template" and create this file where our other template files are located (not Vault) this fuction does not work. I have realized that I had to place the a copy of the excel file in the same file folder as the template ipt, but even this does not fix the issue.
I recieve this error:
Error in rule: Material, in document: Part6
'MWW Materials (Inventor).xlsx' could not be found. Check the spelling of the file name, and verify that the file location is correct.
If you are trying to open the file from your list of most recently used files, make sure that the file has not been renamed, moved, or deleted.
It seems completly countintutive that just saving the file as a template file would cause this not to work when all files that are required are located in the same file folder. Maybe I need a reference to the excel document within the iLogic code.
i have deleted the excel file from the ipt file but when i open the part file it is still looking for the excel file. i am using inv 10 sp1 and excel 2000
View 7 Replies View RelatedHow do I insert an Excel spreadsheet into an AutoCAD 2011 dwg? Is it possible?
View 9 Replies View RelatedI have user parameters that are no longer needed and are not being used anywhere. They each takes 4-5 seconds to delete, prior to 2012 this would happen instantly.
IV2014 SP1 64bit
Dell Precision T7500, Geforce GTX 480, DirectX11 306.97
SpaceExplorer 4.04, 3DxWare 3.12.2
Twin Intel Xeon E5506 2.13GHz, 12GB RAM, Win7 Pro SP1 64bit
We modeled parts in inches. We save as copy to an .STL file to get SLA prototypes made. The parts came back 2.54 times bigger than needed. Reason is the default setting for saving as .STL files is Centimeters.... Not sure why Autodesk did this....but yes I understand it's not their fault, we should have checked under options and changed it to inches.....we just assumed that you model in inches, it would save as in inches....See what happens when you assume....
View 5 Replies View RelatedI'm getting this error (see attachment) when I try to open an NX file in Inventor 2011. I've downloaded the file from a data transfer site and I can preview the part in the preview window, but it does not open properly. This is the first time this has happened, as I've converted files before with no problem.
View 5 Replies View RelatedI need to convert a model parameter to a reference parameter thru the API.
I saw this item discussed in the group before, but I cant find the thread.
I link an excel spreadsheet of text into my .idw files and I constantly have this issue where the text is crowded (see attached). I've tried changing the font, etc. but nothing seems to work. Every once in a while if I move the linked sheet within the .idw it corrects itself.
I'm using Inventor 2012.
Inventor 2013
Windows 7 Professional 64-bit SP1
HP EliteBook 8470w
Processor: Intel(R) Core(TM) i7-3610QM CPU @ 2.30GHz
Memory: 16 GB
AMD FirePro M2000
3D Connexion SpacePilot
I have used the command "insert object" to embed an excel sheet. I can see in the modelbar the new stage called "3rd Party", expanded I also see "Embedding 1". If I use edit I can see my excel sheet. So far good.
My next task is to create a Rule to recall cells in the sheet. I use the command CellValue (embedded) to pick my cell value. My problem is that then I close my rule-editor I got the error:
Error in rule: Rule0, in document: Box test.ipt
GoExcel: 3rd Party worksheet not found: "3rd Party:Embedding 1", Sheet: "Sheet1"
It seems like I´m not able to recall my cellvalues.Whats the difference between embedding a excelsheet as above or use the add link command i Parameters window?
When inserting object - xls file, i found trouble, max. number of column i see in dwg file is 22.
Creating table using table - general require long time for set up every column (different with)
I have AutoCAD 2013 and often "paste special" excel files that automatically update when the excel file changes.The problem I'm running into is I work with a person who has uses an older version of CAD 2004, so I always save to the older format for him.
When I etransmit, I be sure to add the excel file, but when he opens the dwg, only the outline of the excel appears in his dwg, no content.
How to create a excel file using ilogic?
View 6 Replies View RelatedI have unchecked resolve file references, etc, and still basically spends 5 minutes looking for files i told it not to look for. Why doesnt it just open the assembly or drawing, without waiting for ever?
View 3 Replies View RelatedI got a deadline for my project, but I got a big problem:
"I cannot set the "parameter" for the End Value in Parameter Animate dialog"
For easy understand, let's see a example:
1. I got a part which has two parameters named: "A" and "MaxA"
2. I animate Favorited parameter A.
3. The End Value is MaxA_ (Everything is ok)
4. I finish Studio environment, then I change parameter MaxA_ from 200 mm to 400 mm
5. I turn back to Studio environment, the End Value now is "200 mm" (I want this will be MaxA_, so I can animate the flexible parameter).
show me how to keep the end value will be "MaxA_" after I change parameter?
A local search of my HD and a search on the subject here returned with zero results...
Where does one find the Inventor Sheet Metal Rules excel table for 2012 on a Windows 7 system?
All the documentation says it's located in the Documents and Settings directory, but Windows Vista eliminated that folder and thus it is not in Win7 either.
I can find the SheetMetalRules.xml file, but I need the excel table for modification.
I have a general table in my engineered print. It consists of basic columns with text. How can i have Inventor refresh the data if i change the Excel without having to delete and re insert a table ?
Autodesk Inventor Professional 2011
when i try to link an excel file to the parameters dialog box i get a message telling me it is "NOT IMPLEMENTED". i just upgraded to windows 7 because it is now supported by autodesk.
View 9 Replies View RelatedI am trying to link excel file to drawing file (idw), but couldn't succeed.
View 2 Replies View RelatedI linked an excel (2010) file with an inventor (2011) .ipt and none of the parameters are showing inside inventor. I was leaving the file external but I embed it also as a trouble shooting step and nothing still. I have no spaces in excel sheet. Is there something special i need to be doing inside excel or inventor?
View 5 Replies View RelatedHow do I export my IDW drawing dimensions to an Excel file for use on a First Article Inspection.
Is it even possible?
Is there any way using ilogic to find a value in an excel file and delete the column that value was found in?
View 1 Replies View Relatedi have made a iLogic Module who, whit an external rules, import the iProperties value from an external exel file.The exel file is connected from SQL with the our managerial software.This in the external rule:
i = GoExcel.FindRow("Z:DISEGNI_INVENTORDescrizioni.xls", "Descrizioni", "Cod.Art.", "=", iProperties.Value ("Project", "Part Number"))iProperties.Value ("Project", "Description") = GoExcel.CurrentRowValue("Descr. Articolo Princ.")'iProperties.Value("Project", "Project")
[Code] .....
It's work fine but i have same question. There is some string to refresh an iLogic Module? When i push the ruel button the rule add the custom value in iProperties, but there are disabled, i have close the module an reopen it for correct display the value of the iProperties.
this module work with single parts. Can I do an rule who do the same thing of my string but in one assembly, do this for every parts of assembly automaticly??
When I link in an excel document to my model all parameters in that excel gets the unit (mm).
How can I change this? For instance I want some of the parameters to be an angle.
