I'm looking for a lisp that can list the coordinates of blocks to excel, as well as the block name.
I'm currently working an a drawing with 200+ soil samples for a road design, and I have to check the coordinates with a separate excel list.
I'm trying to build a VBA code in inventor 2010 to export the Center of gravity coordinates (X,Y,Z) from an inventor assembly to an excel sheet.
But I'm not able to get the iproperties for the COG from my assembly.
I did some work with ai and want to export the coordinates of my objects to csv or excel. Is this possible and if yes how?
View 2 Replies View RelatedI am looking for a quick way to take x,y coord. from excel and import them into autocad. I have read something on the MULTIPLE POINT command but every time I go and put the space in between the words it enters in multiple then point. I only have 10 data points but a lot of sets of points.
View 4 Replies View RelatedI am designing a RCC Dam and the shape of the dam is constant and will not change, but the dimensions of this shape are very likely to change depending upon hydraulic analysis.
I have written a program (irrelevant, but I am using MathCad 14) that performs a stability analysis of a RCC Dam (based on elevations from the hydraulic analysis) and then exports the dam dimensions and coordinates to Excel.
I am attempting to then take those coordinates (or dimensions) from Excel to create a 2-D dimensioned drawing of the Dam in AutoCAD.
I have successfully linked the Excel spreadsheet containing these coordinates and dimensions to AutoCad tables in my drawing, but I am having trouble getting AutoCAD to update my drawing as these tables update with different coordinates and dimensions.
I would like to have a drawing that is fully dimensioned (as the shape of the dam will not change), but that will update coordinates and dimensions as I pump out different dam dimensions from my stability analysis.
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 RelatedHow do I transfer coordinates from excel 2003 to autocad 2004?
View 9 Replies View RelatedI need to draw a table with point number, easting, northing, elevation for a lot of points and need a lisp to read the xl spreadsheet and draw the table.
View 9 Replies View RelatedI want to drawn LINE by excel data to autocad 2010, I have excel file x,y and z coordiates.
I want to draw line to import excel data coordiates to autocad ?
I'm trying to create about 150 cross-sections, each consisting of 9 closed polylines of which I have created the coordinates. My issue is making the list of coordinates create separate polylines instead of one enormous polyline. Any way to setup the columns, perhaps with blank rows, some way of applying ASCII code, etc. to automatically break up these polylines? (even if they aren't closed that's fine, I just need to make the polylines separate.)
View 1 Replies View RelatedI select one block to insert . However,how can I get the Blockname before select the insered point?
I found the BlockTableRecord.BlockInsertionPoints event. It is meaning that it can only apply to the whole BlockTableRecord type rather than some individual block references (AutoCAD INSERTs)
I got a new work and get it done in the next 2 days, but first I need to do this... from a text file (or excel file, I got both) I got 3 columns, 1 one for node number, and 2 other for X and Y coordinates for each node.
So from that file I need to insert into autocad the node numbers as text (using the current style and height) at the point specified by the other two columns, that are the X,Y coordinates which will be the insertion point of text..
I am looking for a method to export all the GPS coordinates which have been assigned to each point along with the properties of that point to an excel csv.
In our drawings, there are multiple columns and each column has four points and each point has X,Y,Z coordinates. I want to export all this information to an excel sheet.
We are a couple of students just starting at our finale thesis at the university. We got some problems that we can't find a resolution to.
We are going to use Ultramarine MOSES to simulate a ship. We got the drawings as 2d construction lines (.dwg) and 3d (.igs) of the ship, and need all the coordinates, x,y,z of all lines, to the coding in MOSES.
Our problem is to get these coordinates from autocad. We have tried to open the dwg in autocad and use dataextraction to get the coordinates without any sucess. We have also tried the igs without any sucess there as well.
I have a 3D part that produced from an assembly document. (pic.1). How can I take the coordinates of the curve that is designed on the right surface (pic.2) in a .txt or better .xls file ?
That curve I want to draw it in Excel.
My quick question id for an alternative way of exporting a cluster of points as .shp files and then manipulating the .dbf file in order to create an excel/csv file.
Is there another way of exporting my data as .csv or excel from Map3D?
I have a .DWG file and I need to export the coordinates of the points of the profile of the draw. How I can do it with AutoCAD?I specifiy that I have never used autocad.
View 3 Replies View RelatedHere is the problem; corridor and its surface, etc are designed but there is no "obvious" way to get coordinates in order to layout the road in the field. There is the option to get COGO points from corridor via "create COGO POINTS" / "CREATE GROUND DATA" but this option refers only to points based on baseline in any station of the corridor and not in any station i would like to.
View 5 Replies View RelatedI have a series of Polyface meshes imported from a Revit project.
(If this is doable straight from Revit that'd be good too, but I haven't had any success with that)
If I right click on one and select properties, I can clearly see where each vertex has an X, Y, and Z coordinate. For the purposes of a research project, I'd like to be able to automatically export all these coordinates to any ascii format for input into an algorithm. The dataextraction command does not seem to be capable of this and only exports the number of faces and vertices of each mesh.
I am looking for a method to export all the GPS coordinates which have been assigned to each point along with the properties of that point to an excel csv. In our drawings, there are multiple columns and each column has four points and each point has X,Y,Z coordinates. I want to export all this information to an excel sheet.
View 3 Replies View Related I'm designing a road, but I have a trouble how to export coordinates table of sample lines?
I need a table of coordinates X,Y of sample lines.
I have a question about exporting layouts into the model space coordinate system. I have a lot of drawings created from view frame and sheet set manager.
Each drawing has its own layout and it needs to be exported into model space. But when I export the layout it places the drawing into 0,0 in model space.
Is there any way to have it placed at the drawings coordinate system, assuming its in CA-VF (California State Plane Zone V, US foot) ?
Can it also be rotated, including title block, if the the viewport has a rotation (if the north arrow is not pointing up)?
We need to export the dwg's into dgn's. Our client uses Microstation v7 and all drawings need to be in that format.
I know v7 is old but what are you going to do.
I’m trying to export from my drawing point X-Y position coordinates to Excel for use in programming a metrology that will measure at these locations.
When I use the EATTEXT command to pull up the data extraction wizard, it will export the positions & extracts the locations to a spreadsheet format. But coordinate numbers I get, seem to be relative to the World USC system & not the origin I align & set in the center.
Yet when I use ID Point, to check positions the coordinates of the points are correct & relative to the center origin. How to get the location coordinates relative to the center USC origin I've located in the center of my part?
I'm working on a stream restoration project and we need to determine the x coordinates and corresponding elevations along a stream alignment at certain sample lines. The centerline of the stream's alignment has been created as well as sample lines for cross sections at 50' intervals. We need the coordinates & elevations of each sample line (cross section) exported into an excel/txt document.
For instance, at station 1+00 of the alignment we have a sample line. We need to know to the right and left along that sample line the corresponding elevations and that x coordinate) from the alignment. Primarily, whole contour intervals but more information would be useful as well. I was hoping this could be automatically generated.
I am currently working on a project where I am taking a lot of Autocad Attributes and Exporting them to an excel file so they can be referenced in a table of contents type of manner. My question is if there is a way to have excel automatically update the tables after changes are made to the autocad file. This file is an ever changing thing so going back and running through the entire "Eattext" command and re exporting and overwriting the existing file is very tiresome, especially when I am adding and deleting attributes daily. Is there a VBA program I can run to accomplish this task, I have fairly limited VBA skills and haven't written in VBA for years. I am fairly new to exporting autocad attributes to excel . I attached a very simplistic example of the general Idea of what I am trying to accomplish.
View 3 Replies View RelatedI want to export a table to excel but i am failed.and is here any way that when i give coordinate it automatically exportes to excel.
View 2 Replies View RelatedI am just starting learning lisp, And I am looking for a fast way to select multiple objects (usually circle) and export their coordinates and ID into a excel sheet through lisp programming.
As you might see in the attached drawing, the red circles are objects wanted. I have been trying to export their coordinates as well as their IDs in grids, e.g D28, Easting: Northing: . I still haven't found a good way to export ID for each circle.
As my code doesn't work, I wonder what's the most effective way to detect errors in lisp
I have assembly with over 100 sub assemblies. I need to export the COG for each sub assembly to excel. The COG must be in relation to the parent assembly's origin point.
I can get coordinates manualy (right click on sub assembly - iProperties-Phisical), but it is take a lots of time.
Autodesk Inventor Professional 2013
Windows 7 64-bit
Can export the repair details from dwg drawing prepared by asd in to excel by the use of auto cad?
View 3 Replies View Relatedi've been asked to provide a way for some cad employees to update via an export to an excel spreadsheet the latest area total for each room in the drawing. my assumption is the spreadsheet will already contain a column for room numbers from the drawing and a room area column.
so far i've found out how to iterate the drawing layers. what i have yet to figure out is how to capture the room area property on the layer so i can copy it into the excel cell that matches with the captured room number from the drawing. is there a way to access the geometry of the particular layer?
How do I get a BOM exported from my assembly into Excel? The only option I have is export as XML format which is useless to me.
View 9 Replies View Related