AutoCAD Inventor :: Setting Multi-Value Parameter From Excel Named Range Values
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
ADVERTISEMENT
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
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
Jun 16, 2011
how (if) I can set up my dynamic blocks so that I can set the parameter values as I insert the block, rather than with the grips afterwards?
To take a simple example; I have a block consisting of a rectangle, with 2 linear stretch parameters - length, width. Can I set it up so that when I insert the block, it asks for the length and breadth,just as it would for attributes.
View 4 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
Jan 18, 2012
I have to choose 1 of three views in a drawing using a range of values like:
if ..........<10 then
ActiveSheet.View("VIEW1").View.Suppressed=False
else
ActiveSheet.View("VIEW1").View.Suppressed=true
[Code]....
The syntax that is in red upstairs gives me a error... What is the proper syntax to do this condition involving a range between two values???
Autodesk Factory Design Suite Ultimate 2014
Autodesk Simulation Mechanical
Autodesk Simulation CFD
Windows 7
View 4 Replies
View Related
Nov 25, 2013
Getting UV Parameter Range for the Face Object
View 3 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
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
Oct 29, 2012
Macro for writing the sheetmetal Extents width and length to the custom properties. I need to get these values into the part parameters so that they can be used in the BOM.
I can get this to work if I manually create the "SM_Length" user parameter, but how do I make the iLogic CREATE the parameters if they do not already exist? I think it would be something added below the "Catch..." just cant seem to figure out what it needs to be.
'look for custom iproperty and try to set it
Try
iProperties.Value("Custom", sExtLength)=Round(SheetMetal.FlatExtentsLength, iRoundValue)
Parameter("SM_Length")=Round(SheetMetal.FlatExtentsLength,4)
Catch
' assume error means not found and create it
customPropertySet.Add(Round(SheetMetal.FlatExtentsLength,iRoundValue), sExtLength)
EndTry
View 9 Replies
View Related
Aug 26, 2010
I created a sketch that I would like to use in an iFeature. The sketch dimensions are controlled with an ilogic rule referencing a multi value text user parameter, eg the text parameter pull down menu controls the size of the part.
Is there an easy way to get this parameter into an ifeature or derived part?
View 4 Replies
View Related
Nov 3, 2011
I am struggling to find the right ilogic to extract the state of a multi-value text parameter and use it to populate a single i property.
View 1 Replies
View Related
Mar 21, 2013
Where do I find the "Allow custom values" option for a multi list parameter expression?
View 2 Replies
View Related
Jan 17, 2013
I have an iLogic template part that has a multi value parameter. In this case the product code can be selected from a list of 4 codes. In futre we may need 5 and the 5th may need to be available to older parts.
I would like to avoid having to add the 5th as an option to every part we've ever made when the 5th becomes required.
I'd like to have the list of codes stored in an external file (Possibly an xml) and the template part reference that file to acquire it's list of available codes. That way I can add codes to the xml and all the files will have their list of available codes updated.
View 2 Replies
View Related
Jan 3, 2014
IV2012 API with VB:
How can i add an item to a Multi-Value-List of an existing User Parameter in Inventor2012 (Accessing API with Visual Basic) ?
My idea is for example:
uParams.Item(i).ExpressionList.AddItem(As String)
The problem is, that such a function "AddItem" doesn't exist.
View 4 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
Dec 10, 2013
We have multiple clients and each client has multiple projects. Each project gets its own master assembly that contains multiple equipment layouts. This allows us to show everything together. In each master assembly, we create LODs to display equipment layouts side by side for connecting things one to another and to avoid collisions.
Example: The master assembly may contain 8 equipment layouts. Each layout is for a sub-process within the whole process. We create LODs for different groupings of layouts so that we can zero in on anything in particular that we wish to focus on. By choosing an LOD in the open dialogue box prior to opening the master assembly, performance is improved because we're only opening what we need instead of everything.
Within an equipment layout are any number of assemblies. We can create LODs to show the layout without conveyors or to show different options we've developed to present as concepts for approval prior to detailed design. Sometimes we are adding assemblies to an existing layout so we'll create an LOD for existing, one for as built, one for purposed.
how to create or modify LODs. Therefore, we are getting LODs with users' initials or a date or "doohickey". We've got to come up with something that makes sense now and will make sense later.
Any guideline for managing LODs in a multi-user environment?
View 3 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
Mar 6, 2012
Ok what I'm tring to do is have a spreadsheet that has a list of prices in it that we could modify if needed for all these parts i'm making. Best way is to have the spreadsheet obviously external of the file.Though now I do not know how to do this in iLogic.And example of what I'm trying to do is, with 3 parameters.
A, B, and P
Value "A" and Value "B", these are just read items which when combined will give Value "P" to be imported into the Part file. So need A & B to be read and give the row number for P to be imported.
View 3 Replies
View Related
Jan 10, 2012
if it is possible to increase the number of recently used values/parameters in the dimension dialog, during part sketching. For one part, I use approximately ten parameters that will be used repeatedly. When I'm done with one sketch and start with the next, only the last five parameters are in the recently used parameter list. (Create dimension --> select arrow on right side of dialog, see attachment Dimension_Dialog.jpg, excuse me for the poor quality ). It would be much more comfort to have more parameters in this 'recently used'-list.
Furthermore I'd like to know if it's possible to widen the parameter-list. In my case I've several parameters that start with the same prefix, followed by a differentiating suffix. When I create a new dimension, select the arrow on the right and select 'List Parameters', I have to adjust the width of this dialog every time to see the entire parameter. (see picture Dimension_parameters.jpg)
View 1 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 9, 2012
I'd like to drive the position of workpoints by coordinate values defined in Excel. Inventor allows me to initially create them using values from a linked spreadsheet, however the positions do not change when the spreadsheet is updated. Is there another technique that could do this?
View 1 Replies
View Related
Jan 5, 2012
I have code that has the user select a viewport. I then need to set the selected viewport to an existing view, but I cannot find any exampes of this.
I have the viewport, but how do I get the ViewPortTable/ViewPortTableRecord from it?
Do I need to set the view in the ViewPortTableRecord od the ViewTableRecord?
No problems to this point...
'Code snipIf acPrmpt_res.Status = PromptStatus.OK Then
Dim acVPort As Viewport = Nothing
Dim acViewTbl As ViewTable
Dim acViewTblrec As ViewTableRecord
[Code] ........
View 5 Replies
View Related
Apr 9, 2012
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.
View 1 Replies
View Related
Nov 20, 2013
in iParts factory I would like to create part ## by setting common name and adding to it different values drawn from part parameters.
Please refer to attached image – common name in that example would be “DRILL” and description of the diameter and length automatically taken from parameters in columns “DRILL_D” & “INSERT_L”.
View 3 Replies
View Related
Sep 13, 2013
I simply want to paste a series of cells from excel into an existing autocad table. About 8 rows, 1 column thick. I want the values to acquire the destination formatting too if possible. I do not want to create an OLE object or anything fancy. I have seen instructions to use "Paste Special" on forums, but I do not have this choice when I right-click. I'm sure this is possible.
View 8 Replies
View Related
Aug 4, 2008
Is there a way to select pixels in Photoshop based on given Lab values? I am using Select --> Color Range with a specified "fuzziness" threshold, but I'd rather make the selection based on specific Lab values instead of random pixels that I choose with my eye dropper. Is there a way to do this in Photoshop, or does anyone know of a plug-in that might do this?
View 6 Replies
View Related
Dec 1, 2011
Any way I can import data from an excel file in a predetermined range but variable workbook and sheet. For instance, in Station5.dwg I access cells B4:C15 on sheet STA-5 on workbook TerminalA.xls and then in Station6.dwg I access cells B4:C15 on sheet STA-6 on workbook TerminalA.xls, but all through just rerouting the sheet just as if I were to reroute an xref with the same scale and insertion point.
I'm trying to avoid a continual copy/paste of OLEs for each .dwg because I will have an average of 5 ranges to import from each sheet, of an average of 7 sheets per workbook, of an estimated 220 workbooks to work through. (7,700 ranges estimated so far is a lot of work).
View 0 Replies
View Related
Aug 8, 2012
there i wanted to know a method to control my view frames range or how to do so in the sheets ,
as per attachment i get the Profile view , out of frame
Yeah Will Not that much :
Sony VPCCW26FA
Intel Core i5 M 520 @ 2.40GHz
8192MB RAM
NVIDIA GeForce GT 330M 512MB Dedicated
View 3 Replies
View Related
Feb 6, 2014
I am trying to set font = "Times New Roman" to a text range.
But the API constantly fails with error code = "1430996551".
AIErr result = sAIFont->FindFont("Times New Roman Regular", kAIUnknownFontTechnology, kUnknownAIScript, false, &headingFontKey);
I tried "Times New Roman"
"Times Roman"
"Times-Roman"
"Times New Roman Bold"
I have all these fonts installed on my windows 7 machine and can see them in the AI's font selection menu as well.
What might be the problem ? And how to decode the errorcode (1430996551) ??
View 2 Replies
View Related
Jun 24, 2013
When I manually enter the attribute, it comes up with 3 different data entry options but when I look at the attribute in .NET it shows IsMTextAttribute = FALSE.
What is the best way to set the multiline block attribute?
View 3 Replies
View Related
