I 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 RepliesI'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 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'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 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 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 try to Draw Transmission Tower with Autocad and I have the coordinates of joints of this model on notepad I try to import it to autocad with many way it not succeed, how can I do this and drawing the members (line between joints) easily with autocad 2007 .
View 9 Replies View RelatedMy drawing settings is set for US Feet. My Data Collector is set for US Feet. I only import a txt file into the drawing. My txt file coordinates match my Data Collector but never in the drawing. We're only talking about hundredth but I don't understand why it changes in the first place.
Example
Point 1 in txt file & DC --- 10000N 5000E
but in drawing --- 9999.98N 4999.99E
Point 2 in txt file & DC ---- 9624.7230N, 4971.5346E
in drawing ----- 9624.7422N, 4971.5445E
I need to import a series of XY coordinates into AutoCAD LT from a .txt/.csv file in order to plot the as-laid position of a subsea cable - I dont really feel like entering 212 sets of E/N coordinates manually!
View 1 Replies View RelatedIs it possible to import real time gps coordinates from Leica CS10 to Autocad? Is it a function in Autocad or will i need a third part software to accomplish that?
View 2 Replies View RelatedI have an excel file containing xyz co-ordinates that i wish to import to AutoCAD (2005).
I realise you can probably do this using the lisp function, but i don't know how they work, and wanted to know if there is an easier way.
I've to put some data as like table beside the figure. I've these data in a excel sheet. Can i import that sheet in CAD? or I need use table and re-type all data?
View 4 Replies View RelatedI work as an engineer for a solar company. We preform all of our calculations on an excel file, then transfer these values to Autocad to show our calculations for the plan checkers. I use the DWGPROPS command in Autocad to auto populate all the pages in my plans. I tend to do a lot of copy and pasting and to do all this.
Is there a way to isolate the excel values I need and import them into my Autocad DWGPROPS?
I need to know if I can import an excel formula for a Von Karmen rocket nosecone and then model it. I do not know how to do 3D modeling only 2D. Is this possible? I would like to do the model isometric if possible. I also have some questions about doing an isometric drawing, but i'll try to figure that out on my own this week at home.
View 7 Replies View RelatedI want to insert or import an image that automatically recognizes my drawing coordinates.If I need to, I can use AUD (as Map 3D).However, my computer has difficulty processing too much data.
View 7 Replies View RelatedI have an excel file with a column containing polygon vertices like follows:
Row 1 x-Cord1|y-Cord1 x-Cord2|y-Cord2 x-Cord3|y-Cord3....
Row 2 x-Cord1|y-Cord1 x-Cord2|y-Cord2 x-Cord3|y-Cord3....
Row 3 x-Cord1|y-Cord1 x-Cord2|y-Cord2 x-Cord3|y-Cord3....
I am looking for a .Net code that can read each row cell and draw the polygons automatically in AutoCAD window. I am having a bout 100 rows (polygons) and hence I prefer that the code will display all polygons at once in AutoCAD window and not draw them one by one.
I am already having Autolisp code to draw them one by one but I wish to have a .Net code to allow batch polygons drawing instead.
when I use the tool "import points from excel to inventor" in sketch mode, it looks fine. I pick the option "create lines". is there any way to create one line by one line? because inventor will give you "Z" shape when you create two different line in different "row".
spec: window 7 64bit with inventor 2012
If it's possible to import Excel spreadsheets into my drawing, instead of using the tables? (Using AutoCAD LT 2014)
I guess technically it would be easiest if I could import LibreOffice Calc spreadsheets, but I can get access to Excel easily enough if it's the only option.
How to import data from excel (from particular cell) to AutoCAD Drawing. I have already Created a template for both Excel and AutoCAD. I want to do Whenever i am changing the datas in excel sheet corresponding changes to be done in AutoCAd drawing.
I am using AutoCAD 2010 and Microsoft excel 2007.
I am using Auto Cad LT 2012. How do I import an Excel spreadsheet into my drawing?
View 2 Replies View RelatedIm struggeling with creating a code that opens a certain Excel spreadsheet and retrieves / inserts info.
the spreadsheet is a list containing part numbers for purchased components, therefore the list must be filled with information from iproperty. But it has to be where the next available number is. i had this working in iLogic, but have to move it to VBA for better use. the code that worked in iLogic is this one.:
[URL]
If possible it would be nice if the code at the same time retrieves the new partnumber and saves the active part as this part numeber...
How can I import excel data for a hydrograph into SSA for a sub basin? I have 10 subbasins each with their own hydrograph.
View 1 Replies View RelatedWe are trying to switch to a new parts list format, and the goal is to have all of our parts list imported from excel spreadsheets. The problem we are having is that we cannot import from excel and maintain the format from excel. The problem seems to be with merged cells. I have tried it both by: 1) Annotate > General > Table and 2) Manage > Insert > Insert Object with no success. I have a non-ideal work-around for this by inserting the "QTY PER ASSY" separately as a sketch symbol.
Attached is a sample of what we would like our parts list to look like. The red rectangle outline is what would be imported from excel.
I am looking to import an excel file to creat points within LT 2012. Can this be done?
View 4 Replies View RelatedI am creating a template for my company with associated description keysets. The codes and attributes have already been created in an excel spreadsheet. Currently I am typing these all individually by hand but would like to import the excel data if possible.
View 2 Replies View RelatedIs there a way of importing cad by shared coordinates, or are autodesk working on this for the next service pack, which would be very useful.
It's great that the 'link cad' does it but why not import cad? This would be very useful as we model certain things (pipework statues,) from point cloud and model on other software, then we bring into revit, so we use the same coordinates as the point cloud (O.S coordinates.)
Also I'm glad that Autodesk have added the shared coordinates to the point cloud insert for Revit 2013.