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
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.
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...
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?
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)
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")
We are a transport engineering firm in Queensland and I would like to develop a spreadsheet that can formulate cross member distances and recalculate to add or remove cross members.
The basis of this is the overall size of the body we are building.
For example: The maximum width of a body in Australia is 2.5metres overall. Our cross members would be 6 mm shorter than the overall width of the body to allow for 3mm end caps to cover the open ends of the cross members. So the length of the cross member is width minus 6, or , parametrically the length is (overall width - (endcap thickness x2))
The body length is the tricky one. We have a maximum spacing on the cross members. This will vary from size of body to size of body. EG the spacing on the small 2 tonne body will be different to the spacing on the 12 tonne body etc. So lets say we want to have maximum spacing of 450mm and a minimu spacing of 300mm between centrelines of the cross members. The overall length of the body will also determine the number of cross members required.
On top of this there is the front and rear coaming to take into consideration.
So the formula would be ((overall length - front coaming - rear coaming) divided by cross member spacing)) then a check to see if the last space is what and then can we change the cross member size to take up that space without going over the maximum space. We would also need to take into account the width of the cross member section as well in this calculation.
EG if we have 150mm left at the end we could increase the cross member centres slightly to take up this additional space without going over the maximum space allowable.
I would like to add a "Shoulder Bolt" fastener (both Inch & Metric) to the Clearance.xls file so that when selected it would generate a counterbore hole the size of the shaft and a corresponding thread specific to the bolt size (all of which I can input in the table) but currently I have to do this manually by selecting a "counterbore - thru thread" condition.
Also, we use Helicoil inserts a lot and would like to add this to the Thread.xls but I need Inventor to differentiate between a standard threaded hole & the Helicoil so that the hole callout on the drawing will come in as desired.
Inventor Professional 2013
how can I close an iLogic Form from either an iLogic Rule, or a VBA Rule (VBA is the Preferred method)?
View 5 Replies View RelatedIs there any way you can access an AutoCAD file embedded in an IDW by using VBA?I have an IDW with about 100 sheets; it would like to control which file is embedded in each of the sheets.
The best would be to use linked files but I do not know how to make certain files visible on certain sheets.
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?
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)
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
We have standard port details in JPG format that we frequently embed into a drawing via Manage -> Insert Object -> Create From File.
We've discovered that the JPG image does not display in Inventor View (which our co-workers use to view/print drawings).
I'd like to create pdf's with the 3D model embedded. This could then be viewed, rotated, and Zoomed.
Tetra4D is the software to do this as Adobe X no longer supports it.
How to use an embedded cursor (mycursor.cur) via the SetCursor command under user interaction events. I can use built in cursors just not able to get it working with my resource.
Sample below throws an error type mismatch.
oInteraction.SetCursor(CursorTypeEnum.kCursorTypeCustom, My.Resources.mycursor)
I have set the build action of the cursor to be embedded.
I am using Excel 2010 & LT 2012. I need to import spreadsheets into my drawings as OLE objects. For a while, the process worked fine - I could just copy to clipboard and paste the worksheet in as an image. For some reason, this is no longer working properly and the information will only insert as editable text, not the image of the formatted spreadsheet. Unfortunately I DO NOT want the information to be in an editable format. If I insert the worksheet as an OLE, only the first page will insert. The only solution I could come up with was to PDF each sheet of the worksheet and then PDFATTACH to the file.
I also do not have the AutoCAD Entities option of Paste Special. My only Paste Special options are Unicode Text, Text or OEM Text. I assume this is an LT difference.
Is there a setting or command that would allow me in insert the information as an image rather than Text...like I said, it worked properly for a while so I am thinking it might be a simple setting change...
Another issue is that when plotting spreadsheet information in CAD, it only registers 50% - the remaining information is not visible.
I have been having an issue when printing to PDF from AutoCAD my Excel spreadsheets show up with gridlines that are not there in there Excel or CAD. I have tried a number of things to eliminate that lines (see list below) but nothing has worked so far. I am running AutoCAD 2012 and Excel 2003. I have inserted the spreadsheet using "Paste Special" so that I can continue to work on the spreadsheet in excel and it will update in CAD.
- I have changes the Plot Quality. In Monochrome the lines print. Low quality the spreadsheet does not show up. High quality again nothing shows up
- In Excel I have turned off the "Gridlines" and re-copied into AutoCAD. The lines still show up when printing to PDF
- If I paste as an AutoCAD Entity I can not update in Excel
I have a new issue that I am unsure what to do about.
This has never occurred with previous version of ACAD and this is the first time I created data links with Autocad 2012, and I am using the same procedure that I have successfully used in the past.
I have data tables linked to excel spreadsheets. I used the "TABLE" button on the ANNOTATE ribbon to place the table, and the layout of the cells assumes the layout of the excel spreadsheet, which is what I want.
As long as I don't Scale the table, I can Update the data table links just fine.
However when I scale the table and then update table links, the table layout changes drastically, and is undesirable.
I have tried locking the cells' but that will not fix the problem.
I want to keep the layout of the table that is assumed when I place the table originally. Is there any way to lock it as such?
We had a client who could not open our drawings that had linked Excel spreadsheets in them even though we supplied the spreadsheets. The drawings would crash AutoCAD when they tried to open them.
My solution was to open the drawings, pick on the Linked Spreadsheet OLE in the drawing, Ctrl+C (Edit > Copy) then I Edit > Paste Special > As Image. I would paste it in at the lower left corner of the existing spreadsheet.
I set the properties of the new OLE so the Lock Aspect Ratio was Off or No and drag the upper right corner of my newly inserted image to the upper right corner of the existing linked spreadsheet so it would be a perfect match.
I then erased the existing linked spreadsheet.
Now they can open the files and we don't need to include the spreadsheet when we send the files.
[URL]....
I would like to link an Excel table to a SHP file via a column in commun. My SHP file and Excel Spreadsheet share one same column filled with numbers. So it's neither simply import Excel table, nor import with points.
But I don't know if I should use "Data Link" or "Add ODBC connection" or "FDO import", or some other fonctions...
how to extract pile coordinates to excel or spreadsheets, or anything that works and is quicker than just individual pile coordinates. i have about 446 piles.
View 9 Replies View RelatedI'm trying to create a series of DXFs for quick import into our CNC software. There's a bit of a gap between the design software (sadly not AutoCAD) and the CNC software, and we use AutoCAD to switch between them.
However, it takes FOREVER to manually create and layer hundreds of individual pieces and save them all as individual DXFs. Is it possible to generate a series of DXFs from spreadsheet data? Each DXF will just be a closed 4-sided polyline with a specific layer name, and a filename based on the name of the piece. That's it, nothing too complicated.
What I would like to do is find a way to use a dynamic block, which has already been created, and once I put in the proper length, speed, type of conveyor, etc., it will automatically update an excel spreadsheet, for example a power estimate, or cost estimate sheet. Is this possible, if so, what is the quickest, and easiest way to do this?
Also, what formula would I use in excel to link back to the DWG?
Regarding the conversion of an excel sheet into Illustrator variables... I am able to import an excel sheet into Illustrator datasets. I am curious if it is possible to link the excel file to the Illustrator data sets, so that when I alter something within the excel sheet, the data sets automatically change. Is this possible? Or must I always freshly convert/import the excel file?
View 2 Replies View RelatedI'm trying to use iLogic Design Copy to copy an assembly and all its associated parts to another directory. The assembly contains content center parts. Inventor warns me that the destination file of one of the CC parts (and 18 others) will be overwritten. When I go ahead and copy anyway, the copying process stops at that specific CC part. The Design Copy Progress dialog box states there is an error copying that CC part. When I close the Design Copy Progress dialog box, Inventor crashes.
The error copying the CC part: I'm allowed to use content center parts in iLogic Design Copied stuff, right? I searched some related topics and I'm under the impression that Inventor keeps the CC parts in its own directory and shouldn't be trying to overwrite them.
I am doing a tie rod the issue I have is when the length is between 2.001 and 2.250 we would drill thru all but only tap the ends .750 deep. If the part is 2.000 would would drill and tap thru in one step and not have to rotate the part in the lathe.
How do I get ilogic to understand if my number is between this 2.001 and 2.250 to lengthen the drill length parameter?Or add a mid plane cut? ( trying now code below reflects this try)
Not sure what way I want yet but I just can't seem to find a snippet or code to do this. I tried to add a list in the parameters for it to read but seems to do nothing.
If LENGTH <= "2" ThenFeature.IsActive("Thru_All") = TrueFeature.IsActive("Hole_A") = FalseFeature.IsActive("Hole_B") = FalseiProperties.Value("Project", "Description") = "RETURN ROLLER SHAFT, " & iProperties.Value("Custom", "DIAM") & " Ø S/S, TAP THRU 3/8-16, " & iProperties.Value("Custom", "LENGTH") & " LONG"ElseFeature.IsActive("Thru_All") = FalseFeature.IsActive("Hole_A") = TrueFeature.IsActive("Hole_B") = TrueiProperties.Value("Project", "Description") = "RETURN ROLLER SHAFT, " & iProperties.Value("Custom", "DIAM") & " Ø S/S, TAP BOTH ENDS 3/8-16, " & iProperties.Value("Custom", "LENGTH") & " LONG"End IfIf LENGTH = (My_List) ThenFeature.IsActive("Mid_Cut") = TrueElse Feature.IsActive("Mid_Cut") = FalseEnd If
Possible to run the 'import .xml structure' routine for an assembly BOM using either iLogic or VB?? I'm trying to replicate the Import button at the bottom of the BOM screen....
View 5 Replies View RelatedWhat I am trying to do is insert a part into an assembly file using iLogic. I basically want to mimic Inventor’s “Place” command using ilogic, maybe something like this:
oPath = ThisDoc.Path & ""
oFile = "File.ipt"
Component.Place(oPath & oFile, False)
This att. doc shows rule for exporting dxf out of drawing. It is working on one sheet just perfect. In multi sheets it save allways with same name. I want to choose from which sheet i need dxf but to be saved by sheet name or model properti name. Is that possible?
View 9 Replies View RelatedI have an external ilogic rule that creates a set of DWF drawings for all parts and subassemblies (as long as the idw files exist) within and including a main assembly.
I would like to merge all the DWF drawings of the sub assemblies and component parts into the DWF of the main assembly. Is there a method within DWFAddIn that will allow me to merge the files? Is there another way that I can merge the DWF files using the same ilogic rule (one rule to create and merge all DWF's together?)