AutoCAD Civil 3D :: How To Copy Point Table From Excel
Oct 22, 2013
This seems like it should be the most stupidly easy thing...but AutoCAD doesn't seem to have a way to do this. I made a point table from a point group. Quick and sweet.
But now I want to change it a little bit, and it's not something I can just do from the table style. So I want to copy it into Excel...and when I try to, hitting paste in Excel ends up just giving me this block image version of the table in Excel. I tried doing TABLE EXPORT but that's only for regular tables.
point# | X | Y | Desc_1 | Desc_2 | Desc_3 |....... ect
I would like to make an excel table that i can create multiple points from and make that table dynamic, ie if i edit the table the points will change.I would be labeling the points according to the different desc_# in multiple drawings
Is there any way to do this? I have messed with creating a user defined property classification and creating a new point file format, but i want that point file I imported to be dynamic, and if I change values the values will change in all my drawings.
I have a table in Excel (well several tables actually) that I want to copy the contents from and insert into an AutoCad table. I don't want it as an OLE object (as I need to be able to edit it in AutoCad later if needed) and I don't want it as a datalink either, so what is the best way to do this?
I was trying to just copy the cells although kept getting all cells ending up in each row/column. I believe it is possible somehow as I am sure I have done it multiple times before although can't work out how to do it now.
We have a whole bunch of spreadsheets that we use for calculations and parts of those spreadsheets are linked to a ton of CAD Drawings via data links.
We would like to be able to deliver the CAD drawings to the client without having to send our calculation books (just the output tables). In other words, is it possible to embed the table data and remove the excel link for the final delivery?
I have a number of tables which have all properties about the pipe network with the cooridnates and upstream/ downstream info. Can it import to C3D and automatically generate the pipe to 3D?
I am trying to insert an excel table using a datalink. If I insert the entire sheet, it includes too many cells. If I set a print area and choose that area, it will not insert the table. The first time it acts like it is going to work, but then never lets me place the table. The second attempt it just will not let me select that data link. If I actually name a group of cells, I get the same behavior as the print area. Have issues with importing excel tables? Am I missing a step?
My work flow is
Create an excel sheet & format the table.
Select desired sells, set print area.
Save & Close excel
go to annotate tab in civil 3d
select table icon
choose from data link
launch data link manager
create data link and choose range of cells as print area.
Press OK
it never let me choose insert point.
I have also tried to simply make the datalink and then run the table command with the same results.
Civil 3D 2013 HP Z400 Workstation 6GB of RAM 296GB HDD ATI FirePro V5700(FireGL) Win 7 Home Professional
How to insert a linked excel table into my drawing, however I have not figured out how to add rows to the table, the option is greyed out. I can insert rows above and below the (inserted) table but not anywhere in the middle.
I've tried everything I can think of, even removing all the formatting in the .xls spreadsheet to no avail. The cells are unlocked, I can manipulate the data, but not being able to insert rows is really hindering the efficiency of using a data linked table.
The PLS I work under inquired if the pipe and structure tables provided in our construction plans are able to be exported to excel. The only way I know how is to use the reports manage. The problem is, the provided Pipes reports don't contain all the data we are looking for. How do I modify, or create a new, Pipe report? It seems like it should be really easy to export the data to excel..
I have an excel sheet containing alignment coordinates i.e
Station Number Northings Eastings and Tangential Direction
I wanted to export these into Civil 3d so that I can work with the info. What format would I save my excel document? is it 'text (tab delimited)' or 'csv (comma delimited) or formatted text (space delimited)?
I've tried all the above but I keep getting an error message from AutoCAD that point files not in right format
Where should i insert my point tables? In the model or the paper space?
in the paper space it seems that i cannot control the insertion scale?? i set specific letter height that works fine at the model but in paper every time i create a table I see different size depending on the zoom I have.
When I create multiple tables for different point groups, I cannot change the table title without all the tables changing to that title. I want each table to have an individual title.
In our company, we put Excel tables in our drawings. The reason we've chosen for Excel-tables is that we can adjust the layout of the table quite easily. These tables consist of grouped cells in a particular company-specific layout. We select the range of the desired cells, copy and paste them in our AutoCAD drawing. This drawing is sent to our customers. The disadvantage of this method is, that when our customers (who use CAD-software of other brands) open the dwg, they don't see the table, but some kind of picture of the table.
Is there a way to 'explode' the excel-table, but keep the specific layout of the table? For attributes in blocks there's the 'Explode Attributes'-command in the Express-tools, but is there something similar for Excel-tables?
Product Design Suite 2014 Inventor 2012 SP2, Vault 2014 HP Workstation Z220 Intel Xeon 3.4GHz 16GB RAM Nvidia Quadro 4000 Windows 7 Professional (64bit)
I'd like the option of manually entering information in one column of my point table. I can see how to create a blank column with a title, but how do I edit those cells?
In my particular case I use a point label style in my drawing that contains "Full Description": "PK8", for example. This works great for displaying my point in the drawing - I DO want the number to appear - but when I want to see it in a table, I just want to see 'PK' in a Description column, next to the (obligatory) 'Point Number' column. Having the Description column read 'PK8' next to the point number is redundant. I don't see how I can get this in automatically
I'm looking to add a column to my point table that will subtract a fixed number from all my surface elevations. I'm working in 2011 Civil 3D. I've been researching this for the past couple of days and haven't been able to come up with anything solid yet...
I have a problem in Civil3d 2013 where at random I'll open up a drawing that previously had a point table created and all the point information has disappeared. All that remains are the Titles.
My situation is that I have ground coordinates that are similar to state plane, but because they are not on the grid, they aren't exactly the same. I want to display the coordinates without the first two or three numbers, in order that people won't get confused and think that they are on the grid.
Inclusion of “point groups” in a table, I wanted to include “point groups” in a table but couldn’t know what is the most appropriate command to accomplish this task.
I tried the “extract data” command (attached) but sounds not to produce the required table.
I'm having issues trying to create a point table. I have used this process before with no problem but now for some reason C3D won't create the table. I get an "NO VALID SELECTION" after selecting the C3D points. Why I'm getting this error? All my points are C3D points and C3D recognizes the points while the POINT TABLE CREATION menu is still visible but once it goes to create the table i get that error message.
I'm working with both Carlson 2012 and Civil 3d 2012 so this could apply to either one.
I have a set of caissons that were shot on separate days, and they started in the middle when they shot them in. I wanted to create a coordinate table, with the points listed from the northernmost point to the southernmost point. I had thought there might be a way to create a table with dynamic input, where I could pick the points as I go along and have the information entered as I pick.
Is there any way to renumber the points via drawing a polyline connecting them, starting with the one I want as #1 and ending with the last one?
I have been provided with Surveyed Utility Locates along an Existing Roadway. These are provided to show conflicts between the New Storm Sewer System and Existing Utilities such as Water, Sewer, Gas, Elec, etc. The survey however is incomplete as it was prepared a few years ago and the Storm Sewer has just been designed. Yes, I can create points and provide them to the County Surveying department. However, before this is done, I must provide an easily-understood format of the new survey locations to the County Project Management.
To provide a Point Table which references the Surveyed Points' location in reference to the roadway stationing (Alignment). I have attached what the point table is to look like.
I am unable to find the desired data reference in the currently provided data field selection. Am I just missing it or is this a "Wish List" item?
I have a 3D file (not of my creation) that gives me some problems when I try to copy it (it is a 3D building).
The problem is that, when i click on "copy" command, I can select a point but then AutoCAD crashes and it takes about 30 seconds to return working a normal way and permit me to paste it. (it happens with "move" command too)
Otherwise, if I use "copy with base point" I have no problems: after a second I can paste it where I want.
How can it be possible? Cause if sometimes I mistake and digit "copy", I always have to wait the long Autocad response.
This problem happens with both autocad 2012 and 2013 and it doesn't happen with other 3D files I have. The drawing is made mainly of meshes.
I have a Dell notebook and a NVIDIA Quadro 2000M video card, so you can understand I don't like this problems: I spent a lot of money for something I hoped could work well with AutoCAD.
About that, aren't there drivers for the graphic card? Cause when I click on "check for updates", autocad says me that there are newer version of the driver, but then it says me that it is impossible to update it (I have a connession and a student version).
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.
I have a table imported into autocad from excel, however despite the table (excel) being formatted, border lines appropriately placed and hidden througout the sheet, all off the border lines of the cells appear when imported into autocad.
is there anything i can do to hide back some border lines for selected cells?
