AutoCAD Civil 3D :: Linking Parcels To EXCEL
Apr 4, 2012
Create a large number of polygons (plines, parcels, whatever) that represent spaces on a building plan
Assign a space number to the polygon
Link the space number to an Excel spreadsheet (or Access DB) so that the characteristics of the polygon (line and fill color, for example) are chosen based on the "owner" of the space (e.g.; Engineering, Common Areas, etc.).
Display a label stating the space number and the space name. Is this best done with "Parcels" in Civ3D, or with "Polygons" in Map, or some other way.
View 3 Replies
ADVERTISEMENT
Aug 1, 2012
Well I had a day and a half trying to figure out how to bring Excel data into LT. Again. Here is what I have found out:
Running Excel 2010 I have a xls files (of type '97-2003 xls - file includes VBA). The file spits out a ton of data that I want to put in a schedule in AutoCAD. The schedule format needs to match our standard format - RomanS in white and blue.
If I copy and paste as a link the font remains stuck as Arial (regardless of source font) and can't be relaxed unless you go one cell at a time in the text editor. Also the resultant table size is tiny -
If I save the file to .XLSM (macro enabled '10 excel file) the results are the same. If I save the file to .XLSX ('10 excel file and ditch the VBA project) the results are sublime - the font is ok and I can go back and forth from AutoCAD to my now broken spreadsheet because VBA IS MISSING! The resultant table size is tiny but I can deal. I don't see how AutoCAD can work with xlsx but not xlsm.
I also found that if I save the sheet (values only) as a .csv file I can use that to create a table from file without font overrides screwing everything up.
I'm running AutoCAD LT 32bit on a Win7 32bit OS. My Office version is 2010. I would like to link data to a '97-'03 version of an xls or an xlsm without having the font overridden to Arial.
View 1 Replies
View Related
Mar 3, 2012
I am linking a model to an excel spreadsheet. Normally you would specify what cell on the first sheet (Sheet1) to start in. I have been told that you can link to other sheets in the workbook as well. Is this possible? I have tried, but have not been successful. If it is possible, how is it done?
View 6 Replies
View Related
Aug 25, 2011
I'm trying to figure out a way to do the following:
I have several drawing files in DWG. Each DWG has a block placed in a drawing sheet. The block contains attributes which would like to link to an Excel file.
Then if I update the attribute in the drawings this would change the linked attribute in the Excel file, and vice versa.
Note that there are several drawings which I would like to handle in a single Excel file.
View 3 Replies
View Related
Feb 1, 2012
I need to export the areas of multiple closed polygons to excel and update that excel as soon as the areas change. We've been using an outside contractor who is able to do this using land f/x.
View 2 Replies
View Related
Mar 21, 2013
How can i change the front (lines facing to the streets) line color from parcel? My parcels lines must have two colors.
I send in attach an example.
View 2 Replies
View Related
Jan 10, 2013
I'm trying to clean up the drawing. I have erased everything, but there are still 20572 parcels somewhere in the drawing that I couldn't delete.
The file is too big to attach so use the link to download:
[URL].........
View 9 Replies
View Related
Aug 30, 2013
As everybody know copy/paste excel file into an inventor drawing is sometimes difficult. As you can see in the printscreen a special character is not converted. I supposed it's because this special character is not in the AIGDT or is in the extended character set wich is not considered in Inventor?
View 2 Replies
View Related
May 31, 2013
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...
View 9 Replies
View Related
Nov 12, 2013
I want to get vertex from survey figure or parcel.
I have seen this for feature line: [URL] .....
But "Autodesk.AECC.Interop.Land" doesn´t have AeccLandSurveyFigure.
How can I do it? Is it necessary convert survey figure to polyline?
Autocad Civil 3D 2014 +SP1
Quad Core Intel i7 3770-cpu 3.40Ghz.
ssd samsung 840 pro 512gb+ssd samsung 840 pro 256 gb+1tb hdd
32gb RAM 1600 Mhz.
nVidia Quadro 2000.
Win 7 Pro 64bit
View 6 Replies
View Related
Aug 9, 2012
Is there a way to improve the error of closure of a Parcel. I have one Parcel that has an EOC of 0.0161'. That's a little higher than I like to see. I understand that some of this has to do with the precision of the analysis. But with bearings to the second and distances to the hundredth, I'd like to think we could do better than that.
I suppose that if I changed the POB the closure might improve. But I want the POB to be the closest corner to an existing monument.
View 4 Replies
View Related
Jun 24, 2013
was showing it off in class and it's always worked before but now it's not working on any of the computers. Just tried it on my laptop with the same results. I originally thought it was an issue with 2014 but 2013 isn't working either (and I know it was working in the past).
The only thing I can think of is my computer recently upgraded to IE10. Could that be it?
View 9 Replies
View Related
Jun 5, 2013
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?
View 9 Replies
View Related
Mar 6, 2012
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.
View 3 Replies
View Related
Oct 26, 2009
when i try to link an excel file to the parameters dialog box i get a message telling me it is "NOT IMPLEMENTED". i just upgraded to windows 7 because it is now supported by autodesk.
View 9 Replies
View Related
Jan 7, 2014
I am trying to link excel file to drawing file (idw), but couldn't succeed.
View 2 Replies
View Related
Jul 9, 2012
I've previously used Autocad 2008 Electrical. I've just started a new job and I have been asked to update some electrical drawings from a recent project. My current employer use Autocad 2010 as opposed to Autocad Electrical which I have previously used.
The problem I have is that I have a drawing with a table linked to an Excel spreadsheet that displays an I/O table.
Since the drawings have changed the amount I/O has increased.
I have a new excel sheet with the new I/O list which is larger than the old I/O list.
When I "point" the Table to look at the new spreadsheet in the "Modify Excel Link" Dialogue and alter the "Link to Range" Tab to my new desired excel sheet and apply the changes the table. The new excel sheet populates the table correctly until the end of the old table used to stop then the format goes all to hell and the new part of the table is way out of scale and at 90 degrees out to the original table.
I think I am possibly missing a step somehwere when updating the Data Table Links!?!?....Do I need to alter the table properties somewhere too?.
View 2 Replies
View Related
Apr 3, 2013
Any lisp routine that will remove "phantom parcels" in a drawing? They are the parcels many topics on this discussion forum have topics on, that can be selected but can't be deleted by any simple means.
The drawing is relatively new...with minimal objects in it. Just some Feature Lines and 3D Polylines. I have Sites in my drawing...but no parcels. Only thing in the sites are the feature lines. When I do a Q SELECT for the parcels it selects and highlights my feature lines, which is weird.
View 5 Replies
View Related
Aug 21, 2012
Any way to create a parcel from an object (closed polyline) and populate the parcel with Object Data from the polyline?
I have imported a .shp file into a drawing and the result is many closed polylines with properties similar to the attached image. I would like to bring this data into a parcel object for labeling purposes.
View 1 Replies
View Related
Jan 16, 2012
Op System: Windows 7 Home Premium
Processor: Intel Core I7 960
Ram 12.0 GB system 64 Bit operating system.
MIcrosoft Excel info: Excel 2010 (14.0.4756.1000) MSO(14.0.5113.5000) Microsoft Office Home and Student 2010
Inventor Info: Autodesk Inventor Professional 2012 54 bit edition
Build: 160, release 2012 RTM Date 3/1/2011
When trying to link to excel file get error "Not Implemented". Have tried the registry 'fix' - does not work. Need to get these links working to drive models. This same Excel version works fine for Solidworks which inks perfectly with no issues whatsoever. Inventor has been a problem for 2011,and now 2012 - still not working.
View 2 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
Sep 3, 2013
I have 4 points/corners (with XYZ-coordinates) of a square shape created in the DWG of my AutoCAD Civil 3D 2013 program. I want to create 2 "triangle-shape" parcels (one parcel connects Points #1-#2-#3-#1 and the other parcel connects Points #1-#4-#3-#1. How can I create these 2 "triangle-shape" Parcels from the 4 points/corners of a squre shape?
View 9 Replies
View Related
Nov 20, 2012
I'm really in trouble at work on linking Microsoft excel tables to Photoshop. I have some excel tables. I want to import them into Photoshop (not as an image) that when i changed the values in cells (excel) i want the Photoshop file to update.. Should i use a script or any programs?
View 3 Replies
View Related
Jan 15, 2013
Is there a possibility to furnish a hyperlink linking on a defined Excel-data sheet within an Excel file? Are there other possibilities to tie together to a drawing object external additional information, e.g., a product name, product data or product pictures?
View 1 Replies
View Related
Jul 25, 2013
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 Related
Nov 26, 2011
I'm having some trouble setting my workflow and I need linking data to corel draw from excel. Basically, what I want to do is to have excel data automatically copy from Excel to Draw and "Paste Special / Paste Link Objects/MS Excel Worksheet is almost what I need.
It would be perfect if only it would copy CONTENT of the Excel file or cells, not their formating (font, size, border etc.) which I want to do in Corel, since separation of the content (excel) and form (draw) would be just natural and functional - don't want my number crunchers to affect design of the Draw document, just as I don't want to have my designer to do the math
So - is there way to link objects (cells from Excel) but to transfer content (text) only or should I revert to VBA?
View 1 Replies
View Related
Mar 14, 2012
I'm currently working with AutoCAD Civil 3D Land Desktop Companion. The drawing has hundreds of callouts for different elements all over the site. The callouts are in form of a block, with a number inside. The number corresponds to a notes page which lists each detail in chronological order. (nothing new there)
Due to an expanding and shifting job site, notes have been added and deleted. The problem is now we have to go back through and update all the callout blocks. For example: We have 75 notes in our list, if note number 3 changes or is deleted, we need to go through and change all the numbers in all the blocks to reflect the change to the list.
Is there a way to link blocks to an mtext list? or possibly a spreadsheet?
View 2 Replies
View Related
Apr 16, 2012
Is there a way to link feature lines to points? If I have a series of points and I've joined them with a feature line; I want the feature line to update automatically if I adjust a point elevation.
View 4 Replies
View Related
Jul 24, 2013
See how linking is happening between points along the same survey line? How to prevent this?
View 4 Replies
View Related
Feb 12, 2013
I am using Civil3D 2013. I was wondering if there was a way to link your dwg to a master dwg file? For example, if i were to copy the dwg into folder A and copy a dwg into folder B. I would then update the master dwg with either a layer color change or linetype or add a layer / label etc, could those changes from the master be (linked) or a child or the parent master dwg? Or does this work with dwts?
View 8 Replies
View Related
Oct 12, 2011
I have been creating grading objects from my curb lines, assigning grades using the editor, then offsetting that line for the BACK of curb, and using the raise-lower command to raise the curb line height. If I edit the original face of curb line (gutter grade) then I go back and redo the process. Is there any way to intelligently link these two lines so that if one gets edited C3D knows the other is 0.5 feet higher (or lower) than its neighbor?
View 9 Replies
View Related
