AutoCAD Inventor :: ILogic - MultiValue Parameter - Get Named Range From Embedded Excel
Jan 9, 2013
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")
View 2 Replies
ADVERTISEMENT
Nov 20, 2013
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")
View 4 Replies
View Related
Oct 24, 2013
I am trying to insert an excel table using a datalink. If I insert the entire sheet, it includes too many cells. If I set a print area and choose that area, it will not insert the table. The first time it acts like it is going to work, but then never lets me place the table. The second attempt it just will not let me select that data link. If I actually name a group of cells, I get the same behavior as the print area. Have issues with importing excel tables? Am I missing a step?
My work flow is
Create an excel sheet & format the table.
Select desired sells, set print area.
Save & Close excel
go to annotate tab in civil 3d
select table icon
choose from data link
launch data link manager
create data link and choose range of cells as print area.
Press OK
it never let me choose insert point.
I have also tried to simply make the datalink and then run the table command with the same results.
Civil 3D 2013
HP Z400 Workstation
6GB of RAM
296GB HDD
ATI FirePro V5700(FireGL)
Win 7 Home Professional
View 5 Replies
View Related
Sep 20, 2013
For Creating my own templates i want to use iLogic and embedded Excel-Spreadsheets. The embedded Sheet has its own data, but i want to create a rule to refresh the data from an external Excelsheet.
For now i use the following rule:
For I = 65 To 90 '65=A 90=ZBuchstabe = Chr(I) GoExcel.CellValues("3rd Party:Embedding 1", "Platte", Buchstabe & "1", Buchstabe & "999") = GoExcel.CellValues("G:KonstruktionVorlagenMaterialgrunddaten.xlsx", "Platte", Buchstabe & "1", Buchstabe & "A999")Next I
it works well, but wont insert a new single-sheet or refresh formats, i have to add the same code for each sheet. And its REALLY slow.
Is there a possibility to refresh or replace the whole embedded file via a simple iLogic-rule?
View 1 Replies
View Related
Apr 30, 2013
I have some code (below) that will open my embedded excel spread sheet and it works great. Now I need the code to save and close the excel file after it’s been open.The embedded excel spreadsheet pushes some stuff the model and does a couple other thing. So all I really need is for the excel file to open, save, and close when the rule is run.Imports Inventor.
OLEDocumentTypeEnumExcelApp = CreateObject("Excel.Application")Dim ExcelFile As ReferencedOLEFileDescriptorExcelFile
=hisDoc.Document.ReferencedOLEFileDescriptors.Item(1)ExcelFile.Activate(kEditOpenOLEVerb, ExcelApp)
View 4 Replies
View Related
Jul 24, 2012
How to populate an Inventor Multivalue PARAMETER using a For cycle in iLogic according to a variable index corresponding to a different number of array items?
for example:
i grab some data from a Rule and populate an Arraylist variable. I trace the number of instances using a counter. after the data acquisition I want to populate the Multivalue Parameter with the acquired values.
No problem browsing the Arraylist parameter: MyArraylist.(Index)... but what about the Multivalue parameter?
the MultiValue.SetList("Multivalue Parameter", Value 1, Value 2, ... , Value N) provide a defined number of data and cannot be set dynamically according to an Index.
View 2 Replies
View Related
Jan 21, 2013
I have the following rule:
If OD=900 mm And Filter_Type = "Aerob" ThenMultiValue.SetList("FilterSize", 0.2, 0.3, 0.4, 0.5, 2.2, 2.3, 2.4, 2.5)End IfIf OD=900 mm And Filter_Type = "Donaldson DLM" ThenMultiValue.SetList("FilterSize", V3/7S, V4/7S, V8/7S)End If
For first condition everything is ok. But when the second one is valid it gives error:
Conversion from string "V3/7" to type 'Double' is not valid.
Maybe I should add that the parameter "FilterSize" was made as Text and multi-value.
AIP 2014
Windows 7 x64
Dell Precision T7400 Intel(R) Xeon(R) CPU X5472 @ 3.00GHz (4 CPU's), 8Gb RAM, NVIDIA Quadro FX 5600 1536MB GDDR3
View 2 Replies
View Related
Jul 8, 2013
I have a form with a multi value selection containing name vaules from an iPart.
I want to make a selection from the field in my form and swap out my iPart in the assembly for my selection.
I thought that something like:
Dim iFactory As String
MulitValue.SetListInComponent ("FileName:1", "Param name", "list of params.......")
Parameter("FileName:1", Param name") = "PK 407" 'could be any thing selected from the list of params..
iFactory=Param name
iPart.ChangeRow("iPart Factory File Name:1", iFactory)
Such that the part would be swaped out for what ever Param name = as a result of user selection.
I get the following error from this: Object reference not set to an instance of an object.
View 1 Replies
View Related
Nov 4, 2011
I try to filter an Excel List and therby fill certain Multivalue Parameters with the filtered data.
The filter works fine an provides me a string looking like the sytax for the MULTIVALUE.SETLIST command.
B6string = FilterReturn & Chr(130) & B6String = 75‚80‚250‚65‚45‚250
Unfortunatly this string gets exactly as ONE entry in the Parameters Value listing !
MultiValue.SetList("B6_Lochbild_Länge", B6String)
I also tried
MultiValue.List("B6_Lochbild_Länge") = New Integer () {B6String}
and also
B6string = Chr(148) & FilterReturn & Chr(148) & Chr(130) & B6String
with the same effect !
View 2 Replies
View Related
Jul 16, 2012
How can I to check if parameter d0 is unexisting?
' If d0 is existing...
oModelParams.Item("d0").Name = "NewParam"
oModelParams.Item("NewParam").Value = 25
View 4 Replies
View Related
Nov 25, 2013
Getting UV Parameter Range for the Face Object
View 3 Replies
View Related
Jul 4, 2012
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?
View 4 Replies
View Related
Nov 14, 2012
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)
View 1 Replies
View Related
May 23, 2012
I have an embedded Excel file in my dwg file. I'd like to make it visible on the drawing. On the drawing though, it only displays however many rows existed when the sheet was inserted.
For example, when I clicked "Insert Object", only 1 row existed in the Excel sheet. I've now added 10 more rows, but still only the first row is visible.
How can I make the table on the drawing display the full view of the Excel file?
Win7 x64 - 16gb ram
i7 3610qm
FirePro M4000
Inventor 2013
ETO 6.1
View 4 Replies
View Related
Jan 14, 2011
I have an Embedded spreadsheet in a .ipt file. I want to access the data in it using iLogic, but i keep getting this error...
GoExcel: 3rd Party worksheet not found: "3rd Party:Embedding 1", Sheet: "Sheet1"
Do I need to declare the spreadsheet somehow, or is there something else I missing? This is the only code I have in the rule...
i = GoExcel.FindRow("3rd Party:Embedding 1", "Sheet1", "ID", "=", 1
View 9 Replies
View Related
Apr 3, 2013
I would like to use the if else parameter in iLogic to set up a range, but I'm not getting it right.
What should happen:
if the variable 'breedte' is:
- 0 up to 3800; thats OK
- 3800 up to 4000; thats not OK, use 3800 instead
- 4000 and up; thats OK
Therefore I wrote this script, but when I enter a number between 3800 and 4000 (like 3900), the MessageBox appears (thats good), but the size of my solid results in 3900, instead of 3800.
breedte = InputBox("What is the breedte?", "Hoofdmaten", "")Parameter("skelet.ipt.breedte")=breedteIf breedte <= 3800 Then breedte = breedteElse If breedte >= 4000 Then breedte = breedteElse If (breedte >= 3801) AndAlso (breedte <= 4000) Then breedte = 3800 MessageBox.Show("This breedte is not possible." & hoogte & vbCr & "The value of 3800 will be used instead.", "Problem message", MessageBoxButtons.OKCancel, MessageBoxIcon.Asterisk) End If
View 2 Replies
View Related
Nov 8, 2012
Is it possible to open an embedded XL sheet with iLogic ?
I tried "GoExcel.Open("3rd Party:Embedding 2", "ENTREE DES DONNEES"), but nothing happen...
View 9 Replies
View Related
Dec 5, 2011
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
Jan 17, 2011
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.
View 3 Replies
View Related
Sep 20, 2011
how to round a parameter using ilogic.
For example. I have Roperev=Roperev_1. Roperev_1 is determined by an excel equation. I need Roperev to produce a nominal number because this parameter dries a coil revolution and I need the revolution to be a whole number.
I can not just round the excel result because the excel result needs to be multiplied by 2.53 to get the resultant for Roperev_1
View 9 Replies
View Related
Mar 26, 2013
When I import a part from content center, a tube in this case, I get a length parameter called <PL>.
I am using this parameter in the parts lists, so it shows "=Outer diameter x thickness x <PL>"
However I don't want trailing zeros, leading zeros or units string to be shown.
I know I can open the parameters window, right click the parameter, then click custom property format and then uncheck these boxes and its fine.
But I want to know if there is a smarter way to do this, like creating a rule to execute on all the parts?
I have around 500 pipes with the parameter <PL> that needs to be changed.
View 6 Replies
View Related
Mar 26, 2013
I have built a vb interface using a tutorial from AU. Now I would like to do the same without the interface.
Inventor uses ilogic to pass parameters to the dll - the dll does the number crunching & returns values to Inventor - no interface required.
The tutorial uses an OK button to fire values back & forth - how can I do this without a button? I would like this to fire in the background without a form appearing.
View 4 Replies
View Related
Jul 22, 2013
I know how to get a parameter into my list of custom iProperties.What I want to do is take the iProperty lbmass and add it to the list of user parameters. Is there any way to do this without using iLogic?
View 8 Replies
View Related
Dec 31, 2012
I have several part models that are very simple and are basically long cylinders. I want to create an external ilogic rule that i can run in each part file that can identify the largest sketch parameter dimension. So basically it will find the Length of the cylinder due to it being a larger dimension and then rename the parameter.
I could just name the cylinder length sketch parameter the same in each part file, but I wanted to attempt to make it more universal for all users. So if a new user forgets to properly label his part parameters, the ilogic program can identify what parameter it should be looking for and rename it properly.
View 1 Replies
View Related
Sep 27, 2012
In 2009 Inventor iLogic, we have a button to delete all parameters and rules. But now, in 2013 Inventor iLogic, I only find a button to delete all rules. Where is the button to delete all parameters?
View 9 Replies
View Related
Sep 4, 2012
Get the i-logic parameter tab on ribbon. I am not able to locate that in my 2013 version.
have a look on attached image.
View 5 Replies
View Related
May 1, 2012
Is there a way to create a multi-value parameter with ilogic?
Inventor Pro 2013 (PDS Ultimate)
Vault Pro 2013
Windows 7 64
Xeon 2.4 Ghz 12GB
View 9 Replies
View Related
Apr 12, 2013
I wish I perform the following code with iLogic. Is it possible to change a model parameter to a reference parameter?
If My_Expression Then' My dimension "d0" is a Driven Dimension' or' My dimension "d0" is a Reference ParameterElse' My dimension "d0" is NOT a Driven Dimension' or' My dimension "d0" is a Model ParameterEnd If
View 9 Replies
View Related
Jun 26, 2012
How to set multi parameter, iproperty using ilogic (or smth else)?
I hav eparameters: d1=50, d2=100, d3=5. I need to set a new multi parameter/iproperty that the final value is:
Angle 50x100x5 (suppousedly code should contain smth like: "Angle", "d1", "x", "d2", "x", "d3") but I do not know exactly...
View 2 Replies
View Related
Dec 28, 2013
Is it possible to update an existing User Parameter. While I can only delete-create a new. In this case the connection is lost with BOMQuantity.
View 5 Replies
View Related
Feb 21, 2013
way to rename a new dimension parameter in sketch with a dialog box directly not having to go to Functions or diemnsion properties.
View 2 Replies
View Related
