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.
View 3 Replies
ADVERTISEMENT
Jan 18, 2013
I have some data in the form of
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.
View 4 Replies
View Related
Jul 9, 2012
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.
View 5 Replies
View Related
Nov 5, 2013
I'm wanting to know if there is a way to Copy a selected area from Excel and Paste into Autocad and have it as lines and text objects?
Before everyone is entering the information in RED multiple times, once in excel and again in our cad file.
I don't want a data link because we are sending, only, cad files to our customers.
View 6 Replies
View Related
Feb 13, 2012
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?
View 3 Replies
View Related
Nov 7, 2012
C3D 2012
Is there a 'property' to use the Point Group Name. I need it in the Point Table Style: Title text like this:
View 4 Replies
View Related
May 22, 2006
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?
View 9 Replies
View Related
Oct 24, 2013
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
View 5 Replies
View Related
Mar 15, 2012
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.
View 9 Replies
View Related
Feb 5, 2013
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..
View 5 Replies
View Related
Oct 16, 2012
I need to export the surface lable table report into microsoft excel format.
View 5 Replies
View Related
Jul 4, 2013
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
NB: Am using MS Office 2010
View 1 Replies
View Related
Nov 13, 2013
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.
View 1 Replies
View Related
Mar 12, 2013
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.
View 1 Replies
View Related
Mar 14, 2013
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)
View 2 Replies
View Related
Jul 28, 2011
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
View 3 Replies
View Related
Mar 8, 2012
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...
View 5 Replies
View Related
Jun 24, 2013
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.
View 3 Replies
View Related
Aug 23, 2013
How to truncate coordinates in a C3D point table?
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.
C3D - 2014
View 2 Replies
View Related
Jul 20, 2013
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.
View 3 Replies
View Related
Aug 6, 2012
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.
View 2 Replies
View Related
Dec 13, 2013
How can I export a excel table to Autocad not as an OLE object but as a Audocad table?
View 7 Replies
View Related
Mar 15, 2012
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?
View 6 Replies
View Related
Dec 1, 2012
How would I create a Point Table that would allow me to have Point#, Type, Size in individual columns when I have decription keys that area like this;
GUM 6 to be a 6" GUM.
Is there any way to have the data for the Type in one colum and the size in another?
C3D12
C3D12-13
Win7x64 6gb
View 3 Replies
View Related
Jun 1, 2010
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?
View 9 Replies
View Related
Feb 27, 2013
How to insert the point table into paper space rather than model space and creating a mview?
Also, is there a way to add the point style symbol to the table?
View 6 Replies
View Related
Apr 21, 2013
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).
View 4 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
Mar 18, 2012
I 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 Related
Apr 3, 2012
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?
View 5 Replies
View Related
Feb 24, 2012
I have a table with some Field, how can I export it to Excel? I have tried to export it to .CSV but the Formula has gone .
View 9 Replies
View Related
