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 RepliesI 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?
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 RelatedWhen 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.
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 RelatedAs 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 RelatedI'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]....
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 RelatedI 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
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.
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 RelatedBut I was wondering if it is possible to contol the insertion of dynamic blocks and it user definerable parameters from a excel-text file.
I am surveying a section of pipework and I need to display the brackets that are supporting the pipes. As there are numerous pipes on top of each other I have decided to show the brackets in plan and isometric view.
I think I have made the dynamic block ok and have numerous stretch/move and scale parameters working correctly.
But the only way that I can see of chaging these parameters at the momment is by manually typing them in the properties tool pallete for each individual block.
So I was thinking that if I can store the correct values that I need for each parameter in the dynamic block on our data logger along with the correct E,N,Z insertion point is it possible for this file to change the parameters in the dynamic block for example, If I have the correct insertion point stored and then have 10 parameters stored with that point for simplicity I store as A=5.00,B=8.00,C=0.100 etc and these correspond with the parameters in the dynamic block will this file be able to alter the dynamic block as the values in the excel/Text file are displayed.
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
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.
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.
We have this problem at the moment with an Microsoft excel file that appears to have become stuck in the External references list, Ref C1-01-06. We would like to remove it if possible as it is now superseded (we can't change the file name unfortunately. What do we do if we can't reload, detach or bind? Its not referenced into anything else that is attached to the file, it is a direct attachment of the file that we are in.
View 3 Replies View RelatedI am making an excel spreadsheet that has a list of all the drawings we have on file, an inventory list per say. I have all of the drawings hyperlinked.
View 3 Replies View RelatedI have created an iLogic panel which allows me to control my revision a lot easier and puts my entered data into the parameters of the sheet itself, is there a way to have this show up on the drawing itself for a template?
View 1 Replies View RelatedIf I place a link to a dwg as a hyperlink in an Excel file, AutoCAD freezes. It opens the drawing, then AutoCAD is completely locked. I have to close it through task manager.
This has been tested wih multiple drawings and excel file and it happens in all of them. I'm using Excel 2010 and AutoCAD 2010.
Win7 x64 - 16gb ram
i7 3610qm
FirePro M4000
Inventor 2013
ETO 6.1
This has happened on all versions of AutoCAD in our office.
I paste schedules from Excel into AutoCAD. I print out the sheets and ghost lines appear on the PDF and hard copy that were not intentionally place in the excel file. What is happening and what can be done about it.
I also paste a tif file on a sheet change the setting to imageframe <0> and a residual line willl appear in pdf and hard copy that seems to be the border of the tif image.
I have to shade a drawing on auto cad. I go into the "hatch" command click on the solid block and then turn the transparency up all the way to its lightest shade. The shading shows on the drawing and even in paper space, but once I save the drawing as a PDF when I look at it all it is is black (like the solid color)..Why is it doing this and how do I get it to show the shading effect?? I am not sure if I have to turn on or off another setting or something.
View 2 Replies View RelatedI've spent the last 4 hours searching for an answer to this question, but I simply can't find one.
As a start I think you have to know that I'm currently using AutoCAD 2012.
Here's the problem: I need to extract some info from an AutoCAD table to a reference file that can be opened in Microsoft Excel. Everything I find on the subject is actually an answer to the question "How does <DATAEXTRACTION> work?" or "How to do an extraction of DATA in AutoCAD?"....
In this particular case I have a set of production drawings (cut tickets) for manufacturing of stone. And in every single sheet I have this material schedule or a table, if you wish, that is made with an AutoCAD table. In this schedule I have the height, width and thickness of the stone plate and with a function it measures it's area and volume. What I want to do is to extract those values into a reference file that I can open with Microsoft Excel, as I already said.
How exactly?
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 RelatedHere is what im running
OS: Windows 7 x64
Autodesk software: Autodesk Product Design Suite Premium 2012
Microsoft software: MS Office 2010 Starter which includes Word & Excel ONLY.
Error message from Inventor when trying to open an Ipart :
"Excel installation is required for this operation. Failed to launch Excel."
FYI.. this solution doesn't work [URL]
don't have this registry key HKEY_CLASSES_ROOTWow6432NodeCLSID{00024500-0000-0000-C000-000000000046}
OS: Windows 7 x64
CPU: Intel Core i5 @3.0 GHz,
Ram: 8 GB Harddisk: 1TB
Software: Autodesk Product Design Suite Premium 2012
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?
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]....
My goal is to open have people go into a central assembly file, type in their specific parameters and the various part files update within the assembly. I wish to do this without the need for an excel sheet, but when I try to link the parameters from the assembly file to the part files, it will not allow me to insert these parts. I get an error about an "assembly can not be placed into itself."
Iparts will not work as this has an infinite amount of sizes.
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.
I would like to have a rule that will add specific user parameters to a part file. These parameters need to be formatted so the width, depth and thickness will control the description of the part.
IE:
Width=4
Depth=2
Thickness=3/16
DESCRIPTION = TS <Width>X<Depth>X<Thickness>
I would like to format each parameter so that the:
Format=Fractional
Precision=1/16
Unit string=False
This is what I have so far:
oMyParameter=ThisApplication.ActiveDocument.ComponentDefinition.Parameters.UserParameters
oParameter=oMyParameter.AddByExpression("Width", "TOP_RAIL_WIDTH", UnitsTypeEnum.kInchLengthUnits)
oParameter.ExposedAsProperty=True
oParameter.Units="in"
[Code]...
The TOP_RAIL parameters are from a linked file.
Op System: Windows 7 Home Premium
Processor: Intel Core I7 960
Ram 12.0 GB system 64 Bit operating system.
MIcrosoft Excel info: Excel 2010 (14.0.4756.1000) MSO(14.0.5113.5000) Microsoft Office Home and Student 2010
Inventor Info: Autodesk Inventor Professional 2012 54 bit edition
Build: 160, release 2012 RTM Date 3/1/2011
When trying to link to excel file get error "Not Implemented". Have tried the registry 'fix' - does not work. Need to get these links working to drive models. This same Excel version works fine for Solidworks which inks perfectly with no issues whatsoever. Inventor has been a problem for 2011,and now 2012 - still not working.