AutoCAD Inventor :: Embedding Excel Into Sheet Metal Template
Sep 7, 2012
How do you embed (not link) an excel spread sheet into my sheet metal template.
The excel file is simple, 2 rows listing the A1=gauge and B1= decimal equivalent.
What I want to do with this is to get the gauge to show up in the iProperties description along with length and width of part. The thing is I need column A to show up in the iProperties (12GA) but column B to be used for the sheet metal default thickness.
I keep getting this error when I run my code.
Error in rule: Gauge, in document: Part1
GoExcel: 3rd Party worksheet not found: "3rd Party:Embedding 1", Sheet: "Sheet1"
Code so far..
i = GoExcel.FindRow("3rd Party:Embedding 1", "Sheet1", "Gauge", "<=", iProperties.Value("Custom", "Gauge"))MultiValue.List("Thickness") = GoExcel.CellValues("3rd Party:Embedding 1", "Sheet1", "B2", "B35")
View 9 Replies
ADVERTISEMENT
Apr 18, 2012
A local search of my HD and a search on the subject here returned with zero results...
Where does one find the Inventor Sheet Metal Rules excel table for 2012 on a Windows 7 system?
All the documentation says it's located in the Documents and Settings directory, but Windows Vista eliminated that folder and thus it is not in Win7 either.
I can find the SheetMetalRules.xml file, but I need the excel table for modification.
View 3 Replies
View Related
Jan 3, 2012
Looking for 2012 sheet metal template with all the common plate sizes already in the rule?
View 6 Replies
View Related
Jan 10, 2008
Is there any way to set the default corner seam behavior in the sheet metal template? Right now a simple corner seam always puts a gap approximately the metal thickness, I need to make that smaller as the default behavior.
View 4 Replies
View Related
Oct 2, 2013
I'm trying to breath life into an old Sheet Metal template.It starts with the Non-Empty VBA warning.From there, "Run-time error '13': type mismatch
Debugging, here's my screen (attached). I don't know enough about VB to know where there's a problem.
View 2 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
Sep 27, 2011
I have trouble of embedding invetor view in excel 2007 with inventor 2011 installed and window 7 64bit.
I follow same steps in help file. when I try to register ocx file, it came out error "the call to dllregisterserver failed with error
code 0x80040200."
I try to change UAC and i am an admin too. it doesnt work. when I insert object in excel, the error is "cannot insert object"
Autodesk Inventor Professional 2014
Autodesk Product Design Suite Standard 2013
Microsoft Office 2007 & 2013
Windows 7 64bit
Synergis Adept 2013
Visual Studio Express 2010
View 5 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
Sep 12, 2013
A collegue asked me about this as he has been given a part to model and the details are for the flat sheet not the finished model. Is this possible in 'sheet metal'? I had a quick play but couldn't work it out. Im used to creating the finished part and 'un-folding' to get the flat pattern.Detail supplied below.
View 4 Replies
View Related
Aug 22, 2012
i am having a BOM template for the parametric modelling i have created using the excel sheet input link.
when i create the drawing from the model the default Bom part list is coming, instead of that i need to get the Excel Bom Template i have created based on the input excel link.
How to get the Excel Bom Template in the drawing.
View 1 Replies
View Related
Jul 14, 2012
I just what to cut a sheet metal,
and I don't know how (see in Capture.JPG where i what to cut, and test.iam what I what to cut).
Where is the icon "project the geometry" ?
View 6 Replies
View Related
Jan 6, 2012
I need a flat pattern for this part but it seems impossible. STEP 2 illustrate the desirable result.
View 7 Replies
View Related
Aug 21, 2013
Working with sheet metal and laying out a pattern for the cnc and was wondering if there is a way to imprint an extrusion onto the surface instead of cutting it. Mainly this will be used for a marking tool so the line type or layer would need to be different.
View 5 Replies
View Related
Aug 8, 2013
I am working on a bin type unit, and am having trouble creating a flange, I am creating the bin in the final product stage, then I will separate into manufacturer components. I am having trouble adding this flange around the top 4 edges of the bin. I need the four corners to meet on a miter 45. I will then rip down each seam and have 4 separate panels.
Is this a bad workflow? Is there a better route? I attached the part in Inventor 2013 format,
View 8 Replies
View Related
Dec 18, 2013
Attached are two sheet metal parts that we need to unfold and make them flat for a drawing. We cannot seem to capture the reference A or reference B planes asked for by the unfold command.
View 3 Replies
View Related
Jan 27, 2012
Is there a way to get the appearance of perforation on a sheet metal tube without having to create each and every hole? Looking for an appearance to drag onto the surface. Kind of like when you make a part look like it is made of brick. It being just an image on the model surface.
View 9 Replies
View Related
Oct 20, 2011
Very thin gauge aluminum sheets with a composite sandwiched between them.
The challenge is, the panels are relatively thick, 3mm or 4mm, but a router is used on the fold lines before bending to cut through all but the outer aluminum. This makes for a very tight bend radius.
So, thick 3 layer material, tight bend with mitered corners. Can Inventor's sheet metal tools handle this?
View 5 Replies
View Related
Apr 17, 2013
Can this part be made with sheet metal tools...it will be made from aluminum. I attach the shape made with standard tools and the sheet metal attempt.......how do add the sides in sheet metal.
View 4 Replies
View Related
Sep 6, 2012
how incredible it is that Inventor still does not have a functional normal cut option for sheet metal like Solidworks and Solidedge have long had and I agree. I realize that there are the standard workflows like using derive and thicken to get around this problem. However, for those interested, there is a way to make a normal cut (for laser/cnc) directly in the sheet metal part in many cases. It involves using a sketch to split a face and then using the resulting profile for a thicker/cut feature. I'm always interested in any other methods out there for obtaining normal cuts in complex sheet metal (for a clean dxf export). By the way, Autodesk, do you actually not have any plans of ever adding functionality in this area?
View 4 Replies
View Related
Feb 3, 2012
what's the best way to make tabs on a rolled round ring. I got it done using unfold/refold option but I can not get sheet metal flat.
View 4 Replies
View Related
Jul 3, 2012
I am using IV ultimate 2013
just found about this add-in:[URL]
But its not working for me:
I ran the installer, created a sheet metal part and hit rebuild all, it did not create any proeprties, also tried to manually create the properteis then hit rebuild, no go.
I also did a search on my hardrive for the ApplicationPlugins, and placed the sheet metal folder in all of them(there were 3) tried again noto.
The add-in also does not appear in the add-in manager.
Or is there different what to get the flat pattern dimensions in 2013
View 9 Replies
View Related
Dec 7, 2012
I have just modelled a part with some faces and tried to convert to sheet metal to have inventor make the bends between the faces. However when trying to convert to sheet metal i get the following error message (Autodesk Inventor Professional Tip) - "This model cannot be converted to Sheet Metal because it contains features that have created multiple bodies. In order to convert to Sheet Metal these features must first be removed."
As the picture show the part only has 1 solid. Even when deleting all features except the "base" face I get the same error message or Tip as Inventor calls it.
View 5 Replies
View Related
Dec 20, 2012
I have a sheet metal door with a little bracket that gets welded to the inside lip through a cut-out in the face of the door. (see assembly)
I can't get the cut-out to line up flush with the inside lip of the door, as that is where the brackets gets welded to. the current aseembly is set-up the way I want, but I can't get a flat pattern on the door, becasue of the cut going across the bend.
I have checked off the "cut across bend" in the cut dialogue box, but this leaves a small (~1/32) lip in the cut-out and runs interference in the placement of the bracket.
Inventor Pro Suite 2013
Sean Farr
Product Designer at TESInc.ca
Inventor Professional 2014-Update 2 - AutoCAD Electrical 2014
Win7-x64 | ASUS P8Z77-V | i7 3770 -3.4 GHz | 32GB RAM |
240GB SSD | nVidia GTX 670 4GB - 320.49
View 2 Replies
View Related
Oct 5, 2007
How can I create a sheet metal jog? Like the attached. I used a contor flange to creat this one, but I have to add a jog to an existing part and don't want to have to totally redraw it just to get the jog. I'm hoping you can add it like you can a flange.
View 9 Replies
View Related
Nov 13, 2011
I was designing a part which consisted in a circular sheet metal part with a hole in the center, and a bent rectangular radii-oriented section. The second feature is the one I want to give focus in this thread.
Take a circular sheet metal with a diameter of 30 mm and a thickness of 1 mm. Now, to achieve the bent section one would perform - in a workshop or any other equivalent - two parallel slices of about 5 mm in length with a distance from each other of 4 mm. The slice would start in the circumference and end somewhere nearer to the center of the disc, but not parallel to a radius (since its parallel to another slice 4 mm apart as said before). After the slicing was done, one would bend the section between the slices 90 degrees to any of the sides.
Now, in Inventor I couldn't find a way to do this. I couldn't just slice a line through the disc. I worked it around by cutting rectangles of 0.2 mm in width and with the length of the desired slices, and then using the folding command to bend it 90 degrees. Is it possible to perform this so called slices?
View 2 Replies
View Related
Apr 30, 2012
i want to export my part list with ilogic in a excel template but dont want all the part list column and dont erase the column i skip in excel?
View 3 Replies
View Related
Sep 3, 2013
I made a part in sheet metal and used the Cut tool for cut-outs...i tried by using flatten Patern,draw sketch but this did not cut part...is there a more better way of making these cuts?
INV 2013
View 2 Replies
View Related
Apr 30, 2013
I have been trying to work out how to make interlocking joints in sheet metal parts. The attached screen shot is the only way I have found to do it in Inventor, but it is a cheat. One of the flanges is a 85˚ bend because if it were 90˚ it would give an error "Flange Body intersects with existing body or self intersects."
View 4 Replies
View Related
May 7, 2012
I have setup all our Sheet Metal Rules to be all of our stocked in house sheet metals. The sheet metal rules are named like:
ALUM 5052 H32 1/2" (Part Number)
ST STEEL T304 3/8" (Part Number)
STEEL 44W 1/8" (Part Number)
etc.
And each rule has the proper thickness, material, and some standardized bend radius's. I've done this to introduce more uniformity in our designs, and to also allow the designer to put as much information into the model as possible, so that if someone else does the drawings, there is no question as to which material is used.
I now want to bring in the Sheet Metal Rule name into the drawing automatically. I can't seem to find a way to reference the Sheet Metal Rule directly from the drawing. What I need to do is pick a standard field in the i Properties (I used Stock Number), and put in =<Sheet Metal Rule> so that now the Stock Number references the Sheet Metal Rule, and then in the drawing I can just reference the Stock Number, and it will come in.
I don't like having to use the Stock Number as a middle man though, as none of our existing models are setup like this. Is it possible to reference Sheet Metal Rule in the drawing without having to use another field as a placeholder for the information?
View 7 Replies
View Related
Aug 2, 2012
I recently had an issue in adding flanges to a sheet metal part. The thread for that can be seen here:
[URL].......
The problem I am having now is with the size of the part. I need the linear distance from the bottom edge of a flange to match the inner diameter of my part. As you can see, this is not the case as it stands right now.
View 5 Replies
View Related
Oct 24, 2012
I am looking for a solid way of finding the Thickness parameter of a sheet metal part. I have tried two ways so far:
1. oCompDef.Parameters.Item(Thickness)
This works but if Inventor is installed with a different language pack like German for instance then it fails
2. oCompDef.Parameters.Item(1).Value
This also works but if the user started the part with a normal part template and then converts the part to a sheet metal part down the line, then this method fails.
View 1 Replies
View Related
