AutoCAD Inventor :: Export Start And End Point Of Various Lines In Sketch To Excel File?
Oct 26, 2012
I have been searching for a macro to export the start and end point of a line coordinates to excel, but I can only find information on how to export 3D Points.
Is it possible to program a macro that allows me to export the start and end point of various lines in a sketch?
The objective of this is to connect an excel file which is updated when I create a line with it correspondent points, then i could not only import these x,y,z coordinates from excel to inventor but I whould be able to update my spreedsheet whenever I change my sketch.
View 1 Replies
ADVERTISEMENT
Apr 24, 2012
how do I retrieve the centre point in my design axis in Inventor, when I create a new sketch, like the point at x0:y0:z0
View 2 Replies
View Related
Oct 29, 2013
In assembly mode, how can I click on two lines in a part sketch and get there intersection point using VBA?
View 3 Replies
View Related
Nov 11, 2013
I'm trying to start Excel and show the results of some BOM items I have written to a file like item number, part number and description.The task is to find components in an assembly that have a part number longer then 39 characters, due to ERP limitations.
What I´m doing is cycling through all BOM (structured) items on first level and check if the part number is longer then 39 characters.
I write these item number, part number, description to an Excel file (temp.xlsx), so the user sees which Components he has to check for the Part Number (make it shorter). I figured it would be best to do that with an excel file, so the user can save the results to a new file or just check it.
Values will be erased from the temporary excel file afterwards.Here I can't figure out how to start the excel application and open the file in an actual application window if possible.
how to list the results with plain iLogic that would do it too or some other solution to list a snapshot from the BOM.I guess there is no way to add your custom BOMViews ?
View 6 Replies
View Related
Nov 15, 2011
I want to add say a circle and an arrow at the two ends of a line. I am able to do it using Blocks for one single line by inserting the blocks at desired locations. But how to do it for say all the lines in a drawing or shape file without customization.
View 1 Replies
View Related
Oct 26, 2013
I have to draw hundreds of lines that have same start point. How can i do this?
I am trying to insert a picture but seem impossible for me. Sow i have lines with the same start point and different endpoints. There is a short way to do this. so avoid to enter the same start point for hundreds times or snap the the same point infinitely... what about Copy with grips or Change command in this case?
View 3 Replies
View Related
Dec 3, 2013
I was trying to query some sketch points data from a profile Path using code as below. However the program stopped without telling the reason.
Code below:
i = 0;
foreach (ProfileEntity oSourceProfileEntity in oProfilePath) { switch (oProfilePath[i].SketchEntity.Type) { case ObjectTypeEnum.kSketchArcObject: { SketchArc srcSkArc = default(SketchArc); srcSkArc = (SketchArc) oSourceProfileEntity.SketchEntity; // error points[i] = srcSkArc.StartSketchPoint.Geometry; break; } default: { SketchLine srcSkLine = default(SketchLine); srcSkLine =(SketchLine) oProfilePath[i].SketchEntity; // error points[i] = srcSkLine.StartSketchPoint.Geometry; break; } } i++; }
View 2 Replies
View Related
Jan 28, 2013
Is there any way to make 2 to sketch lines instead of floating lines so that I can dimension them?
For example, if I have a part that can change lengths and I need to print off a new drawing, it would be good if I could say that the lines were a set distance from each end of the part or some features of the part.
Then I could update the part length, then just open the part drawing and not have to adjust anything.
View 1 Replies
View Related
Jun 25, 2013
When I use the import excel points function in the 2D sketch menu of Inventor 2013, nothing happens when I open the excel file. No points are drawn in the sketch... I don't even get an error message... I have tried the same thing on another computer with the exact same spreadsheet and it works 100%.
I'm running Inventor 2013 service pack 2 on a Lenovo Y570 with an Nvidia GeForce GT555M GFX card
View 2 Replies
View Related
Dec 4, 2012
I am trying to export each sheet in an Excel file to an separateTXT files.
I currently have code to read each cell in a sheet, but unfortunately some of the Excel sheets have in excess of 5000 cells and it is taking too long to read. So I am switching to another method.
The program will check dates of TXT files and XLS file to make sure TXT files are current (if not, open and recreate TXT files).Then read the TXT files (much faster).
Where I am getting stuck is 2 places -
Get the names of each sheet in the excel file (not always a known name)
Save each sheet as separate TXT file.
Here is condensed code so far without error checking, etc -
(defun E2TXT (FileName /)
(if (and (setq XLfile (findfile FileName)) (vl-file-systime XLfile) (setq XLapp (vlax-get-or-create-object "Excel.Application")))
(progn
[Code]....
View 4 Replies
View Related
Aug 1, 2011
First we imported an ".igs" file to inventor, which produced "wires". Then by promoting the wires it produced a 3-d sketch.
The model is in one plane and 2-D, and we are trying to use Ansys 2-D analysis, but in-order to do so it needs to be in a 2-D sketch.
The model is too large to be redrawn on a 2-D plane, how to convert it to a 2-D sketch
View 9 Replies
View Related
Oct 13, 2011
does AutoCad 2012 LT version can export text to csv or excel file
View 2 Replies
View Related
Oct 13, 2011
Can I export the text from autocad 2012 LT to excel file.
View 1 Replies
View Related
Jan 18, 2012
I use vb.net draw a cube frame (just point and add edge to link points) in 3dsketch. But at the corner, I got only one edge, the others are filled that is a arc is inserted between the 2nd & 3rd edge to the corner point. There is no second edge is extended to that point.
Just wondering why I got the result. There is no fillet command in my code.
View 1 Replies
View Related
Dec 15, 2012
I want to concide two points of two different lines.These two lines have been created in two different workplanes with 2D sketch.
View 7 Replies
View Related
Jan 17, 2012
I'm trying to contrain the end points of 2 lines using iLogic. I know the end points but I cannot get the values into the SketchPoint object. The real odd thing is I can create the lines no problem. I tried it 2 different ways shown below. The first way gives me this error..."Object reference not set to an instance of an object.". The second says "Unable to cast COM object.."
Dim oTG As TransientGeometry
oTG = ThisApplication.TransientGeometry
Dim EntityEndPt As SketchPoint
EndPtX = 0 * 2.54
EndPtY = 3 * 2.54
‘Code Fails Here!
EntityStartPt.Geometry.X = EndPtX
View 5 Replies
View Related
Nov 11, 2013
I just want to know that how can I get the center point from a Sketch Object ?
View 1 Replies
View Related
Mar 16, 2012
How would one add a sketch-point to a midpoint of an arc? For a SketchLine its easy...
oSketch.GeometricConstraints.AddMidpoint oSketchPoint, oSketchLine
However, I can't see how to do the same operation to find the midpoint of a SketchArc. The interface of course has a selection filter for this so I assume the API can do the same?
View 6 Replies
View Related
Apr 5, 2013
This has happened on all versions of AutoCAD in our office.
I paste schedules from Excel into AutoCAD. I print out the sheets and ghost lines appear on the PDF and hard copy that were not intentionally place in the excel file. What is happening and what can be done about it.
I also paste a tif file on a sheet change the setting to imageframe <0> and a residual line willl appear in pdf and hard copy that seems to be the border of the tif image.
View 4 Replies
View Related
Feb 8, 2012
I have a lot of AutoCAD files which have embedded OLE objects (excel) inside. I want to be able to export only the text from the Excel OLE object using VBA (or Lisp, I don't mind which) without having to fire up the OLE application (i.e. Excel).
The embedded OLE objects have no link to any external files - so I imagine it must all be held somehow inside the AutoCAD file, but how it can be accessed?!!?
View 2 Replies
View Related
Oct 14, 2011
can i export from autocad 2012 LT text and how can i export text from autocad 2012 LT to excel file
View 2 Replies
View Related
May 6, 2013
The screen shot below shows three coincident constraints and a projection icon on the origin.
looks like a projection icon - what does it mean?
I want to delete the three coincident constraints. But when I delete the coincident constraints there is no Sketch origin center point (the sketch origin center point is a square-yellow dot at the x-y intersection). How to delete or move the three coincident constraints with out deleting the sketch origin center point?
View 2 Replies
View Related
Oct 4, 2011
I have this assembly shown in the pic. below. I'm trying to create a point or axis in the blue corner points (to attaches something later on) but it just won't let me choose it for some reason. I know that it's possible to to do that (almost sure I already done this trivial thing in inventor.)
Any reason it's not letting me choose the sketch points/line to in order to create points or axis(s)?
Inventor 2012 Pro.
I7 workstation
View 8 Replies
View Related
Sep 27, 2013
I cannot make a plane parallel to a surface and through a sketch point.
I can't also select the sketch point or line in order to make an axis. the sketch point, line from the sketch or anything from a sketch isn't selectable.
View 4 Replies
View Related
Sep 20, 2013
It goes f.e. like this:
I draw a line (no constrains) and I can move it by grabing an end or whole line by click&hold mouse button, great.
But after couple minutes of work with part and sketches I can't grab anything. Even on new created sketches and new lines. Click and drag just open rectangle selection. Oh, between these phases there is a phase when 2nd click&hold works...
When I open/create another part it is normall, but this one I must close and open again.
View 2 Replies
View Related
Jun 28, 2012
MEP 2013
Can you export an OLE object from a DWG back to an Excel file/document?
View 1 Replies
View Related
Oct 19, 2011
Inventor 2010
Some how I turned off the snap to end point in the sketch mode. where is the dialog box to control snap settings
View 2 Replies
View Related
Jul 11, 2012
I would like to use iLogic to find the location of the points of a line, determine if the line is approximately vertical, and apply a vertical constraint if it is vertical.
Here is the code process I envision:
1. Automatically select a straight line.
2. Find the location of its end points.
3. Compare the X-value of the end points to see if they are vertically aligned (or almost so).
4. If they are vertically aligned, apply a vertical constraint.
5. Select next line and repeat.
Is this possible with iLogic? I don't see any way of calling a line's sketch points or finding their location.
View 4 Replies
View Related
Jul 9, 2013
I know why you cant loop select and offset the rectangle but surley if you are going to take the time to listen to users and create requested tools, you should do it well?
View 4 Replies
View Related
Mar 10, 2013
I see that keyboard shortcuts in revit 2013 can be eported as xml and imported back from an xml? Is it possible to export the shorcut list as a simple txt file or excel file, for printing purpose. Some of the bim modellers in my office would like to print the shorcut and stick it on their desk.
View 2 Replies
View Related
Dec 18, 2013
Cant figure this out - I create a sketch in a drawing, but I cant see the lines as I'm drawing them. The lines are on a "solid" layer set to red as defined in my standard. The background of my drawings is black. When the line command is done, the line appears and it's red. Problem is I cant see it as I'm sketching. Is there any way to modify this? Can I have the line appear red (or white) as I'm sketching?
Product Design Suite Ultimate 2014
Vault Professional 2014
Windows 7 Pro SP1
HP-Z400: 2.67 GHz 12 Gb Ram
Nvidia Quadro FX1800 driver 276.42
View 2 Replies
View Related
