AutoCad :: Importing Coordinates (or Dimensions) From MS Excel 2007
Mar 26, 2011
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.
View 4 Replies
ADVERTISEMENT
Jan 9, 2012
was 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 Related
Oct 16, 2011
I have attempted to import a jpeg file into my current drawing, using the simple copy paste method, Insert> Raster image and Insert > External References, however the image is not appearing in my drawing or plot at all, though the command bar is doing it's thing.
View 1 Replies
View Related
Jul 16, 2013
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 Related
Feb 20, 2012
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 Replies
View Related
Mar 21, 2012
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.
View 1 Replies
View Related
Mar 2, 2007
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 Related
Jan 2, 2007
How do I transfer coordinates from excel 2003 to autocad 2004?
View 9 Replies
View Related
Aug 9, 2011
I'm trying to import a powerpoint 2007 file in X4, but coreldraw says that it doesn't support pptx format. the pdf of the powerpoint created is not upto the mark. my file contains flowcharts. I tried using the office pdf maker [the microsoft one] and doPDF 7 to create pdfs which were of bad quality. I want to import the shapes as vector which ain't happening
Windows 7 [64-bit], Core i3 - 3.02 GHz, 4GB DDR 3 RAM
View 5 Replies
View Related
Mar 19, 2013
I 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 Related
Feb 20, 2013
I 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 ?
View 4 Replies
View Related
Jun 6, 2012
I have Autocad Map3D 2010. I have a set of points in a CSV file containing points, latitude and longitude, in columns, that I want to import to a map and place the points (houses) in the appropriate locations with the house number. I click IMPORT, MAP IMPORT, select my file as PNE and the data in the preview window appears correctly. I'm using OH83-SF coordinate code which the map is. When I click OK it appears to have completed the command but nothing appears on the map and I get no error notifications. As a test I put an incorrect value in one of the lists and it did flag the error. I've tried space delimiters, commas, txt and Excell tables and always the same - nothing. I've tried the command line MULTIPLE POINTS and entered the geo coordinates and again - nothing appears on the map.
View 7 Replies
View Related
Sep 22, 2011
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 Related
Oct 11, 2012
if it's possible to import a list of coordinates into a drawing so that it places points in the drawing at the specified locations?
View 2 Replies
View Related
Jan 16, 2013
I am having difficulty importing coordinates into AutoCAD 2011.
The formats i am trying import are CSV and TXT files.
Is there any quick ways to do this?
View 9 Replies
View Related
May 8, 2012
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.
View 1 Replies
View Related
Dec 26, 2013
I have a drawing with so many rectangles in one layer. i want the sizes of those rectangles( ie L x B) is there any way to get the sizes of a rectangles from autocad and paste it into excel.
View 9 Replies
View Related
Mar 14, 2013
In a machine shop environment, the current practice is for an admin person to review the drawing, then take down all dimensions and enter them manually into Excel. Is there an easier way to export data to Excel so that I can have the dimension reports rather than doing them manually. The second question is on the ability to save the document as a .pdf, although I think this is possible.
View 4 Replies
View Related
Mar 6, 2013
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..
View 5 Replies
View Related
Jan 17, 2014
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 Related
Oct 1, 2003
whether it is possible to take dimensions from a simple engineering drawing and place them in an Excel workbook, currently running CAD2000.
View 5 Replies
View Related
Nov 13, 2012
Random objects on my artboard tend to change dimensions and/or coordinates on its own. The difference is by a few thousandth of a decimal. I'm not sure when this happens but it's usually happening to objects I'm not working on in the moment. And once and a while an object would refuse to comply when I try to readjust the dimension or coordinates.
Why this keeps happening and what I can do to stop it?
FYI: I am using CS5 on a Macbook Pro.
View 5 Replies
View Related
Jul 31, 2007
I'm trying to import an excel table into autocad. I can copy paste using ole and that works fine. It prints well, but when I print it as a PDF the file is not legible.
View 4 Replies
View Related
Apr 6, 2010
I am having a problem with my table that I insert from excel into ACAD 2010. The Data in excel is on automatic color and arial text, once imported into ACAD as ACAD entities the data in my table does not want to change to being bylayer as the cell type is set to but instead stays on white. The only way I can change the color is by entering the cell and changing it manually to bylayer.
View 9 Replies
View Related
Nov 29, 2013
I have a drawing with dimensions and number (number and text number). I want output (Can select each object) to a file excel. write a lisp do.
View 6 Replies
View Related
Oct 8, 2013
How do I export my IDW drawing dimensions to an Excel file for use on a First Article Inspection.
Is it even possible?
View 3 Replies
View Related
Feb 28, 2013
I am tryiny to import coordinate file like I have so many times and the Select File box keeps telling me "No point file format match found". I click the proper file format and it shows in the Preview box but the OK box will not go dark so I can clcik on it. The file is a CSv and tried making it a txt with no luck. Using 2012.
View 6 Replies
View Related
Dec 18, 2013
I have created a Excel spreadsheet to impoort into my Inventor model, but one of the valves that I have created need to be a unitless/type. How do I set up a Excel cell to acheive this
View 1 Replies
View Related
Jan 24, 2013
I 'm looking for a method to import the layers that I have exported from Civil 3D 2013 and have edited in Excel.
View 2 Replies
View Related
Feb 20, 2012
I want to import my excel table to autocad. but when i try to do this, the table is not correctly import. im using paste special command and past to link. if i paste my file excel, image and other formats, i can not plot my draw. i attach my excel file.
note: i found a software that name is autotable. but its 150$. we dont want to buy an other software.
View 1 Replies
View Related
Jun 22, 2012
is it possible to import a microsoft excel table to auto cad and have it be autocad lines and text? it is a rather large table and would save me alot of time if i didnt have to redraft it.
View 4 Replies
View Related
