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 RepliesI have been having an issue when printing to PDF from AutoCAD my Excel spreadsheets show up with gridlines that are not there in there Excel or CAD. I have tried a number of things to eliminate that lines (see list below) but nothing has worked so far. I am running AutoCAD 2012 and Excel 2003. I have inserted the spreadsheet using "Paste Special" so that I can continue to work on the spreadsheet in excel and it will update in CAD.
- I have changes the Plot Quality. In Monochrome the lines print. Low quality the spreadsheet does not show up. High quality again nothing shows up
- In Excel I have turned off the "Gridlines" and re-copied into AutoCAD. The lines still show up when printing to PDF
- If I paste as an AutoCAD Entity I can not update in Excel
I have a new issue that I am unsure what to do about.
This has never occurred with previous version of ACAD and this is the first time I created data links with Autocad 2012, and I am using the same procedure that I have successfully used in the past.
I have data tables linked to excel spreadsheets. I used the "TABLE" button on the ANNOTATE ribbon to place the table, and the layout of the cells assumes the layout of the excel spreadsheet, which is what I want.
As long as I don't Scale the table, I can Update the data table links just fine.
However when I scale the table and then update table links, the table layout changes drastically, and is undesirable.
I have tried locking the cells' but that will not fix the problem.
I want to keep the layout of the table that is assumed when I place the table originally. Is there any way to lock it as such?
We had a client who could not open our drawings that had linked Excel spreadsheets in them even though we supplied the spreadsheets. The drawings would crash AutoCAD when they tried to open them.
My solution was to open the drawings, pick on the Linked Spreadsheet OLE in the drawing, Ctrl+C (Edit > Copy) then I Edit > Paste Special > As Image. I would paste it in at the lower left corner of the existing spreadsheet.
I set the properties of the new OLE so the Lock Aspect Ratio was Off or No and drag the upper right corner of my newly inserted image to the upper right corner of the existing linked spreadsheet so it would be a perfect match.
I then erased the existing linked spreadsheet.
Now they can open the files and we don't need to include the spreadsheet when we send the files.
[URL]....
I would like to link an Excel table to a SHP file via a column in commun. My SHP file and Excel Spreadsheet share one same column filled with numbers. So it's neither simply import Excel table, nor import with points.
But I don't know if I should use "Data Link" or "Add ODBC connection" or "FDO import", or some other fonctions...
What I would like to do is find a way to use a dynamic block, which has already been created, and once I put in the proper length, speed, type of conveyor, etc., it will automatically update an excel spreadsheet, for example a power estimate, or cost estimate sheet. Is this possible, if so, what is the quickest, and easiest way to do this?
Also, what formula would I use in excel to link back to the DWG?
Ok what I'm tring to do is have a spreadsheet that has a list of prices in it that we could modify if needed for all these parts i'm making. Best way is to have the spreadsheet obviously external of the file.Though now I do not know how to do this in iLogic.And example of what I'm trying to do is, with 3 parameters.
A, B, and P
Value "A" and Value "B", these are just read items which when combined will give Value "P" to be imported into the Part file. So need A & B to be read and give the row number for P to be imported.
Regarding the conversion of an excel sheet into Illustrator variables... I am able to import an excel sheet into Illustrator datasets. I am curious if it is possible to link the excel file to the Illustrator data sets, so that when I alter something within the excel sheet, the data sets automatically change. Is this possible? Or must I always freshly convert/import the excel file?
View 2 Replies View RelatedImagine i have a polyline(2d or 3d doesn't really matter),and i want to extract the coordinates info of every vertex on the polyline from start to end.
How do i do that in AutoCAD?And if not is there a way to do it on any of the verticals?
I have to tabulate the X and Y co-ordinates along a polyline at 1 metre intervals. I have divided the polyline into segments of one metre and have tried to use a command called data extraction. So I use this command and individually click on each point. The end result gives me the X and Y coordinates in the order I have picked them however when I put it into a table on the drawing it messes up the order?
View 4 Replies View RelatedIs it possible to extract coordinates to a spreadsheet or display them on screen of points in AutoCad. I would like to know the coordinates of all the intersections of the lines in the model shown in the attached pdf. The 3d model was drawn in Revit as model lines. If there is a simple way to draw this shape in AutoCad, it is part of a torus.I imported it into AutoCad as Revit had a few limitations.
View 5 Replies View RelatedI am busy writing a small app to find a best fit circle through a series of points that roughly follow the profile of an arc. This data was scanned in using a Farro arm and imported to AutoCAD.
I would like to use VB.Express and the AutoCAD API. So far I have managed to write some code (loosely based on some examples from the AutoCAD .NET Developer's Guide) to allow the user to select the points to process.
I have three questions around this issue:
a.) How can I set up a selection filter to limited the user's input to 2d points only?
b.) Once I have the selection set of points, how can I extract the "X" and "Y" values of each of the points to be able to process further?
c.) Is there some sort of Object model diagram for the AutoCAD API that I can download, or any (downloadable) literature to get started with the API and VB.Express. I have looked online for some books and Amazon list them, but a. they are in hardcopy format and b.) the most recommended one (i.e. VB.NET Programming for AutoCAD Customization - Level 1 Jeremy Winters) is out of print. I am specifically looking for downloadable books because of the delivery times and shipping costs to get a hard copy.
I have a program that I used years ago to extract attributes from AutoCAD into excel. The VBA program is in excel. It is Attribute extraction Utility for AutoCAD Release 14. I want to use it again for 2014 but when I run it I get a compile error can't find project or library and it highlights the the following code "set doc = ACAD.ActiveDocument". Below is the entire VBA sub routine.
' THIS EXTRACTS THE ATTRIBUTE VALUES FROM AUTOCAD TO EXCEL
Sub Extract()
Dim sheet As Object
Dim shapes As Object
Dim elem As Object
Dim Excel As Object
Dim Max As Integer
[Code]...
I want extract a (x,y,z) point from a text file and want to put marker to that point in a dwg file. how can I accomplish that?
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 enter data into an Excel job setup worksheet. I then want to be able to extract data from given cells in the Excel worksheet, and have this become fields in AutoCAD. I do not want to use a table in AutoCAD - I want (ideally) to have the Excel data come in to AutoCAD as a field. I can see that Data Links tends to come in only to a table in AutoCAD.
View 1 Replies View RelatedI'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 doing some work with routed tubing at the moment using the Excel XYZ upload facility with auto-bend enabled and it works great. What I would like to know is if there is a way to edit an individual intersect point after the 3D line has been created? I've tried myself but can only movethe complete line, (all coordinates).
I would also like to know if it is possible to extract all XYZ intersect points back to excel or a table within Inventor so I could use the data with a CNC bending machine? Even displaying all coodrinates on the screen at once would be useful.
A working example would be as follows..., I will upload the customers XYZ data to create a 3D line, modifiy specific intersect points to simplify manufacturing and then extract the new co-ordinates to be used for prototyping purposes.
I have an excel document with a document header reserving rows 1-12. When i use "extract data" in autocad, i don't want the excel header to disappear. Can i set another cell than A1 to be the starting cell in Excel? Or how do i keep the header in the document?
View 5 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 do I transfer coordinates from excel 2003 to autocad 2004?
View 9 Replies View RelatedI'm dimensioning an old drawing with the real (measured) dimensions and with the drawing dimensions in brackets (using ' 1500 (<>)' to give '1500 (1505)' for example.
What I'd like is to also be able to put on the difference between the length I type in and the length in brackets - as this would let me see any really glaring errors that can't be attributed to user-error on the laser measure.So I could type in '1500 (<>) (X)' where X is the formula, and get ' 1500 (1505) (5)' back?
How to be able to run a script that could highlight any dimensions where the number is brackets and the typed number have a a difference of, say, 50.Or failing that, any way to extract all the dimension text at the end into excel so I can see the differences myself?
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 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've spent the last 4 hours searching for an answer to this question, but I simply can't find one.
As a start I think you have to know that I'm currently using AutoCAD 2012.
Here's the problem: I need to extract some info from an AutoCAD table to a reference file that can be opened in Microsoft Excel. Everything I find on the subject is actually an answer to the question "How does <DATAEXTRACTION> work?" or "How to do an extraction of DATA in AutoCAD?"....
In this particular case I have a set of production drawings (cut tickets) for manufacturing of stone. And in every single sheet I have this material schedule or a table, if you wish, that is made with an AutoCAD table. In this schedule I have the height, width and thickness of the stone plate and with a function it measures it's area and volume. What I want to do is to extract those values into a reference file that I can open with Microsoft Excel, as I already said.
How exactly?
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 want to extract the metadata I have added to my images and export it into an Excel spreadsheet. Can this be done within LR4.4? If the software doesn't have a function for this is there another way to do it?
View 2 Replies View RelatedI 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 have a drawing which has hundreds of levels on and i'm trying to establish what the MEAN level is and the AVERAGE level. I thought the best way might be to extract the text to excel and perform it there but at the moment the only way i can do it is to copy and paste the text and its taking me forever. Is there a way to either a) extract text to excel or b) calculate a MEAN value based on texted selected?
View 2 Replies View Related