AutoCAD Inventor :: ILogic / Export Parameters To Excel?
May 21, 2013
I want to export reference parameters to an excel table using i-Logic
I found the function GoExcel.CellValues("filename.xls", "Sheet1", "A2", "A10") = MultiValue.List("d0")
It looks like the syntax calls for the file location and name if the xls file is not open and if open is not supposed to be required.
I have entered it both ways and with and with out the target file open and with the function GoExcel.Open("pathFilename.xls","sheet1") and continue to get the error:
we couldn't find C:AbellAbell VaultWorkSpaceDEVELOPMENTAC100-0100MRLTEST Table.xls. Is it possible it was moved, renamed or deleted?
Also, I was expecting that to fill in the sheet cell's would be MultiValue.List("d0","d1","d2")
but the system give me an error that says
Error on Line 3 : Overload resolution failed because no accessible 'List' accepts this number of arguments.
See below
GoExcel.Open("C:AbellAbell VaultWorkSpaceDEVELOPMENTAC100-0100MRLTEST Table.xls", "AC-100-0101003-TEST")GoExcel.CellValues("C:AbellAbell VaultWorkSpaceDEVELOPMENTAC100-0100MRLTEST Table.xls", "AC-100-0101003-TEST", "A2", "A10") = MultiValue.List("d194_A")GoExcel.Save
View 8 Replies
ADVERTISEMENT
Mar 11, 2013
I tried Curtis Waguespack's iLogic: Export Parts List with Options, and it works great on Part Lists. I'd like to do the same thing on a custom table, but I don't know what needs to be changed.
View 3 Replies
View Related
Oct 30, 2008
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.
View 8 Replies
View Related
Sep 17, 2010
I created an assembly, so far with one part in it. I created an Excel spreadsheet with several dimensions in it that would be used in the assembly parts. I went to Manage>Parameters and linked the spreadsheet. The Excel file appeared in the Parameter Dialog Box with the parameters included in it. However, when I create a part in the assembly and attempt to dimension a sketch in it, the parameters option in the dimension box is not present.
I have done this in the past in IV2009, has anything changed that I cannot do so in 2010?
View 9 Replies
View Related
Jan 31, 2012
As my Inventor endeavors continue, I would like to take a template of a part I made and use Excel to change the parts dimensions. Essentially make it so if we need a 20 Tonne Lift Lug, I just punch in the necessary values in Excel and have the part update.
View 1 Replies
View Related
Mar 9, 2012
I'm trying to export parameters for my parts to an excel sheet, this way to be able easily to edit any of these. So far :
1. exported parameters as xml.file and opened it in my excel sheet.
2. saved this sheet as xls.file on my desktop and linked (embed) parameters to this file.
- value column is formatted as text.
- any update to value column should immediatly change (after save and close worksheet?) parameters in inventor ?
Inventor 2012 Professional
Excel 2010 [URL]....
View 1 Replies
View Related
Dec 13, 2011
I have linked my inventor drawing to excel to adjust some parameters. Is it also possible to have a enable/disable function in excel so a part in an assembly can be disabled at will?
View 3 Replies
View Related
Oct 7, 2013
I am making an assembly where I wanted to use an excel sheet to link common paramters between the parts. I know how to do it for just my single system, but I am wanting to have all the parts and the excel sheet stored in my vault server. Is there anyway to link the parameter list to the excel file stored in the vault or how can I go about having a common file that everybody can access.
What I am worried about is if the excel file is located on my computer and someone tries to open a part on another machine, it will not find the excel parameters and everything crash.
View 4 Replies
View Related
Jul 20, 2012
I 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 Related
Apr 3, 2013
I tried to match the dimensions of the already existing product with new dimension through fx parameters(using link excel sheet), while conversion all the dimensions are changed except taper value (By default it comes with inch instead of degrees) It can be changed by adding user parameter but i want it to consider from excel sheet data itself. Is it possible? For reference i have attached the snap shots
View 1 Replies
View Related
Oct 9, 2013
I'm having some difficulties with iLogic and reference parameters.
I have made a tube with a weird shape and I want to measure the longest length. So I have to cut the tube in a certain angle in relation with the center to measure the length.
The problem is that this angle is really hard to calculate.
So I tried making a rule where I can make my angle shift x degree and then measure the longest length. If the measurement is larger the previous measurement the angle will shift x degree again until the measurement is smaller than the previous.
So I made my starting angle 0 degree, I know this is for a fact not the longest length. And then I tried this rule. (before making a While rule).
And I noticed that on screen the measurement changes. But the reference - parameter stays the same. So it gives me the measurement on the starting angle & after rotating it again gives me the starting angle.
How can I get the parameter to update itself in between?
Dim measurement_length As DoubleDim measurement_length2 As DoubleMessageBox.Show("Start angle ", "My iLogic Dialog", MessageBoxButtons.OK, MessageBoxIcon.Asterisk, MessageBoxDefaultButton.Button1)angle_measurement_spec = 0RuleParametersOutput()InventorVb.DocumentUpdate()measurement_length = [code].....
View 1 Replies
View Related
Feb 20, 2013
I would like to save parameters marked as Key to an XML-file (from an Inventor addin, VB.NET):
Dim addIn As ApplicationAddIn = m_inventorApp.ApplicationAddIns.ItemById("{3bdd8d79-2179-4b11-8a5a-257b1c0263ac}") 'iLogic addin addIn.Activate() Dim iLogicAddin As Object = addIn.Automation iLogicAddin.ParametersXmlSave(invDoc, "c: emp ext.xml", iLogicAddin.XmlSaveOption.KeysOnly)
This doesn't run: "Public member 'XmlSaveOption' on type 'iLogicAutomation' not found."
The documentation says:
Autodesk.iLogic.Interfaces.IiLogicAutomation.ParametersXmlSave(Inventor.Document,System.String,Autodesk.iLogic.Interfaces.XmlSaveOption)
What is the correct syntax to get the XmlSaveOption?
View 1 Replies
View Related
Jul 18, 2012
I'm trying to link an Excel sheet to a new assembly but it is only listing half of the sheet parameters. I have done this before with no issues. I've also imported another sheet and it works fine. I copied and renamed a sheet I know that works deleting the data from it and coping the data I want and I get the same results. This lead me to believe there is something wrong with the sheet. See attached file.
Excel 2010
Windows 7
Inventor 2012 64 bit
View 3 Replies
View Related
Oct 12, 2011
When I add parameters to Excel, the new parameters do not show up in the linked parts. Even when starting
a new part and linking to the same excel file, the original parameters are all that are shown; not the new ones.
View 3 Replies
View Related
Mar 8, 2012
In the attached file there is a User Parameter, "Antal_ledekasser". Inventor has calculated its value to 2.
If you do the math by hand then you see the value should be 5.
Rebuild doesn't force recalculation.
There is an iLogic rule in the part, but this also fails to force recalculation:
iLogicVb.UpdateWhenDone=True
InventorVb.DocumentUpdate()
ThisDoc.Document.Rebuild2
ThisDoc.Document.Update2
Manual work around is to change the formula, then the value is recalculated.
iLogic work around is to change a parameter-value - and run the rule TWICE.
Question: How do I force a real rebuild, that actually wil recalculate parameter-values the first time I run the iLogic rule?
Background: The attached file is a little subset of the skeleton in a large assembly that is controlled by iLogic. The rules are placed in the topassembly, and writes vaules to the skeleton-file.
After writing values to skeleton-parameters I try to force them through with this iLogic
RuleParametersOutput()
InventorVb.DocumentUpdate()
iLogicVb.RunRule("Skeleton", "Update")
Later in the process I use calculated values to decide which components should be active. But my logic fails because my decisions are made on faulty values.
I did manage to get the updating work in 2011. But after migrating to 2012, it seems impossible to have it update correct. The user has to run rules several times, and doing manually updates to get a correct model.
View 2 Replies
View Related
Jun 7, 2011
I am trying to enter some material ordering info into an external spreadsheet, and have that info reflected in a text box within an idw drawing file.
My method is as follows:
Obtain a numerical value (250) from an external Excel spreadsheet (sample.xlsx).Assign this value to a parameter (abc) in an idw file (Materials Ordering.idw).Insert parameter abc I made into a text box within the same idw file.
I made a set_parameters rule, and the ilogic text of the above example is as follows:
'Open File and Scan line - Part = Impeller Casing Flange
i = GoExcel.FindRow("sample.xlsx", "Sheet1", "Part", "<=", "Impeller Casing Flange")
'abc = Material Width
abc = GoExcel.CurrentRowValue("Material Width")
I had no problems with the first two steps, after checking the parameters I could see that parameter abc is being updated successfully.
However, I am having trouble with the third step. In the format text dialog box, I can see a drop box for components, but I can't find a reference to the idw file in there.
My question is, am I going the wrong way about this? Should I have assigned the parameters to a component instead of the idw file?
View 5 Replies
View Related
Aug 22, 2012
Working code ...... attaching file
Auto = iLogicVb.Automation
Dim iLogicAuto As Object
iLogicAuto = Auto
Dim oDoc As Document
oDoc = ThisApplication.ActiveDocument
[Code]...
'but now something more i wanna do is...... delete parameters
If Not (param Is Nothing) Then
For Each param In params
i = MessageBox.Show("Checking for Parameter in File")
i = MessageBox.Show("No.of Parameters exists are ="& param.count)
[Code]....
View 5 Replies
View Related
Jan 27, 2012
linked Excel file to Inventor 12 file parameters. Windows 7, Excel MS office professional '10. Linked excel file, here dimensions are driven by parameters which are driven by excel. toggled 'immediate update' Still - i have to open the sketch - it shows the updated number from Excel, but only on opening the sketch will it change the model to use the new dimension value.
View 3 Replies
View Related
Aug 7, 2013
I have a problem with using the excel spreadsheet to hold my parameters and then making them auto update in the model.
I have the excel 2003 spreadsheet saved in the same folder in the projects directory as the model. When I create the spreadsheet and enter the parameters and values etc I save and close the file.
When I am in inventor 2013 64 bit with SP1 installed, I open the model and can link the spreadsheet to the model and the model reflects the values in the spreadsheet. I also click update on the parameters dialog box.
I then open the spreadsheet and make some changes to the values, save the file and even go to the extreme of closing the file. When I go back into Inventor it recognises there has been some changes in the underlying spreadsheet. The update button is active in the tool bar. However trying to update the models by what ever means does not update the model parameters to those in the spreadsheet. Even closing the model and reopening it does not make a difference.
The only way I can get this to work is disconnecting the file and then reconnecting the file through the links option in the parameters dialog box. Then the model reflects the correct values and updates the model accordingly.
My concern is there is quite a bit of stuff on the net about 2013 not working with 2014 inventor anyway.
View 3 Replies
View Related
Jul 17, 2013
iLogic code question concerning how Place iLogic Component and retain the ability to push parameters from the subassemblies to the parts after being renamed.
I have ASSEMBLY.iam containing:
SUBASSEMBLY-01:1.iam
SUBASSEMBLY-02:1.iam
and sometimes SUBASSEMBLY-02:2.iam
each SUBASSEMBLY.iam contains PART1.ipt and PART2.ipt which have variable LENGTH and WIDTH. LENGTH and WIDTH are entered manually at the SUBASSEMBLY.iam and are infinitely variable.
To transfer the parameters I'm using iLogic code in the SUBASSEMBLY:
Parameter("PART1.ipt", "LENGTH")=LENGTHParameter("PART1.ipt", "WIDTH")=WIDTHParameter("PART2.ipt", "LENGTH")=LENGTHParameter("PART2.ipt", "WIDTH")=WIDTH
Issue 1: When I place the SUBASSEMBLY as an iLogic Component, the parts are renamed to PART1-01.ipt which renders my Parameter transfer useless. What am I missing on writing this code so it can find the new part name?
Issue 2: I like the automatic renaming that happens with Place iLogic Component. Is there a better way to handle this automatically through Place Component -> Save & Replace?
Inventor 2013
View 1 Replies
View Related
Sep 11, 2013
I am looking for information on the option parameters, any documentation?
I found some code to query what parameters there are (Rule: GetTranslatorOptions), just not sure what the enumerations are for some.
Specifically: ExportUnits, Resolution
Using Rule:ExportSTL
I have changed the Export Units from 1 to 4 and do not see any change to the STL ASCII output.. not sure what this parameter does... Expected it to be an enumeration of the drop-down box that you see during "manual" exporting.
View 1 Replies
View Related
Aug 14, 2013
I have this little iLogic snippet that writes out the name and value of all parameters in active document.
doc = ThisDoc.Documentparams = doc.ComponentDefinition.Parametersnames = New List(Of String)values = New List(Of String)For Each param In paramsIf Len(param.Name)>4 Thennames.Add(param.Name)values.Add(param.Value.ToString)ElseEnd IfNextMultiValue.List("ParamsList") = namesMultiValue.List("ParamsValues") = valuesGoExcel.CellValues("COVER.DEFAULT.PARAMS.xlsx", "Sheet1", "A2", "A400") = MultiValue.List("ParamsList")GoExcel.CellValues("COVER.DEFAULT.PARAMS.xlsx", "Sheet1", "B2", "B400") = MultiValue.List("ParamsValues")GoExcel.SaveGoExcel.Close
The problem is it ignores the parameter's units and assumes cm for length and rad for angular. I need another nested IF - Then that says:
IF param.Values.'UnitType' is "in" THEN
param.Value = param.Value/2.54
Else If param.Values.'UnitType' is "deg" THEN
param.Value = param.Value*360/2/3.14159
End If
I just do not know the syntax or proper method.
View 1 Replies
View Related
Dec 26, 2013
Is there a way to work with parameters on a suppressed assembly using iLogic.Everything works fine, but when I suppressed a part ilogic rule give me an error: Parameter: The component named "xxxxx:1" was not found.
View 1 Replies
View Related
Apr 3, 2012
I want to import the parameters from the .ipt file into the .iam file using a rule from iLogic (unless there is another way to do it?)
I pinched the code from the example hand rail iLogic part that comes with inventor and tweaked it to suit. After inputting the code shown in the image, when I click OK I get a 'fatal error' of some sort.
View 6 Replies
View Related
Jun 12, 2013
Is there a standard command or command sequence that allows for the changing of a parameter, say length, of a component from within an assembly. I'm looking to compile a code that allows for a template to be created, then that template will do changes based on text box input and then save out the modified parts with new part numbers.
View 2 Replies
View Related
Aug 30, 2013
I need import all new params, rules and forms from a new template to older parts. I'm trying to use an external rule to create a new iproperties and import params from xml file but I can't assign these parameters with these iproperties.
I attach the code.
View 3 Replies
View Related
May 28, 2013
Is it possible to use iLogic to insert a row into excel?
View 1 Replies
View Related
Sep 3, 2013
I am trying to use an iLogic Excel link to define the hub and bushing dimensions for a wing pulley part file. I get an error: GoExcel: Could not match the column title: "Size". I've attached the part file and Excel file. The iLogic rule in the part file is called Hub_Bushing.
View 9 Replies
View Related
Aug 23, 2011
I would like to be able to use iLogic to get the value of the Comment field of a model's parameters. I have some text there that I would like to display in a sketched symbol. The attached image illustrates what I am seeking.
View 2 Replies
View Related
May 7, 2012
So far I can discover parameters and ilogic aren't possible in the definition of a drawing border.
How can fold lines be created in a border that can be used for multiple scales?
View 1 Replies
View Related
Jan 9, 2014
I am trying to create a new sheet in an existing excel file and can not figure out how to do it.
I am trying to export parts lists from multiple drawings to an exisitng excel spreadsheet and I'd like have each on their own sheet. I can do everything but create a sheet. How to do this in iLogic?
Inventor Pro 2013 (PDS Ultimate)
Vault Pro 2013
Windows 7 64
Xeon 2.4 Ghz 12GB
View 2 Replies
View Related
