AutoCAD Civil 3D :: Data Linked Excel Table
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
ADVERTISEMENT
Sep 9, 2011
I recently decided to see how the AutoCAD tables work. I was very happy to learn you could link your Excel spreadsheets with CAD. But now I have a problem.
After inserting the table it refuses to use the table style I have set up. The fonts do not want to change at all. I can change the colour of the text, but not the font.
PS: Using AutoCAD 2011
View 7 Replies
View Related
Sep 24, 2012
I have linked a table from excel into autocad 2012. I have selected "Start with excel formatting, do not update" in the datalink options. My problem is when I break the table the first table will keep my formatting changes - text height and alignment, but the following table breaks do not stay the same once I close and reopen the drawing
View 1 Replies
View Related
Sep 25, 2012
I have set up some autocad tables that are linked to excel data( using relative path) in an Autocad Architecture project template. In the xref dialog box, the data links are show as relative path e.g. ..Standards excel file
After creating a new project from this template and right-clicking in one of the cells which have linked data and selecting "data links" and "open data links file" it opens the template excel file, not the excel file within the project folder.
If I use the xref command, select and right click one of the excel data links and select "open" it does open the correct excel file located in the current project folder.
The xref dialog box does show all the data links as relative path e.g. ..Standardsexcel file.
View 1 Replies
View Related
Apr 19, 2012
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?
View 0 Replies
View Related
Aug 15, 2013
I have been using a lisp routine to strip formatting from a linked excel sheet. (stripmtextV5) .When I try and run it on a sheet today it says some cells are locked. I've changed the cell format in the excel file to unlocked. I have unlocked the cells in the linked table. Yet it still says that some cells are locked...I have even picked in each cell to verify each one is unlocked.
View 5 Replies
View Related
Sep 28, 2003
If it is possible to plot points (or a PLine, or a mesh) in AutoCAD from a table of values in EXCEL (columns of x,y,z coordinates).
View 8 Replies
View Related
Apr 26, 2011
we recently were trying to import an excel table via data link function. Initially this works fine and the table appears in the drawing however when we want to break the link by deleting it in the data link table autocad tells me that the link is in use. We routinely do this in autocad mechanical 2010. The reason we do this is to be able to bring in the table and preserve formatting. How can we easily delete the data link in 2010 LT?
View 9 Replies
View Related
May 5, 2011
I struggled for a while this morning with trying to data link to a large door schedule in Excel. After several failures, I searched online for answers, and read in another forum that AutoCAD won't data link to more than 2000 cells.
My door schedule is about 2050 cells now, and will be about 4000 when done. I defined a set of about 1,000 cells in the Excel spreadsheet, and AutoCAD linked to it no problem. So, I tend to believe the poster who stated the 2000 cell limit, but I can't find this.
View 1 Replies
View Related
Dec 6, 2012
I just began messing around with linking excel and autocad (disappointed that you can't link to .xlsm but that will go on the wish list). I was wondering if there was already a post as to how to not lose your fields when you download from source. I have a table that has fields from my sheet set with drawing names etc...but everytime I click download from source it converts the field to plain text.
View 9 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
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
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
View Related
Nov 20, 2012
I am wanting to use an Autocad table object to display fields from an Access database table that is linked to symbols in my drawing.
My objective is create a database table that has detailed notes for call outs in my drawings and then link my call out blocks to the database table and display the blocks and linked descriptions in an Autocad table. If the notes in the database table are edited the Autocad table updates with the new the description from the database.
View 1 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
Jun 19, 2012
I was trying to export my alignment, at certain intervals, to excel (or text) as xyz data. I tried searching and found... Alignment to xyz
But it didn't really work. I can export the XY but not the Z in the report manager.
So my questions are.... How can I create a new report to incorporate the Z? Or is there another way to do it?
I should add I also tried the "Incremental Stationing Reporting" from the Profiles Report... However it doesn't recognize the profiles I've created? I get the "No FG profiles in....." even though there are?
View 7 Replies
View Related
May 20, 2013
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 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 19, 2013
I 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 Related
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
Mar 19, 2013
I want to export data from AC3D to Excel; I've tried to do it with copying directly the tables I made, but it isn't text or number format.For example, I want to get the data from this table:
I know that with previous versions of autocad it could be done.In addition, I also want to get value table of the calculated cant of the "Cant Tabular Editor":How can I get a table of this data? I need it because I have a lot of curves and I want to do some verifications of the standars of my country.
View 4 Replies
View Related
Apr 19, 2013
I want to export my slope - table - legend to an excel or txt file.
(Of course only the values)
Civil 3D (2013)
View 2 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
Jun 26, 2013
I am using Rel 2013 C3D
How do I remove excel data links from my Reference Manager (see attached image). What I have been doing is AutoCad erasing the graphics from my drawing but the link still remains in the xref manager window.
View 5 Replies
View Related
Apr 12, 2012
I am just wondering whether FIELD category can access the OBJECT DATA Table ?
I want to use a block to display its OD table's attributes as Annotation text , so that the Text will update when the OD table change.
Or do I need use the Data connection for this purpose ?
View 9 Replies
View Related
Jun 6, 2013
I want to copy just two pieces of information from a pipe network into a table. I would just generate an automatic pipe table, but those are not editable. Any quick way to copy and paste the pipe lengths and names in a network into a "regular" table?
View 7 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
Dec 2, 2013
I need to produce a better standard table for our company, but need to know how it would be possible to display only either the START STAKE VALUE/ STATION or END STAKE VALUE/STATION in the appropriate column. If I can achieve this i would not need to details for straight segments as indicated in the details column.
View 5 Replies
View Related
May 11, 2012
Regarding the image below. What is the best procedure to develop such a table automatically in Civil 3D. We are using AutoCAD Civil 3D, and the table was developed with the TABLE command. Everything else was added manually.
View 1 Replies
View Related
