AutoCAD Inventor :: Using Parameters From Excel In 2010?
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?
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?
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.
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?
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.
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
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.
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.
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.
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.
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.
But 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.
Recently I have been trying to build table driven products and ipart tables, but when I copy a member to create a new part number, upon exiting the iassembly author I get the following message "excel installation is required for this operation. failed to launch excel". I have a fully functional version of 2010 Excel installed which has been used so it should be recognized in the windows registry. I am running Windows 8 and Autodesk Inventor 2014.
I have created a simple L-shaped dynamic block with a lookup table for its height and length. In addition to the ability to pick the right value pair using lookup table (HxW) I have added the ability to stretch the height or length using a stretch grip and a list of values. Is it possible to make the length automatically adjust to a corresponding value from the lookup table if the height is changed and vice versa?
I am trying to make a dynamic block below. I need the "end" of the line to be "moveable". I've tried the point parameter and the stretch action with no luck.
Is there a way to create a table to display parametric information -- either Dimensional Constraint Parameters or User Parameters? This can be done with Inventor but I haven't yet found a way to do this in AutoCAD. I've also considered Data Extraction but this doesn't seem to recognize parameters.
I want to make a grid that is adjustable by editing parameters. I want to change the size of the blocks. And i want to change the number of blocks in the x-direction and y-direction.
I have created a square with a width of 50mm and a height of 20mm. I have created 2 parameters called width and height. Next I added dimensions to the square and i call those dimensions width and height. Now I can adjust the width and height of the square by editing the parameters.
Next I want to copy this square in the x- and y-direction so that you get a grid. The number of copies in x-direction I call number-x. The same in the y-direction.
I then link the number-x and number-y to 2 parameters that i have named number-x and number-y.
The distance between the squares has to be the same as the size of the first square. Only then you get a grid. So i created parameters for this to. I call them width2 and height2.
Now I can adjust the size of the grid by editing these parameters. When i change number-x or number the grid becomes larger. But when i want to change the size of the initial square, it doesn't work. I think because of the fact that the first square has become a part of an array.
How to make a grid that is adjustable nu editing parameters in the parameters manager?
I have created a dynamic scale bar block that a user can edit two custom properties of (Horizontal Scale and Vertical Exaggeration) and the values on the scale bar will self-adjust after a regen. The block works fine if inserted into a drawing as per normal the normal insert method.
However, the issue I am running into is this:
If the block is inserted into a template drawing that contains our standard company titleblock (again this part works fine), and that layout is then imported into a new drawing using the "From Template..." right-click option on the Model/Layout tabs, the block loses the custom user parameters. Editing the block definition shows that the parameters are there, they just no longer have names or default values and do not appear in the properties window when the block is selected.
Trying to edit the user parameter names in the block definition of this imported copy of the block, just results in receiving an error that I'm attempting to use characters that are not alphanumeric.
I've tried this same procedure with 2013 and the issues still occur. I've tried user parameter names that don't have an underscore in them (just in case that was causing the issue), but again no luck.
I've attached a simpler block that recreates the same problem: Tester.dwg - this is the block that can be inserted into a drawing. It contains two user parameters "Tester" and "Tester_2". Inserting this block into a drawing shows the block works correctly (user parameters are editable from the properties window).Testing.dwg - this is a drawing that contains the above block inserted onto Layout 1. If Layout 1 is imported into a new drawing (using the "From Template..." right click option of the model/layout tabs), then the block no longer functions as it should. The two user parameters are no longer visible in the properties window.
Is it just me or do the actions associated with parameters disappear on occasion from the block editor? Sometimes a regen will make them reappear, other times not. Closing/opening the block editor is one way to make them visible again (worked a few times at least).
I have a table imported into autocad from excel, however despite the table (excel) being formatted, border lines appropriately placed and hidden througout the sheet, all off the border lines of the cells appear when imported into autocad.
is there anything i can do to hide back some border lines for selected cells?
I am trying to add an excel document to a cad drawing using ole. I wish to make it transparent so that only the cells themselves are visible and not the white background and empty cells. (I hope that makes sense).
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.
