![]() ![]() ![]() You will have to make sure you have Microsoft Excel installed on your machine for data linking to work, but the end result is worth that (pretty small) hassle. Data linking is the ability to link a Microsoft Excel spreadsheet or CSV (Comma Separated Value) file to an AutoCAD table. The vast majority of projects he has been involved in have been permitted and built.AutoCAD tables are great - however, in some cases, using Excel is just the better way to edit spreadsheet-like information. Simmie has a solutions-based focus that has served his clients very well. He quickly learned proprietary computer engineering systems such as Wang – Holguin, Vango and MS Dos based AutoCAD which transitioned from SoftDesk to Land Development Desktop to Civil 3D. His start with a small surveying firm as a drafter in Oakland, CA provided a good base for transitioning and becoming a designer / engineering technician utilizing Computer Aided Design software. He has been involved in key projects from Civil Site, Subdivision, Rail Transit, Airports, Highway, Utility Infrastructure, and Utility Scale Solar Farm site layouts. Infrastructure Applications ExpertSimmie has diverse experience in Civil Engineering design and Survey Mapping support since 1979. Important: Make sure that the linetypes in the Excel Spreadsheet existing in the drawing being used in the script. You can now use this drawing in further development of CAD standards and template creation. ![]() You can see from the screenshot above that the layers, index colors, linetypes, lineweights and descriptions have been created successfully. Since Stage 3 is frozen, it retained some information from the first 2 stages that need to be reconciled with the last stage. If there is an error regarding a layer not existing, save the dynamo script and re-open and run it. This node will read in the descriptions as long as the layers exist (which they should from Stage 1). Now run Stage 3: Unfreeze the Layer.SetDescription node.After Stage 2 is executed, Freeze the associated nodes again. Now run Stage 2: Unfreeze Document.LayerByName and Layer.SetColor nodes.After Stage 1 is executed, Freeze the Layer Create Node. If there are no colors, it will create colors as 255,255,255. The RGB portion is used and can be populated or not. This node uses a Color by ARGB node to initially create the layer colors. Stage 1 is executed which uses the Layer Create node.The 3 stages are grouped and executed in order.These nodes grab the data from excel for creating layers, colors, linetypes and lineweights. ![]() Once the file is read, several List operations need to be performed:Ī List.Transpose node is applied so we can get index items and filter / select entity groups.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |