I know you can insert an Excel spread sheet into the general table and have that show up on the drawing, but it has limitations to it that Excel gives you. My question is there a way to bring the Excel spread sheet into the drawing that would give you Excel functionality?
View 9 RepliesI just upgraded from AutoCAD LT 2004 to 2006. The work that I have been doing requires that I insert Excel spreadsheets on all of my drawings. In 2004 it was quite easy to size the spreadsheet.
When you pasted it AutoCAD LT would prompt me for a size which would get me close and then I could drag the corners to perfectly fit the spreadsheet. With 2006 it does not prompt me for a size AND dragging a corner is not as easy. Sometimes it will not let me drag it smaller. I then have to use the scale command.
I am trying to link a Excel spread sheet to an Inventor 2009 part. It worked great on Friday now it is not working. The only thing that changed was that there was a windos update. When it does work I am unable to update any of the parametes that are linked to Excel file as the update button has disappear.
View 2 Replies View RelatedI am trying to find an automated way to rename multiple sheets when creating Inventor drawings.
I have an Inventor assembly, and I need to create a drawing for each component in this assembly. I have one Inventor Drawing with multiple sheets in it. Each sheet is for each part in the assembly.
I would like to loop though each sheet and rename the sheet name to the Part number of the part. Is there a simple way to do this though i Logic? And how would I go about doing something like this?
I've got a drawing that is 14"x12" and have a printer that can only handle 8.5 x 11 sheets. I need to print it out full scale because I plan on using the drawing to cut something out. In school, I have seen my teacher print the drawing across multiple sheets, and then he simply tapes the sheets together. I have tried every configuration possible and have had no success.
View 1 Replies View RelatedIs there a way of inserting points from an excel spreadsheet that come into the part file already fixed, instead of manually selecting the points and selecting the fix constraint?
View 2 Replies View RelatedI want to insert simple JPEG images into IDW drawings but the button for images is grey and cant be used.
I tried in sketch mode but it is the same grey button
Seriously is this not available?
Or whats the "trick" to insert a simple image?
I am very new to autocad and i am using 2013 student..
1) I have drawn a curved line for a Directional Drill Shot and need to create a points on it every 2 metres to give a Cord position,
2)I need to be able to transfer these points into a excel spread sheet.
If you review the attached screen shot of a PDF you will see that my Excel spreadsheet object prints very light. This is added to a Paper Space layer that is same layer as the Title Block, which is printing fine. The colorful solid objects are each in their own viewports.
I have set the OLE property "Plot Quality" to "Monochrome", also I have set the "Plot Style Table" to "monochrome.ctb".
To place the spreadsheet table I have Excel open, I select the columns/rows that I want and then Ctrl-C, I flip over to ACAD and Ctrl-V to place the object, I then resize it by dragging its handles. On screen, in ACAD, it looks fine.
I am creating the PDF using "Cute PDF Writer", which does an excellent job creating PDFs from many applications. I don't think it's related to my problem. I have tried ACAD's "DWG To PDF.pc3", but had a similar problem, but worse in other aspects.
When I insert a drawing from ACAD into an Inventor sketch I get the geometry I want but also allot of points or blocks are inserted also that are not in the original ACAD drawing at all. I cant pick these points to delete them even though they highlight when picked.......
View 2 Replies View RelatedI have a job to photograph 300 items and use lightroom to number each one with its own product code.
Then I need to add the barcodes to the images so the client can scan them
They have a spread sheet with all the data on but can a sript be written to do this action ???
I have a spreadsheet in Excel that is split into columns. The first is the frame number, and the subsequent columns are the rotations about the X, Y and Z axis. There is also a column that has the location in the Z axis from the origin (0). These values are currently being input manually and keyed. The object being animated is a locator node which will form the parent of an object.
Is there a way to have these values read in automatically and for each frame to then be keyed to that value?
As I've never touched MEL or Python I wouldn't have a clue where to start trying to write some sort of script to do this.
shouldn't sheets marked as "exclude from count" not be counted?
I tried this in both 2013 and 2012 to see if maybe AutoDesk broke it, but it doesn't work in either one. This is easily reproducible for me, a file shouldn't be necessary. Just open up (or create) a multi sheet drawing. Go to edit sheet on one or two of them and check the "exclude form count" box. Now create a new iLogic rule and put the following line into it:
MsgBox("This is the number of sheets in the drawing: " & ThisDoc.Document.Sheets.Count, VBOkOnly, "Number of Sheets")
tried to insert Excel tables into 2013 3D? It worked fine in 2012 but we just upgraded to 2013 and it no longer works. We get an error message that Excel is not supported. Is this a new feature or a bug? Also, our old drawings with the table already inserted does not plot normally. The table characters print at diffent sizes.
View 9 Replies View Relatedwas wondering if it's possible to bring in the value of a single Excel cell into a predefined window area in AutoCAD LT 2012? Some of our tool and die calculations are done in Excel, but we only want one cell (equation summary or description) brought into to AutoCAD 2007. If not AutoCAD LT 2007, then what about a more recent version of LT or even full blown AutoCAD?
View 1 Replies View RelatedI have two drawing files of arrows. One inserts uniformly and the other assumes that I want to specify the X and Y scaling separately. These drawing files do not contain blocks at the moment, but may have as some point in the past. I can't find anything in the drawing files that sets the block scaling when there isn't a block in the drawing, but one of them is behaving as if there is and the other one is not. How do I change all of my similar drawing files to insert scaled uniformly?
I see the option to scale uniformly on the insert dialog box, but I need this for a script, so I need to use the command line version.
Here is a copy of my command line for inserting the two drawing files:
Command:
-INSERT Enter block name or [?]: Sign-Arrow-12-A-Left
Units: Inches Conversion: 1.0000
Specify insertion point or [Basepoint/Scale/Rotate]: 0,0
Specify scale factor <1>:
Specify rotation angle <0>:
Command:
-INSERT Enter block name or [?] <Sign-Arrow-12-A-Left>: Sign-Arrow-16-A-Left
Units: Inches Conversion: 1.0000
Specify insertion point or [Basepoint/Scale/X/Y/Z/Rotate]: 0,6
Enter X scale factor, specify opposite corner, or [Corner/XYZ] <1>:
Enter Y scale factor <use X scale factor>:
Specify rotation angle <0>:
Command:
Note that the first time Sign-Arrow-12-A-Left comes in with no reference to option X/Y/Z, but the second time Sign-Arrow-16-A-Left has the option, and there for requires the extra line of input.
I need to insert gypsum board and wood siding and insulation into my drawings.
View 1 Replies View RelatedI'm trying to figure out a way to do the following:
I have several drawing files in DWG. Each DWG has a block placed in a drawing sheet. The block contains attributes which would like to link to an Excel file.
Then if I update the attribute in the drawings this would change the linked attribute in the Excel file, and vice versa.
Note that there are several drawings which I would like to handle in a single Excel file.
I'm using Office 2010 and AutoCAD 2014.
When I copylink a layout into Excel, there are no cropping handles.
I need to be able to embed the drawing into excel, then be able to crop it.
I am not a user of AutoCAD and i am only using it to try and convert the drawings that i have into an excel or csv format.....
I am running AutoCAD 2009 and the drawings are "tables" per say.....with a generic block template from an engineering company, along with text and the company logo.
Is there a way to bring this into excel for easy formatting as i am not an experienced or trained AutoCAD person.....
This probably isn't the correct discussion group but not sure where else to post this.
My sales department wants to be able to create drawings based on entries in selected in their Excel qouting tool. Basically, they want to configure a product in the field, and be able to show the customer the drawing with TrueView. (They don't have AutoCAD installed).
I would think the best I can do, is manipulate a .dxf file based on their selections but that may get very complicated.
I am using AutoCAD Mechanical 2013. (Full version).If there is SLD with different HP rating, tag names and different cable ferrule numbers, and if there is any small change in HP rating of motor or small change in tag name, then it is time consuming work for me to go to AutoCAD and change the text by referring Excel sheet.
Is there any way to link excel sheet to AutoCAD drawings? So i can take updated excel sheet and link it with AutoCAD and if there is any change in excel sheet then it will be updated in CAD file as well.If there is any setting or grid referencing to be made. I am ready to do the required changes to meet my requirement.
I have LT 2012. I use Excel 2010 into my drawings to set up tables. When I opened the drawing I've been working on, I had lost all of yesterday's data. Command History shows dozens of these notations, "AcDbLine(41859) XData Handle Unknown, Null" In Help it says you can no longer turn handles off, so it should be ON. How can I point the drawing to my Excel data?
View 2 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.
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.
View 6 Replies View RelatedIs it possible to spread text gathered from the part description on 2 lines? cause on 1 line is in this case to long.
Inventor 2013
I am trying to get the PDF macro to be hard coded to print all the sheets in an idw. I added this line (guessed at code basically), but it didn't work. Where do I find what the correct syntax should be for this code?
View 1 Replies View RelatedCopy sheets from one IDW to another?I thought I had successfully done this before, but maybe not.
View 4 Replies View RelatedIs there a way to assign different dimension styles to different sheets in an idw. I have idw drawings with several sheets and use a couple of different dimension styles depending on what is on each sheet. I've created the dimension styles I want to use but I don't know how to assign a dimension style to a specific sheet. For now what I am doing is dimensioning, then as needed for the dimensions that need a different style, right click on the dimension and select new dimension style to changes its dimension style. I would like to assign dimension styles to specific sheets, is there a way to do this? Even though borders, title blocks, etc. are the same throughout the sheets, do I need to create different sheet formats to do this?
View 6 Replies View RelatedI am trying to modify the code Brian Ekins posted on Mod the Machine to renumber balloons across sheets. [uRL ....
It works great unless the item on the additional sheet is a sub-assembly. I believe it is because PartDef is declared as a PartComponentDefinition and there is nothing in the code to handle an assembly.
Dim partDef As PartComponentDefinition
Set partDef = drawBOMRow.BOMRow.ComponentDefinitions.Item(1)
partInfo(I - 1).ReferencedFile = partDef.Document.FullFileName
The Set partDef line was giving me a runtime error when it came to an assembly in the BOM until I added
"On Error Resume Next" at the start of the loop.
I tried changing the declaration to ComponentDefinition. It compiled fine, but didn't do anything. I think I'll have to add some duplicate code to handle an assembly in the BOM. Is there a better way to do this? Am I even on the right track?
I am trying to control the layer visibility on different sheets of the same drawing but have not quite figured it out yet.
We add a DXF sheet to drawings with flat pattern views to export to DXF for our laser. I wrote a VBA macro that adds the sheet, copies the flat pattern view and removes the dimensions to clean it up before creating the DXF. I am having a problem turning off the visibility of the bend lines on JUST the DXF sheet. I can turn bend lines and hidden lines off with this:
'Turn off bend lines and hidden linesFor Each oView In oSheet.DrawingViews 'Set the layers collection Set oLayers = oDrawingDoc.StylesManager.Layers 'Turn off all bend lines and hidden lines For Each oLayer In oLayers If Not InStr(oLayer.Name, "Bend Centerline") = 0 Or Not InStr(oLayer.Name, "Hidden") = 0 Then oLayer.Visible = False Else End If Next Next
but it turns them off on all sheets. I want to only turn them off on the DXF sheet. How would this be done?
Inventor Professional 2014 64 Bit
Windows 7 Professional
NVIDIA Quadro FX 4600
Dual Intel Xeon E5540 CPUs
16GB DDR3 Ram