Is there a way to link any inventor file iproperties to a excel spreadsheet - so that the excel spreadsheet updates parametrically with any inventor iproperty changes.
I know that inventor parameters can be linked to excel, but what about i properties?
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.
I am looking for a way to link custom harness properties to equal i-properties for an electrical connector, My end result is I would like the Cable and Harness report generator gather "description" but I will not recognized the i-property " description" but if I create a custom harness property "description" it will report that. I would like the custom harness property to equal the i-property of the part, or am I going about this the wrong way?
View 1 Replies View RelatedI am trying to use an iLogic rule to populate iProperties (some generic, some custom) from a part number spreadsheet (containing columns such as PART NUMBER, DESCRIPTION, FINISH etc) and the rule keeps throwing up the following error 'Conversion from string "" to type 'Double' is not valid.'
Here’s part of the code (would be extended for the required custom iproperties but I’m assuming the same principle is ok)
StartRule:
'read excel file
GoExcel.Open("C:DESIGNDocumentsEXCEL FILESPART NUMBERS", "PARTS")
'index row 3 through 10000
For rowPN = 3 To 10000
'find first empty cell in PART NUMBER column (Column A)
If (GoExcel.CellValue("A" & rowPN) = "") Then
[code]...
Changing the format of the excel data (number or text) has no effect. Is manipulation of the format required so that Inventor can read text and numbers to iProperties in this way?
I'm importing custom iproperties from an excel document into inventor using the code I've written below. I've figured out how to bring up a dialog box to select the excel file I need, but I'm completely stumped when it comes to selecting the sheet within the file. As it is now, I'm specifying the sheet in the code itself (Str. C). My goal is after selecting the excel file from the dialog box, have ilogic list all the sheets within the excel file, then be able to select which sheet I need using a radio box, list box or some sort of prompted entry.
DimfdAsOpenFileDialog=NewOpenFileDialog()
DimstrFileNameAsStringfd.Title="Open File Dialog"fd.InitialDirectory="C:"
fd.Filter="All files (*.*)|*.*|All files (*.*)|*.*"
fd.FilterIndex=2
fd.RestoreDirectory=True
[code]....
I'm looking for a way to export all iproperties, (from a selection or a directory), from windows browser, and CSV import into excel.
What I'm looking to do is, be able to select hundreds of files from the windows browser, either select the directory, (and it's sub-directories), or a selection of files, and extract their iproperties, and place the contents into excel similar to exporting contacts from outlook and importing them into excel.
i have made a iLogic Module who, whit an external rules, import the iProperties value from an external exel file.The exel file is connected from SQL with the our managerial software.This in the external rule:
i = GoExcel.FindRow("Z:DISEGNI_INVENTORDescrizioni.xls", "Descrizioni", "Cod.Art.", "=", iProperties.Value ("Project", "Part Number"))iProperties.Value ("Project", "Description") = GoExcel.CurrentRowValue("Descr. Articolo Princ.")'iProperties.Value("Project", "Project")
[Code] .....
It's work fine but i have same question. There is some string to refresh an iLogic Module? When i push the ruel button the rule add the custom value in iProperties, but there are disabled, i have close the module an reopen it for correct display the value of the iProperties.
this module work with single parts. Can I do an rule who do the same thing of my string but in one assembly, do this for every parts of assembly automaticly??
I want a ilogic rule syntax for following process:
I have one excel sheet it consists around 5 sheets for Plate, Flats, Rounds, etc. When i am run the rule then it will ask and do the following:
Ask the thickness value.It will search thickness value in “D:LINUS KOTTEstock numbers.xlsx” in sheet 1If thickness value found then fill the stock number in iproperty(project tab-stock number)
Here i am using different rules for plate, flat, round, etc.,
I know that to design for example a 3d curve i have to import a XYZ data points from excel. What if i wanna link these points from excel to Inventors curve? Everytime i change the excel file i want my curve to be updated.
View 9 Replies View RelatedI 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 RelatedI'm messing around with tables and data links, practicing. I copied a range of cells in Excel, and did paste special to create a linked table.
Now I can delete the table object, but I cannot delete the link, cannot detach it.
When in Data Manager if I right click on the data link and click delete I get the error message "The data link is being used and cannot be deleted".
I have tried detaching, and the detach does not seem to take.
Now also, the table will not update from the source xls.
Win XP, AcadLT 2011, Office 2010. Using compatible setting for saving spreadsheet, for Office 2007 (not xlsx).
If I create a linked table by starting with the Table icon, choose "from a data link", choose the excel spreadsheet, etc., then I am able to later update the table from the spreadsheet, detach, delete the link, etc. But I can only delete the link if the table is not selected when I open the Data Link Manager.
But the one that was created following the directions from the Autocad video, with the copy, paste special, that link will not detach nor delete.
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.
How to fix a broken link to an excel table in an idw file general table?I changed the folder name and heirarchy of the project.i expected the idw tables to find their parent excel files in the same folder with a new name, but they didn't.
I could find nothing for fixing broken excel links.
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 RelatedI was looking for some iLogic Code for Inventor 2013 that would cycle through all the parts in an assembly grabbing the quantity of each part and setting it equal to the custom property "Qty" of each part.
Having a little trouble creating the for each loop and setting reference to each part without referencing each part by specific name.
We have a whole bunch of spreadsheets that we use for calculations and parts of those spreadsheets are linked to a ton of CAD Drawings via data links.
We would like to be able to deliver the CAD drawings to the client without having to send our calculation books (just the output tables). In other words, is it possible to embed the table data and remove the excel link for the final delivery?
i'm trying to link excel to autocad for a time now. and until now it didn't work for me.
Everytime it says "1 data link(s) do not allow their data to be written out." thats when i try to write it to the excel file.
We have tremendous problem in our office while we open the CAD files which have linked to excel tables. It takes endless loading time if any computer has excell sheets opened. We use copy / paste special ( linked ) command to brought excel tables to the DWG files. OLE OBJECT command has worst result about linking excel sheets. How do we control ( link option) in this stution as linked versus unlinked?
View 1 Replies View RelatedI am trying to link an excel spreadsheet to my acad but I can't see it once i've linked to it?
View 2 Replies View RelatedWhen trying to insert a table linked to an Excel 2010 file, it works up until row 28, however, as soon as I add a 29th row to the table it no longer inserts the table. When I try and insert it, I press ok and nothing happens. I tried inserting it as a smaller table and changing the data link to a bigger range after it was inserted, it just didn't update to a larger range.
Is there a way of getting this to work without having to insert it as two different tables?
I had a bit of a search around the net and what I found mostly said it can't be done natively in AutoCad although I thought I might as well ask anyway.
I want to link individual mtext objects in AutoCad to cell contents in an Excel file (like a datalink for a table, but I can't use a table in this instance). Any thoughts?
If it is not possible it is not a huge deal although hopefully the design doesn't change in the future as it will be a pain to update all these manually
I'm trying to link a text from Autocad to an excel spreadsheet so that when changed in Excel, be changed in autocad.
After searching on some forums, I started doing database through ODBC.
I made a table in excel selecting and naming fields, added the file in windows OBDC manager, able to make the connection through dbConnect autocad, created label ...
Now I need to put the information in the database autocad text entity and already there I'm not getting more done
I want to link an excel sheet with a drawing, so changing the excel changes the drawing.
I used this awesome site to learn about going to Edit->Paste Special->Paste Link->AutoCAD Entities...but I don't have that choice. Just the one that makes the OLE image. While that will work, that is less than ideal. It appears in just normal paste, but not under paste link.
AutoCAD 2007, A.54; Excel 2003 SP3; Windows XP SP3.
designer has Excel 2007 and cad 2012 LT. He linked a table into the plans.
I have Excel 2010 and cad 2012. I opened the plans, i double click on the table he just inserted with 'paste special link', and the excel table will not open for me to edit.
When I linked the same table into the plans, he was unable to double click the table in cad to open the table to edit it.
the cad error is 'FAILED TO LAUNCH SERVER APPLICATION'
I am not sure if it is because he has cad 2012 LT and I have the full version?
Is it cause the different version of Excel?
I'm trying to link excel to autocad for a time now.
and until now it didn't work for me.
Everytime it says "1 data link(s) do not allow their data to be written out."
thats when i try to write it to the excel file.
We are a MEP firm, using AutoCAD 2011 and Excel 2007, and our project is a building with 1000+ rooms. Each room has specified supply and return airflows that need to show up in text in each of the rooms. All the airflow values are calculated in a spreadsheet.
My thought is to use fields in the text that shows up in each room, then link each field to a specific cell in Excel, because these values will be evolving over the next year.
I have made a data link to an excel file. Then I bring it in as a table. I then adjust the text height and remove all formatting from the table. Unfortunately, after closing and re-opening the file, the table changes. I lose formating/cell alignment/text height. It isn't even consistent across the table. The lost formatting is only on the 2nd split of the table, the first side retains the corrected formatting. I have selected the option to not update excel formatting. I don't even get a notification the table is updating. There haven't been any changes to the excel sheet either....
View 6 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
I want to link Microsoft Excel data with AutoCAD drawing (like dimension or values). When I made some changes in Excel data, value in AutoCAD drawing can be changes automatically.
View 1 Replies View Relatedway I can link my AutoCAD title block attributes to excel and make changes in either excel or AutoCAD and then be able to run an update? The attributes would be “REV” “DWG_NO” “TITLE” “LOCATION” “DRAWING_SIZE” and “FILE NAME”.
View 4 Replies View RelatedI would like to link a series of text lines in an autocad drawing to there corresponding fields in an excel sheet, I can not use tables in autocad because of the way other software uses the text in autocad. I have attached files of the text layout in acad and of the sheet in excel. One thing that keeps me from using tables in acad is that every line of text is on a different layer, with tables you can't control the layer of table its always on the current layer.
View 6 Replies View Related